Difference between sql and sql*plus, Database Management System

Assignment Help:

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


Related Discussions:- Difference between sql and sql*plus

Lock, intent locking

intent locking

Explain about primary key, Explain about primary key Primary Key: It ...

Explain about primary key Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate ke

What are the various symbols used to draw an e-r diagram, What are the vari...

What are the various symbols used to draw an E-R diagram? Explain with the help of an example how weak entity sets are represented in an E-R diagram. Various symbols used to d

Assignment SQL Management Server 2012, Have database built but having probl...

Have database built but having problems with some questions that go with the database

Explain optimistic locking and pessimistic locking, Explain the difference ...

Explain the difference between optimistic locking and pessimistic locking. Optimistic locking supposes no transaction conflict will occur and deals with the consequences if it

Fragmentation, Differentiate between horizontal & mixed horizontal fragment...

Differentiate between horizontal & mixed horizontal fragmentation?

Define a view and a trigger, Define a view and a trigger. Construct a view ...

Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA

What are object interaction diagrams, What are object interaction diagrams?...

What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,

Explain the exec statement in sql, Explain the EXEC statement in SQL  A...

Explain the EXEC statement in SQL  Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a

ER Diagram, Hi I have got an assignment for making an er diagram for market...

Hi I have got an assignment for making an er diagram for market management software can any budy help me?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd