Oracle SQL and SQL*plus
Click on headings to sort
| Statement | Syntax and arguments | Type | Statement Description |
|---|---|---|---|
| COLUMN | COL emp_name FORMAT A15 (Set column to 15 characters wide) | SQL*plus | Specify column characteristics for the current session |
| SELECT | SELECT column_name(s) FROM table_name | SQL | Select data from table |
| shutdown | shutdown immediate | SQL*plus | Shutdown an oracle instance immediately rolling back active transactions and disconnecting all active users. |
| sqlplus | sqlplus "/ as sysdba" | SQL*plus | Connect to the database without password authentication |
| startup | startup | SQL*plus | Start an Oracle instance |