KajooBadam

Static Query

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

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

import java.sql.*;
public class SelectTableDemo {

public static void main(String[] args) {

try{
				
		    Class.forName("oracle.jdbc.driver.OracleDriver");//fully qualified class name
		    Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "myresult", "myresult");
			Statement stmt=con.createStatement();
			String q="Select *from emp ";
            ResultSet rs =  stmt.executeQuery(q);
			System.out.println("DATA  OF EMP TABLE ");//assume that EMP is already created;
            while(rs.next() )
            {
            	int a= rs.getInt(1);
            	System.out.print(a+ "  " );
            	
            	String b=rs.getString(2);
            	System.out.print(b + "      ");
            	
            	String c=rs.getString(3);
            	System.out.print(c + " ");
            	
            	String d=rs.getString(4);
            	System.out.print(d +" " );
                
            	System.out.println("\n");
            }
            	}
			catch(Exception e)
			{
				System.out.println("Some Error");
			}
		}
}

Static Quries

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:-