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
The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

Write short notes on domain relational calculus The domain relational calculus uses domain variables that take on values from an attribute domain rather than values for whole t

Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock

Express the following queries in SQL: (a) Write the SQL code that will create ALL the four tables given in the appendix. Your answer should not contain the primary key and

Name the various privileges in SQL? A) Delete B) Select C) Insert D) Update

courier company er-diagram

The External or View Level The external or view level is the highest level of abstraction of database. It gives a window on the conceptual view, which permits the user to see

In a relation, tuples are not inserted in any definite order. Ordering of tuples is not defined as a part of a relation definition. Though, records may be structured later accordin

ALTER TABLE Command : This command is used for variation of existing structure of the table in the given situation: When a new column is to be added to the table structure.

Relational Model: The relational model uses a collection of tables to represent both data and the relationships among those data. Each table has multiple columns and each column h