Snippet Name: TABLE: queries Description: Some useful queries for table information. Also see:» TABLESPACE: Show contiguous space » TABLESPACE: SYSAUX tablespace » TABLESPACE: Tablespace management » TABLESPACE: List tablespaces, files, ... » TABLESPACE: Dropping Tablespaces » TABLESPACE: Alter Permanent Tablespace » TABLESPACE: Transportable tablespaces » TABLESPACE: Tempfile operations » TABLESPACE: Create temp tablespace » TABLESPACE: Change UNDO tablespace » TABLESPACE: Undo Tablespace » TABLESPACE: SYSAUX Tablespace » TABLESPACE: Set default tablespace type » TABLESPACE: Oracle Managed Auto-extend... » TABLESPACE: Permanent Tablespace Using... » TABLE: Constraints » TABLE: Options » TABLE: Using Select Statement With Data » TABLE: Multiple Columns » TABLE: simple heap table » TABLESPACE: Using Raw Devices » TABLESPACE: permanent tablespace Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 11th, 2009
Description: Some useful queries for table information.
Also see:» TABLESPACE: Show contiguous space » TABLESPACE: SYSAUX tablespace » TABLESPACE: Tablespace management » TABLESPACE: List tablespaces, files, ... » TABLESPACE: Dropping Tablespaces » TABLESPACE: Alter Permanent Tablespace » TABLESPACE: Transportable tablespaces » TABLESPACE: Tempfile operations » TABLESPACE: Create temp tablespace » TABLESPACE: Change UNDO tablespace » TABLESPACE: Undo Tablespace » TABLESPACE: SYSAUX Tablespace » TABLESPACE: Set default tablespace type » TABLESPACE: Oracle Managed Auto-extend... » TABLESPACE: Permanent Tablespace Using... » TABLE: Constraints » TABLE: Options » TABLE: Using Select Statement With Data » TABLE: Multiple Columns » TABLE: simple heap table » TABLESPACE: Using Raw Devices » TABLESPACE: permanent tablespace
SELECT owner, column_id, column_name FROM user_tab_cols WHERE table_name = 'test1' ORDER BY column_id; SELECT * FROM user_tables; SELECT * FROM dba_tables; SELECT table_name, tablespace_name FROM all_tables;
