What is the difference between sql and sql plus?

Showing Answers 1 - 7 of 7 Answers

Sunny

  • Feb 9th, 2006
 

SQL exexcutes single instructions while PLsql executes block of instructions.

  Was this answer useful?  Yes

Bonthu

  • Feb 11th, 2006
 

SQL => Structured Query Language which is just like English Language.

SQL*Plus => Is a tool developed to Interact with Oracle Database.

Thanks,

Bonthu.

  Was this answer useful?  Yes

Guest

  • Mar 15th, 2006
 

SQL: Abbreviation for "Structure Query Language" it's a special kind of query language similar to English language and used to interact with data stored in a Database. Categories of SQL language along with types of manipulation valid under each categories are as follows:- DML: Data Manipulation Languageselect, insert, delete, update, lock table etc.- DDL: Data Definition Languagecreate, drop, alter, truncate, comment, grant, revoke etc.- DCL: Data Control Languagecommit, rollback, savepoint, set transection etc.SQL Plus: It is a tool from where you can submit your SQL statements.

  Was this answer useful?  Yes

Amit Chintawar

  • Mar 29th, 2006
 

SQL SQL PLUS1) COLUMN HEADINGS ARE 1) COLUMN HEADINGS ARE CENTRE LEFT JUSTIFIED- FOR DATE & CHARACTERS JUSTIFIED ALWAYSRIGHT JUSTIFIED- FOR NUMBERS2) IT HAS TO BE LOADED ON INDIVIDUAL 2) IT IS CENTRALLY LOADED & CAN BE MACHINE RUN ON WEB ENVIRONMENT

  Was this answer useful?  Yes

KRISHNA CHAITHANYA

  • Aug 20th, 2007
 

SQL is structured query language which is following ANSI (American National Standard Institute) Standards so it is universally accepted language for all databases whereas SQL+plus is tool is only meant for Oracle product, the commands in this can execute only in Oracle database.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions