Oracle FAQ Knowledge Base
SQL and PL/SQL
Submitted by admin on Sat, 2005-10-15 06:21
SQL Related FAQ's
What are the difference between DDL, DML and DCL commands?
Difference between TRUNCATE, DELETE and DROP commands
How does one escape special characters when writing SQL queries?
How does one eliminate duplicates rows from a table?
How does one get the time difference between two date columns?
How does one add a day/hour/minute/second to a date value?
How does one code a matrix/crosstab/pivot report in SQL?
Can one retrieve only rows X to Y from a table?
Can one retrieve only the Nth row from a table?
How does one add a column to the middle of a table?
How does one drop/ rename a columns in a table?
How does one implement IF-THEN-ELSE logic in a SELECT statement?
How does one select EVERY Nth row from a table?
How does one select the LAST N rows from a table?
How does one select the TOP N rows from a table?
What is the difference between VARCHAR, VARCHAR2 and CHAR data types?
‹ SQL and PL/SQL
What are the difference between DDL, DML and DCL commands? ›
to post comments