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
dba:oracle:oracle_sql_querys [2022/02/11 11:12] – ↷ Links adapted because of a move operation dodgerdba:oracle:oracle_sql_querys [2023/01/30 14:55] – [Crear un directorio] dodger
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>