viji

• Sep 7th, 2006

 

sql is a standard language to access relational databases whereas sql*plus is a tool (has a command line interface) to implement sql.

viji

madhu sudhan rao

• Sep 18th, 2006

 

sql*plus is a tool ( interface ) where we enter sql commands, its just like an command line interface like dos

wereas sql is query language with which we communicate with the database.

in order to communicate with the database we can do only with the query language

raja

• Oct 10th, 2006

 

    SQL:

1.it is a language for communicating with the oracle server to access data 2.it is based on ANSI standered sql.3.can"t be abbreviated.4.uses fns to perform some formatting.5.do not have a continuation character.

SQL* plus.

1.recognises sql statements and sends them to the server.2.it is oracle properitory interface for executing sql statement.3.can be abbreviated.4.uses commands to format data. 5. uses a (-) as a continuation character if the command is longer than one line.