Basic Commands in SQL

 Basic Commands

1.Clear screen (clear screen , cl scr) -

The command is use to clear output screen.

2. Show user (show user) - 

Show user is use to get the current user.

3. Connect Username (connect username , conn username) -

 This command is use to connect the specified account.

4. Select *
        from tab ;

This command is use to display the list of table present in current account.

Ex- To see the list of table present in scoot account we need to account we need to connect scoot first after that we can execute this command.

        TNAME   

        DEPT

        EMP

        BOUNS

        SALGRADE

5.Desc table_name - 

This command is use to check the list of column and the respective datatype.

6. Select *
        from table_name ;

This command is use to see all the details of the table.

    

Note - SQL is not case sensitive but the data is case sensitive.

7. Set Line 500 - 

This command is use to display all the column in single line because the default line size not enough so we need to execute line.

8. Set Pages 200 -

This command is use to display all records and rows on a single page because default page size is not enough so we need to extend page size.