dba:oracle:oracle_sql_querys
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
oracle:oracle_sql_querys [2020/04/01 16:02] – [Long operations] dodger | dba:oracle:oracle_sql_querys [2023/01/30 14:55] – [Crear un directorio] dodger | ||
---|---|---|---|
Line 1: | Line 1: | ||
<WRAP center round important 60%> | <WRAP center round important 60%> | ||
- | THIS document is [[oracle: | + | THIS document is [[dba:oracle: |
Line 113: | Line 113: | ||
y | y | ||
<code sql> | <code sql> | ||
- | SET LINESIZE | + | SET LINESIZE |
- | SET PAGESIZE | + | SET PAGESIZE |
SELECT * FROM table(DBMS_XPLAN.DISPLAY); | SELECT * FROM table(DBMS_XPLAN.DISPLAY); | ||
</ | </ | ||
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, | ||
</ | </ | ||