What is difference between SQL and SQL*PLUS?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain oracle data types with examples?

782


What is an oracle cursor variable?

819


What is a sub query and what are the different types of subqueries?

893


What are named parameters?

830


What is a nested table?

843


Is oracle a relational database?

723


How to define an anonymous block?

846


How to use "for" statements in oracle?

819


How do I manually create a database in oracle?

762


what is the use of system.effective.date variable in oracle?

889


how may join possible between (requisition with purchase order)

1970


What is the sid in oracle?

723


What is an oracle tablespace?

800


How to list all user accounts in oracle?

822


What is an anonymous block?

921