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 characterUsage
Oracle databases require a
FROMclause with anySELECTstatement. 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.
SELECT * FROM v$version;SELECT user FROM dual;SELECT owner FROM all_tables GROUP BY owner;SELECT table_name FROM all_tables WHERE owner = 'SYS' ORDER BY table_name;SELECT column_name, data_type FROM all_tab_columns WHERE table_name = '<tableName>';Last updated
Was this helpful?