RE: what is the difference between sql and sql plus?
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.
RE: what is the difference between sql and sql plus?
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
RE: What is the difference between sql and sql plus?
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.
