Ciberterminal Wiki

User Tools

Site Tools

Trace:
dba:oracle:basic_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:basic_oracle_sql_querys [2023/06/19 16:39] – [Hard parse] dodgerdba:oracle:basic_oracle_sql_querys [2023/07/03 08:20] – [Columnas de las tablas] dodger
Line 1555: Line 1555:
 WHERE OWNER = '<USERNAME>' WHERE OWNER = '<USERNAME>'
 ORDER BY OWNER,TABLE_NAME ; ORDER BY OWNER,TABLE_NAME ;
 +</code>
 +
 +
 +===== Virtual columns =====
 +<code sql>
 +COL OWNER FORMAT A30;
 +COL TABLE_NAME FORMAT A30;
 +COL COLUMN_NAME FORMAT A30;
 +COL virtual_column FORMAT A5;
 +
 +select owner,
 +  table_name,
 +  column_name,
 +  virtual_column
 +from dba_tab_cols
 +where VIRTUAL_COLUMN='YES'
 +and OWNER in ( 'USERNAME1', 'USER2' )
 +order by owner, table_name, column_name
 +/
 </code> </code>
  
dba/oracle/basic_oracle_sql_querys.txt · Last modified: 2023/07/03 08:37 by dodger