INTERVIEW QUESTIONS ORACLE SQL IN ORACLE DETAILS

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.

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. Source: CoolInterview.com

SQL * Plus is an environment.
Keywords can be abbreviated.

SQL is a Query Language.
Keywords cannot be abbreviated.
Source: CoolInterview.com

sql:- it is a language,its an ANSI standard,keyword cannot be abbreviated...

sql* :- its an environment ,keyword can be abbreveted runs on a browser and centrally loaded does not have to be impelimented on each machine Source: CoolInterview.com

SQL * Plus is an environment. SQL is a Query Language.

SQL*PLUS is 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. SQL and PL/SQL language interface and reporting tool. Source: CoolInterview.com

sql has no help.
where as sql+ has help option........ Source: CoolInterview.com

sql has no help.
where as sql+ has help option........ Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question