Select( Ctrl+a) , Copy ( Ctrl+c ) and Run the code for practice
This is a command for creating a table in to oracle database
Query is :- select * from TableName(column_names column_datatypes, - - - - , - - - - );
Insert command Insert the values in the table which is already created in oracle Database.
Query is:- insert into TableName values(123,'Sam','12-jan-2000')
Delete command Delete the values from the table which is already Exist in oracle Database.
Query is:- delete from emp where eid=1329310022;
Update command is using for updating the values of the table which is already Exist in oracle Database.
Query is:- update emp set ename='Tom' where eid=101
Select command is used view data of the table which is already Exist in oracle Database.
Query is:- Select *from student