We will see how to load data from a file in an oracle table using sqlldr. Table We have a table EMPLOYEE in the oracle database with the following schema:- SQL> desc EMPLOYEE; Name Null? Type —————————————– ——– —————————- EMP_ID NOT NULL NUMBER(38) EMP_NAME VARCHAR2(500) EMP_AGE NUMBER(38) Data File We…
Basics We will see how to execute a simple SQL SELECT query in Java using JDBC Statement. Step 1 – Load Driver Class For connecting to the database we need to have a suitable Driver class loaded. This Driver class helps us to get the Connection to the corresponding database.…
Sometimes we need to execute multiple update/insert queries on our DB. The performance of these queries can be critical for our application. We will see how we can improve performance of multiple update/insert queries on oracle. Create Index on the column/columns used in the WHERE clause for update queries. This…