User login

  • Create new account
  • Request new password

Search

[ Advanced ] [ Help ]

Site navigation

  • About
  • Articles / Blogs
  • Blog Aggregator
  • Books
  • Directories
  • Events
  • FAQ's
  • Forums
  • Mailing Lists
  • Papers
  • Scripts
  • Tools
  • USENET News
  • Wiki
  • XML Feeds

Featured book

cover of OCP: Oracle 10g Certification Kit (1Z0-042 and 1Z0-043)
OCP: Oracle 10g Certification Kit (1Z0-042 and 1Z0-043)

Similar entries

  • RDBMS Server
  • General FAQ's
  • RMAN Backup and Recovery
  • Oracle Corporation
  • SQL and PL/SQL
Home » Oracle FAQ Knowledge Base » SQL and PL/SQL

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/SQLupWhat are the difference between DDL, DML and DCL commands? ›
»
  • Login to post comments
.:: Site Home :: Wiki Home :: Forum Home :: Privacy :: Contact ::.