Oracle (1521)

General

When using Python libraries, such as cx_Oracle and SQLAlchemy, the ; at the end of a statement can cause an error.

sqlCopy codeSELECT * FROM sys.flags;
// (cx_Oracle.DatabaseError) ORA-00911: invalid character

Usage

• Oracle databases require a FROM clause with any SELECT statement. They include a dummy table (dual) to use when static values or function data needs to be obtained.

• Oracle databases create a schema for each user, and each schema carries its own set of permissions.

• Most of the system tables include a $ sign in their name.

Version

SELECT * FROM v$version;

Current User

SELECT user FROM dual;

Databases

SELECT owner FROM all_tables GROUP BY owner;

Tables

SELECT table_name FROM all_tables WHERE owner = 'SYS' ORDER BY table_name;

Columns

SELECT column_name, data_type FROM all_tab_columns WHERE table_name = '<tableName>';