1521 - Oracle

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

Databases

Tables

Columns