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
Last revisionBoth sides next revision
oracle:oracle_sql_querys [2020/04/01 16:02] – [Long operations] dodgerdba:oracle:oracle_sql_querys [2023/01/31 08:15] – 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>
  
  
-====== [DOC] Oracle basic queries ======+====== [DOC][OLD] Oracle basic queries ======
  
  
Line 113: 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 377: 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>