Differences

This shows you the differences between two versions of the page.

--- dba:oracle:oracle_sql_querys [2022/02/11 11:12] – ↷ Page moved from oracle:oracle_sql_querys to dba:oracle:oracle_sql_querys dodger
+++ dba:oracle:oracle_sql_querys [2023/01/30 14:55] – [Crear un directorio] dodger
@@ Line 1: / Line 1: @@
 <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 377: / Line 377: @@
 <code sql>
 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>