Answer to Question #8869 in Databases | SQL | Oracle | MS Access for Prasad

Question

what is diffrent between SQL and SQL plus?.

Answer 1

SQL
· SQL is a language that can communicate with Oracle server to access the data.
· It is based on ANSI standards.
· There is no continuation character.
· Keywords cannot be abbreivated.
· Use functions to manipulate the data.
SQL*PLUS
· It recognises SQL statement and sends them to the server.
· Is an Oracle properitory.
· There is a continuation character.
· Keywords can be abbreviated.
· Use commands to manipulate the data.