dba:oracle:oracle_sql_querys
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
dba:oracle:oracle_sql_querys [2022/02/11 11:12] – ↷ Links adapted because of a move operation dodger | dba:oracle:oracle_sql_querys [2023/01/31 08:15] – dodger | ||
---|---|---|---|
Line 3: | Line 3: | ||
- | ====== [DOC] Oracle basic queries ====== | + | ====== [DOC][OLD] Oracle basic queries ====== |
Line 377: | Line 377: | ||
<code sql> | <code sql> | ||
CREATE DIRECTORY < | CREATE DIRECTORY < | ||
+ | </ | ||
+ | ===== List directories ===== | ||
+ | <code sql> | ||
+ | col directory_name format a40 | ||
+ | col directory_path format a160 | ||
+ | select directory_name, | ||
</ | </ | ||