What is difference between SQL and SQL*PLUS?



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

Answer / nishi

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What is logical backup in oracle?

0 Answers  


I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

5 Answers   Microsoft, Oracle, TCS,


How to create a table index in oracle?

0 Answers  


How do I learn what codesets are available in oracle?

0 Answers  


What is analyze command used for?

0 Answers  






What is meant by an index?

0 Answers  


can anyody please send me the dump for Oracle 10g certifications for DBA path?

0 Answers  


How to convert raw data type into text in oracle? Explain

0 Answers  


What is background process in Oracle?

0 Answers   MCN Solutions,


What are the types of synonyms?

1 Answers  


What is a cursor and what are the steps need to be taken?

0 Answers  


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

0 Answers   Oracle,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)