/Wipro-Training-JDBC---Assignments-for-Executing-Query-Processing-Results

Topics Covered: JDBC, Driver Manager, Connection, Statements

Primary LanguageJava

Wipro TalentNext PBL

Topics Covered: JDBC, Driver Manager, Connection, Statements

No. Hands-on Assignment Topics Covered Status

1

Write a java program that connects to oracle database, queries the inbuilt table “emp” and displays the first two columns (empno using column index and ename using column name ) of all the rows.

JDBC, Driver Manager, Connection,Statements

2

Modify the above program to display all the rows where sal is greater than 1000 and less than 2000. Display the columns ename, job, sal and comm.

JDBC, Driver Manager, Connection,Statements