Oracle SQL and SQL*plus

Click on headings to sort

StatementSyntax and argumentsTypeStatement Description
COLUMNCOL emp_name FORMAT A15 (Set column to 15 characters wide)SQL*plusSpecify column characteristics for the current session
SELECTSELECT column_name(s) FROM table_name SQLSelect data from table
shutdownshutdown immediateSQL*plusShutdown an oracle instance immediately rolling back active transactions and disconnecting all active users.
sqlplussqlplus "/ as sysdba" SQL*plusConnect to the database without password authentication
startupstartupSQL*plusStart an Oracle instance