What is it?

• An interactive interface to the database.

• Connect to Oracle
• Create, change, delete database objects and data
• Ad hoc query data objects and data
• Verify the functioning of your applications

• Use with any SQL commands: create, drop, insert, select, update, delete and etc.
• Commands are case-insensitive except string constants/literals.

Example:

        select  name, class, major  
        from    Student where name = 'John';

is equivalent to:

        SELECT  Name, CLaSs, MaJor
        From    student where NaMe = 'John';

but not:

      select  name, class, major
        from    Student where name = 'JOHN';

Exit to : Oracle Hints and Tips