Differences

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

--- dba:oracle:basic_oracle_sql_querys [2023/02/10 15:27] – dodger
+++ dba:oracle:basic_oracle_sql_querys [2023/07/03 08:20] – [Columnas de las tablas] dodger
@@ Line 1555: / Line 1555: @@
 WHERE OWNER = '<USERNAME>'
 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>
@@ Line 2498: / Line 2517: @@
 ===== Hard parse =====
   * How to Identify Hard Parse Failures (Doc ID 1353015.1)
-  * http://wiki.ciberterminal.net/doku.php?id=killing_hardparse
+  * [[dba:oracle:docs:killing_hardparse|[DOC] Kill hardparse]]
 ===== Top 100 querys =====
 Esta query se basa en las estadísticas guardadas en el repositorio awr.