My Sql syntax and Examples.

 1.) How to create users?
→   Syntax : Create user username identified by password;
→   Example: Create user techno identified by abhijeet;

2.) How to give access  to users for insertion and deletion?
→   Syntax : GRANT CONNECT, RESOURCE to username;
→   Example: GRANT CONNECT, RESOURCE to techno;

3.) How to Show all users list?
→   Syntax : select * from all_users;

4.) How to delete user from list?
→   Syntax : drop user user_name;
→   Example: drop user techno;

5.) How to create table in oracle ?
→   Syntax : Create table table_name(var datatype(length), var datatype(length));
→   Example: Create table Student(roll number(5), name varchar(20));

6.) How to show the structure of table?
→   Syntax : Desc <Table_Name>;
→   Example: Desc Student;

7.) How to insert data in Table?
→   Syntax : Insert data into <table name>  values(value1, 'value2'); 
→   Example: Insert data into Student values(1, 'Abhijeet'); 

8.) How to view the inserted data from a table?
→   Syntax : Select * from <table name>;  
→   Example: Select * from Student;

9.) How to insert multiple data in table?
→   Syntax : Insert data into <table_name>(&var1, '&var2');
→   Example: Insert data into Student(&roll, '&name');