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
Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or

Normal 0 false false false EN-US X-NONE X-NONE

Explain the term High level DML? High level DML A high-level or non-procedural DML permit the user to specify what data is needed without specifying how it is to be acquired.

Types Of Indexes One of the words used during the file organisation is the term index. In this part, let us describe this term in more detail. We find the index of keywords

Command Line Interfaces: These are interactive interfaces, character-based that let you use the complete power and functionality of the DBMS query language directly. They permit yo

What is Object Oriented model? This model is based on collection of objects. An object has values stored in instance variables with in the object. An object also having bodies

Name the three major set of files on disk that compose a database in Oracle. There are three main sets of files on disk that compose a database. All the files are binary. These

ADVANCE OBJECT DESIGN Introduction Analysis is the initial step of the OMT methodology. It is apprehensive with devising a precise, concise, correct and understandable mo

Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is

Consider the following six relation schemes and their corresponding sets of functional dependencies. In each case identify a. All the candidate keys b. The highest normal for