GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL

 Print  |  
Question:  What is difference between SQL and SQL*PLUS?


Answer:
SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle database. SQL is a language used to query the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query result, Set options, Edit SQL commands and PL/SQL.


June 06, 2007 19:10:45 #7
 madhug56   Member Since: November 2005    Total Comments: 10 
RE: What is difference between SQL and SQL*PLUS?...
 
SQL
  • SQL is a language that can communicate with Oracle server to access the data.
  • It is based on ANSI standards.
  • There is no continuation character.
  • Keywords cannot be abbreivated.
  • Use functions to manipulate the data.

SQL*PLUS
  • It recognises SQL statement and sends them to the server.
  • Is an Oracle properitory.
  • There is a continuation character.
  • Keywords can be abbreviated.
  • Use commands to manipulate the data.
     

 

Back To Question