Difference between sql and sql*plus, Database Management System

Difference between SQL and SQL*Plus

SQL

SQL*Plus

SQL is a language

SQL *Plus is an environment

It   is   based   on   ANSI   (American

National  Standards Institute)  standard

It is oracle proprietary interface for

executing SQL statements

 

It is entered into the SQL buffer on one

or more lines

It is entered one line at a time, not

stored in the SQL buffer

SQL cannot be abbreviated

SQL*Plus can be abbreviated

It   uses   a   termination   character   to

execute command immediately

It does not require termination

character. Commands are executed immediately.

SQL  statements  manipulate  data  and

table definition in the database

It does not allow manipulation of

values in the database

Posted Date: 3/11/2013 12:54:02 AM | Location : United States







Related Discussions:- Difference between sql and sql*plus, Assignment Help, Ask Question on Difference between sql and sql*plus, Get Answer, Expert's Help, Difference between sql and sql*plus Discussions

Write discussion on Difference between sql and sql*plus
Your posts are moderated
Related Questions
Competition entrants can be either Individuals, or Teams. A Team is usually sponsored by a business, and, in that case, the team members would all wear T-shirts with the sponsoring

what is er digram given that example of hospital,bank and library er digram.

Explain Strict Two-Phase locking A transaction T does not release any type of its exclusive (X) locks until that transaction commits or aborts. In this method no other transact

Design Documentation  The Design Document shall be an extension of Requirements Analysis Design. "The Design Document will comprise a revised and much more detailed descrip


in case of functional dependencies how we get the higher normal form.

Discuss the problem of Spurious tuples and how we may prevent it.    Ans:  A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad

Consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, Fr

Question: (a) Can a set of data requirements be correctly modelled by two or more different ER diagrams? Explain your answer. You may use a small example, if you think it will

What are audit trails? An audit trail is a log of all alters to the database along with information like which user performed the change and when the alter was performed.