Differences

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

--- oracle:oracle_sql_querys [2020/05/19 06:48] – [De una query] dodger
+++ dba:oracle:oracle_sql_querys [2023/01/31 08:15] – 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>
-====== [DOC] Oracle basic queries ======
+====== [DOC][OLD] Oracle basic queries ======
@@ 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>