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

What is a read write transaction in oracle?

610


What are the restrictions in a oracle read only transaction?

574


What are operators in oracle?

532


How to change user password in oracle?

610


Explain the use of indexes option in imp command.

570






What happens if the imported table already exists?

549


How to delete an existing row from a table in oracle?

649


When do I need to use a semicolon vs a slash in oracle sql?

596


What are a cluster and non-cluster index?

578


How to write text literals in oracle?

619


Which is better Oracle or MS SQL? Why?

3989


What are the four Oracle system processes that must always be up and running for the database to be useable?

595


How do I limit the number of rows returned by an oracle query after ordering?

642


How to connect to a local oracle 10g xe server?

539


What are the different windows events activated at runtime ?

2414