cancel
Showing results for 
Search instead for 
Did you mean: 

SQLTEXT indenting....

Ash_4
Advisor

SQLTEXT indenting....

HEllo,
I'm collecting the user info. and sqltext from v$session and v$sqlarea. Is the any C program or shell script to indent the sqltext properly.
Thanks in adv.
1 REPLY
Wodisch_1
Honored Contributor

Re: SQLTEXT indenting....

Hi Ash,

since SQL is free-format by design, there actually is no "poper" indendation...
But if you check the OpenSource RDBMSs (like MySQL, PostGreSQL), you might find pretty-printers and auto-formatting editors for those...

Sorry,
Wodisch