dba:oracle:oracle_sql_querys
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
oracle:oracle_sql_querys [2019/07/18 07:17] – external edit 127.0.0.1 | dba: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: | + | THIS document is [[dba:oracle: |
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 | + | SET LINESIZE |
- | SET PAGESIZE | + | SET PAGESIZE |
SELECT * FROM table(DBMS_XPLAN.DISPLAY); | SELECT * FROM table(DBMS_XPLAN.DISPLAY); | ||
</ | </ |