Difference between sql and sql*plus, Database Management System

Difference between SQL and 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
Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

Describe Database state in details? Database state: The actual data within the database at a particular moment in time is known as a database state.

What is an ER diagram? Why is it used in Database management system (DBMS)?

Law Associates is a large legal practice based in Sydney. You have been asked to design a data model for the practice based upon the following specification: The practice employs

Haw does it work one database application

What is the full form of ODBC ? ODBC stands for Open Database Connectivity.

explain exhausitively the problems associated with er diagrams with ellustrations

Ask questiwhat is row indicator in database on #Minimum 100 words accepted#

Describe about Use Case and external case in DFD The processes are transformed those into the Use Case and external case in DFD has same characteristics which of an actor in O

Explain data independence ? Data independence is the capacity to modify the schema at one stage of a database system without having to change the schema at the further level.