Category Archives: How To’s

How to connect Oracle Database in Java

Connect Oracle Database

If you want to access oracle 10g database via JDBC connection, you need to set CLASS PATH environment variable to find the ojdbc14.jar file provided by Oracle. The file is located in  “C:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar ” This is sample JDBC Connection string to connect Oracle database in Java Connection conn = null; Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","user_name","Pass_word”"); conn.close();     

How to send an E-Mail from 10g Oracle Database

email from plsql

Just follow the below mentioned steps to send an e-mail from Oracle 10g database using PL/SQL. Step:1    First install SMTP Service in Server as per steps given below. Go to Control Panel->  Add or Remove Programs-> Click on Add/Remove Windows Components Select Internet Information Service (IIS) option and click on Details button to check whether

How to create a PIVOT table in Oracle.

Create a Pivot Table in Oracle

First create a PLANNING table in oracle using following script. CREATE TABLE PLANNING (CITY VARCHAR2(25), TYPEOFCITY VARCHAR2(20), CONSUMERS NUMBER(20), SURVEYEDCONSUMERS NUMBER(20)); Now insert some dummy records in the table. insert into PLANNING values ('AJMER','URBAN',85589,45836); insert into PLANNING  values ('AJMER','RURAL',13853,8328); insert into PLANNING values ('BHILWARA','URBAN',54149,27327); insert into PLANNING values ('BHILWARA','RURAL',8384,4331); insert into PLANNING values ('NAGOR','URBAN',49752,43919); insert

Siteground SALE
60% OFF SiteGround WordPress Hosting – $3.95/month (Exclusive Offer !!!)