Category Archives: All Posts

Fixed: Oracle not started-ORA-16038, ORA-19809, ORA-00312 error

Oracle Error

Oracle Error Description: When you try to startup your database and it fails with the error code ORA-16038, ORA-19809, ORA-00312. Just follow the below mentioned procedure to get the solution of above problem. SQL> startup ORACLE instance started. Total System Global Area 178792260 bytes Fixed Size 2116288 bytes Variable Size 218440552 bytes Database Buffers 42943340

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();     

Basic UNIX/LINUX Commands

Unix commands

In my previous post you learned about how to Add and Delete user, How to create a file, how to get Memory Information and Partition Information using Unix commands. Now in this article you will learn about how to get OS information and CPU information. Few Basic UNIX/LINUX Commands login as: root root@'s password: Last

Unix Add and Delete, Memory and Partition Information

In this article you will learn about how to add and delete user in Linux operation system, how to get memory information and partition information. First login as root user and practice following commands. It is also recommended to create another user and practice on the dummy user. login as: root root@'s password: Last login:

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

Transpose Rows into Columns

Transpose Rows in Oracle

You can use these best and easy tips to Transpose rows into columns. You can also Transpose columns into rows in Oracle.

Joins – Left outer, Right outer and full outer

SQL Joins in Oracle

The purpose of SQL join is to combine rows from multiple tables. SQL join is performed by the where clause which combines two or more tables in an SQL statement. There are four types of joins which described below: INNER JOIN or sometimes called SIMPLE JOIN LEFT OUTER JOIN or sometimes called LEFT JOIN RIGHT

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