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
Create role named role_table that allows a user to create tables. Using role_table allow users kripa and reena to create tables. CREATE ROLE role_table; GRANT CREATE ANY TABLE

What is known as fudge factor? The number of partitions is enhanced by a small value called the fudge factor, which is usually 20 percent of the number of hash partitions compu

Why are cursors necessary in embedded SQL? A cursor is an object used to store the output of a query for row-by-row processing through the application programs. SQL statements

(a) Why did SAP introduce the extended star schema?

Compute the closure (F+) for the following set of the functional dependencies defined on R(a,b,c,d), where F - {c→ a, ab → d, a → b, d → c}, i.e. what are all of the FDs implied b


Analyzing Association Traversal Association Traversal shall be understood properly for the association design explanation.  Analyzing association traversal means analyzing tra

Removing a Synonym: DROP SYNONYM D30;

In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

DISADVANTAGES OF RDBMS