PL/SQL Tutorial
PL/SQL (Procedural Language/Structured Query Language) stands for Procedural Language extension of SQL. This Oracle PL/SQL …
Oracle Tips and Tricks
Oracle is a database used in a large extent. For more oracle tips and tricks like SQL tips, PL/SQL tips and Oracle DBA, follow IT Blogger Tips.
SQL Tutorial
SQL (pronounced as “ess-que-el”) stands for Structured Query Language. SQL is used to modify and …
Fixed ORA-12518: TNS:listener could not hand off client connection
You try to connect with Oracle database and get Ora-12518 listener could not hand off …
Fixed ORA-12518: TNS:listener could not hand off client connection Read More »
Resolved ORA-12528: TNS:listener: all appropriate instances are blocking new connections error
I was getting ORA-12528:TNS:listener error while connecting with my Oracle XE 11g database. SQL> conn …
Resolved ORA-12541: TNS no listener error
N no. of articles you will find on the internet about “ORA-12541 TNS no listener …
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 …
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 …
How to export data from Oracle Table to Excel sheet in Java Script Read More »
Fixed: Oracle not started-ORA-16038, ORA-19809, ORA-00312 error
Oracle Error Description: When you try to startup your database and it fails with the …
Fixed: Oracle not started-ORA-16038, ORA-19809, ORA-00312 error Read More »
How to connect Oracle Database in Java
If you want to access oracle 10g database via JDBC connection, you need to set …