Oracle 💵 ¶

Oracle Database or Oracle DBMS is a proprietary multi-model database management system developed by Oracle.

Each database is identified by a System Identifier (SID). Clients need the SID to connect to a database (or default value is used).

Oracle databases can be managed using TNS.

Common Commands:

select table_name from all_tables;
select table_name from user_tables;
select table_name from dba_tables;    -- DBA only
select column_name, data_type from all_tab_columns where table_name = 'table_name';
show CON_NAME;                        -- Show SID | Oracle 12c+
select * from user_role_privs;        -- list current privileges
select name, password from sys.user$; -- retrieve hashes | DBA only