| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
| Question: What is difference between SQL and SQL*PLUS?
Answer:
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. |
| November 11, 2006 11:10:50 |
#5 |
| thumatinagaraju |
Member Since: Visitor Total Comments: N/A |
RE: What is difference between SQL and SQL*PLUS?...
|
| hisql is structured quiery language ..sql plus is an interfacing tool or medium thouh sql statements will be passed to the oracl server..sql keyword's cann't be abbrivated where as sql plus commands can be abbrivated ..sql statements go to buffer to oracle server where as sql plus commands act on the retrived results for generating formatted reports,,sql plus is oralce propritory ..and sql is a language can be used with any others languages or platforms.bye friends |
| |
Back To Question | |
