User Tools

Site Tools


dba:oracle:oracle_sql_querys

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
oracle:oracle_sql_querys [2019/07/18 07:17] – external edit 127.0.0.1dba:oracle:oracle_sql_querys [2022/02/11 11:12] – ↷ Links adapted because of a move operation dodger
Line 1: Line 1:
 <WRAP center round important 60%> <WRAP center round important 60%>
-THIS document is [[oracle:basic_oracle_sql_querys]] but with the parts splitted removed</WRAP>+THIS document is [[dba:oracle:basic_oracle_sql_querys]] but with the parts splitted removed</WRAP>
  
  
Line 39: Line 39:
  
 <code sql> <code sql>
 +
 +COL UNITS FORMAT A12
 +COL opname FORMAT A30
 +COL target FORMAT A30
 +COL message FORMAT A70
 +COL SID_SERIAL FORMAT A15
 +
 select * from select * from
 ( (
Line 106: Line 113:
 y y
 <code sql> <code sql>
-SET LINESIZE 130 +SET LINESIZE 280 
-SET PAGESIZE 0+SET PAGESIZE 999
 SELECT * FROM table(DBMS_XPLAN.DISPLAY); SELECT * FROM table(DBMS_XPLAN.DISPLAY);
 </code> </code>