Ciberterminal Wiki

User Tools

Site Tools

Trace:
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 [2023/01/30 14:55] – [Crear un directorio] 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>
Line 370: Line 377:
 <code sql> <code sql>
 CREATE DIRECTORY <IDENTIFIER> AS '/real/path/of/disk'; CREATE DIRECTORY <IDENTIFIER> AS '/real/path/of/disk';
 +</code>
 +===== List directories =====
 +<code sql>
 +col directory_name format a40
 +col directory_path format a160
 +select directory_name, directory_path from all_directories ;
 </code> </code>