PL/SQL Tutorial
PL/SQL (Procedural Language/Structured Query Language) stands for Procedural Language extension of SQL. This Oracle PL/SQL …
Database
Learn about popular databases MySQL and Oracle and get the quality tips with collection of interview question and answers about database.
SQL Tutorial
SQL (pronounced as “ess-que-el”) stands for Structured Query Language. SQL is used to modify and …
How to Optimize and Analyze a MySQL Database Tables using phpMyAdmin in Godaddy
If you have deleted a large amount of data from a table or if you …
How to Optimize and Analyze a MySQL Database Tables using phpMyAdmin in Godaddy Read More »
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 …
SQL Interview Questions and Answers – 1
In this article I have posted SQL interview questions and answers for my visitors 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 »