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.


April 04, 2006 16:56:54 #4
 Ravi   Member Since: Visitor    Total Comments: N/A 

RE: What is difference between SQL and SQL*PLUS?...
 

Hi:

SQL is a language defining what you want to do ...when you want to do something ... where do you do what you want to do...

in otherwords SQL*PLUS is the "environment" where you can actually type your commands to perform queries and see the results in the same environment itself.

correct me if iam wrong

     

 

Back To Question