But it still doens't quite working. The code to get rid of the number is ..
sed 's/^\s*[0-6]\+//' myfile
but myfile still shows the numbers..
1 create view session_trace_file_name
2 as
3 select lower(d.instance_name || '_ora_' || ltrim
4 from v$process a, v$session b, v$instance d
5 where a.addr = b.paddr
6 and b.audsid = sys_context('userenv','sessionid') ;
from v$process a, v$session b, v$instance d
I'd like the output should be like this
create view session_trace_file_name
as
select lower(d.instance_name || '_ora_' || ltrim
from v$process a, v$session b, v$instance d
where a.addr = b.paddr
and b.audsid = sys_context('userenv','sessionid') ;
from v$process a, v$session b, v$instance d