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 the use of ondelete cascade?

3 Answers  


How to define an explicit cursor in oracle?

0 Answers  


Which is faster join or subquery in oracle?

0 Answers  


write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000

4 Answers   TCS,


master table and child table performances and comparisons in Oracle ?

0 Answers  






what is difference between sql plus and sql*plus? (not sql and sql plus).

0 Answers  


How to initialize variables with default values?

0 Answers  


Why we use bulk collect in oracle?

0 Answers  


Shall I get Pro*C Compiler in Oracle-10g release ?

1 Answers  


What are the advantages of Views ?

3 Answers  


How to run create database statement again?

0 Answers  


What is system global area (sga) in oracle?

0 Answers  


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)