Operating System - HP-UX
1748279 Members
4280 Online
108761 Solutions
New Discussion

Re: 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 1
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