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 Oracle E-Business Suite 11i: Implementing Core Financial Applications
Oracle E-Business Suite 11i: Implementing Core Financial Applications

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 ::.