Static Query



Table in Oracle Database :- Create , Insert , Update , Delete , Select

Select( Ctrl+a) , Copy ( Ctrl+c ) and Run the code for practice


Static Quries
    In Static quries the data is input by Programmer , means data insert during
  • Create
  • Insert
  • Delete
  • select
  • update
Query Format



Static Create

This is a command for creating a table in to oracle database

Query is :- select * from TableName(column_names column_datatypes, - - - - , - - - - );

  • EX In Java:-



  • Two Ex in SQL Command Line





Static Insert

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')

  • EX In Java:-



  • Ex in SQL Command Line



Static Delete

Delete command Delete the values from the table which is already Exist in oracle Database.

Query is:- delete from emp where eid=1329310022;

  • EX In Java:-




Static Update

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

  • EX In Java:-




Static Select

Select command is used view data of the table which is already Exist in oracle Database.

Query is:- Select *from student

  • EX In Java:-