Category Archives: Database

Resolved ORA-12541: TNS no listener error

N no. of articles you will find on the internet about “ORA-12541 TNS no listener error” but still finding an effective solution. Don’t worry this solution helped me a lot and I hope it will help you too. I got the same issue while working on Oracle 10g database then I decided to share my

How to change the SID of an Oracle XE instance

When you install oracle database 11g express, by default its SID name is set to XE. If you want to change your existing SID from XE to your SID, follow below steps to get it done. Take backup of your oracle database before doing all such things. I have tested this on Oracle database 11g

SQL Interview Questions and Answers – 1

In this article I have posted SQL interview questions and answers for my visitors to help them in learning basic SQL. How to connect with Oracle Database C:>sqlplus /nolog SQL*Plus: Release 11.2.0.2.0 Production on Thu May 16 16:22:56 2013 Copyright (c) 1982, 2010, Oracle.  All rights reserved. SQL> conn sys/sys@test as sysdba Connected. How to

How to export data from Oracle Table to Excel sheet in Java Script

You have searched over the internet about how to export oracle table to excel using java script. I am posting this article to give you complete source code to export data from oracle to excel. Follow the below mentioned steps and use the below mentioned code. Step-1: In body section, first you have to define

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

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.

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