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 revisionBoth sides next revision
dba:oracle:oracle_sql_querys [2022/02/11 11:36] – external edit 127.0.0.1dba: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>