Transpose Rows to Columns and Columns to Rows in Oracle
This is the most popular question asked in an interview as well as over the …
Transpose Rows to Columns and Columns to Rows in Oracle Read More »
Learn SQL
SQL stands for Structure Query Language that is used to modify and access data from a database like Oracle, SQL Server etc.
Difference Between DDL, DML and DCL Commands
This is the most important question asked in an interview. How to differentiate DDL, DML …
How to Delete Duplicate Rows from a Table
How to remove duplicate records from a Table? If you want to remove duplicate rows …
What is the Difference between Truncate and Delete in Oracle
First create a Table using following command on SQL> prompt. CREATE TABLE SAMPLE (ID NUMBER, …
What is the Difference between Truncate and Delete in Oracle Read More »
SQL Tutorial
SQL (pronounced as “ess-que-el”) stands for Structured Query Language. SQL is used to modify and …
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 »
How to connect Oracle Database in Java
If you want to access oracle 10g database via JDBC connection, you need to set …
Transpose Rows into Columns
You can use these best and easy tips to Transpose rows into columns. You can also Transpose columns into rows in Oracle.