Skip to main content

Site search

User login

  • Request new password

Site navigation

  • About
  • Blogs
  • Feed aggregator
  • Books
  • Events
  • FAQ's
  • Forums
  • Mailing Lists
  • Papers
  • Scripts
  • Tools
  • USENET News
  • Wiki
  • XML Feeds

You are here

Home » Oracle FAQ Knowledge Base » SQL and PL/SQL

SQL

Submitted by admin on Sat, 2005-10-15 07:21
Body: 

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 up What are the difference between DDL, DML and DCL commands? ›
»
  • Log in to post comments
.:: Blogger Home :: Wiki Home :: Forum Home :: Privacy :: Contact ::.