Sunday, September 23, 2007

something new learnt (outside oracle)

finally I am becoming a little HTML-aware person..
not anymore you are going to see messy formats in this blog as I just learnt (& tested) I could use preserve tags to avoid spaces getting eaten up and making the sql code and display totally clumpsy.

here is a test..

copy and paste of same text (from sql screen)

old way (how It appeared before)

OPERATION OBJECT_OWNER
------------------------------ ------------------------------
SELECT STATEMENT
SELECT STATEMENT
SELECT STATEMENT
SELECT STATEMENT
SELECT STATEMENT
TABLE ACCESS VENKAT
TABLE ACCESS VENKAT
TABLE ACCESS VENKAT
TABLE ACCESS VENKAT
TABLE ACCESS VENKAT
INDEX VENKAT
INDEX VENKAT
INDEX VENKAT
INDEX VENKAT
INDEX VENKAT


new way (from now on)


OPERATION OBJECT_OWNER
------------------------------ ------------------------------
SELECT STATEMENT
SELECT STATEMENT
SELECT STATEMENT
SELECT STATEMENT
SELECT STATEMENT
TABLE ACCESS VENKAT
TABLE ACCESS VENKAT
TABLE ACCESS VENKAT
TABLE ACCESS VENKAT
TABLE ACCESS VENKAT
INDEX VENKAT
INDEX VENKAT
INDEX VENKAT
INDEX VENKAT
INDEX VENKAT



Thats pretty neat!!

No comments: