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 »
SQL Tips and Tricks
You will get here free SQL tips. SQL is a structure query language that allows you to insert, manipulate and delete data from the database.
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.