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
Describe Object Relational model ? Object Relational Model - This model combines the characteristics of both relational model and object oriented model. It extends the tradit

1. Explain different addressing modes of 8086 Explanation of all addressing modes 2. Write a sequence of instructions to exchange two register contents using stack

What are the Objectives of Advance object design After this unit, you shall be able to: combine three OOAD models to obtain operations on the classes; develop algo

What are the advantages and disadvantages of merging an association into a class?  Advantages: i)  Less number of tables ii) Faster performance due to the fewer tables

Illustrate the term- Abstracting Out Common Behaviour Inheritance is not every time recognised during analysis phase of development, thus it is necessary to re-evaluate object

Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA

a project based on normalization with first, second and third normalization. There need to be a diagram also

how can apply joins on table

Describe identifying relationship? Identifying relationship: It is relationship among strong entity and a weak entity it is represented through a doubly outlined diamond in C

Explain the Fundamental concepts of object-orientation Software developers, data base administrators (DBAs) need to be familiar with fundamental concepts of object-orientation.