Man, I <I>really</I> do not want to do this by hand.<P>To put it simply:<P>I have a bunch of SQL Server 7 scripts.<BR>I need them to be a bunch of Oracle 8.1.6 scripts instead.<BR>Is there any ...
--select * from table(dbms_xplan.display_cursor(:SQL_ID,0,'ALLSTATS LAST')); --select * from table(dbms_xplan.display_cursor(:SQL_ID,0,'TYPICAL OUTLINE')); select ...
DECODE(lo.locked_mode, 0, 'None', 1, 'Null (NULL)', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share (S)', 5, 'S/Row-X (SSX)', 6, 'Exclusive (X)', lo.locked_mode) locked_mode, ...