Oracle

Notes

• Set the client to show text-wrapped query results

SET LINESIZE 20000 TRIMOUT ON TRIM ON TRIMSPOOL ON SERVEROUTPUT ON PAGESIZE 50000  COLSEP ' | '

System query

List users

SELECT tablespace_name FROM user_tablespaces;

List databases

SELECT owner, table_name FROM dba_tables;