dba:oracle:basic_oracle_sql_querys
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
dba:oracle:basic_oracle_sql_querys [2023/07/03 08:20] – [Columnas de las tablas] dodger | dba:oracle:basic_oracle_sql_querys [2023/07/03 08:22] – [Virtual columns] dodger | ||
---|---|---|---|
Line 1572: | Line 1572: | ||
where VIRTUAL_COLUMN=' | where VIRTUAL_COLUMN=' | ||
and OWNER in ( ' | and OWNER in ( ' | ||
+ | order by owner, table_name, column_name | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | Not owned by system users: | ||
+ | <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=' | ||
+ | and NOT owner in ( | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ' | ||
+ | ) | ||
order by owner, table_name, column_name | order by owner, table_name, column_name | ||
/ | / |
dba/oracle/basic_oracle_sql_querys.txt · Last modified: 2023/07/03 08:37 by dodger