Features of SQL & SQL Plus

SQL:    

SQL is, a common language for communicating with oracle server database to access the data. SQL is based on ASCII standards and SQL manipulates data and table definitions in database environment.

FEATURES:         
              
1. The SQL commands can be used by a range of users

2. It is a non-procedural language

3. It reduces the amount of time required for writing and manipulating the systems

4.  It is like an English language PL/SQL:

PL/SQL is an extension of SQL. PL/SQL block can contain any number of SQL statements integrated with how to control statements. Therefore, SQL combines the data manipulating power of SQL with data processing power of procedural languages. Thus SQL plus is an extension to SQL and SQL is a subset of SQL *plus

SQL*PLUS:   

SQL* plus recognizes SQL statements and sends them to the server. SQL Plus is oracle proprietary  interface for executing SQL commands. It does not allow manipulation of values in the database.

FEATURES OF SQL PLUS:

1 .SQL plus accepts adhoc (temporary) statements
2. It accepts SQL input from the files
3. It  provides a line environmental setting
4. It provides a line editor for modifying the SQL statements
5. It formats query results into basic reports
6. It access local and remote data bases.

Related

Advantages of RDBMS over File System

The economic justifications of database approach is also an important task before taking any development. The DBMS provide reasonable cost & benefits for developing , implementing & main...

Construction of Oracle Loops

1. ONE-WAY IF: The if commands are used for selection or decisions. Syntax: IF <condition> then ……………………….. ………………………… Statements …………………… ……………………. END IF 2.TWO WAY IF: IF the...

Program to Reverse the given String

PROGRAM FOR REVERSING A GIVEN STRING SQL>ED REVERSE SQL DECLARE L number; I number; S varchar2(20); R varchar2 (20); BEGIN         ...

Post a Comment

emo-but-icon
:noprob:
:smile:
:shy:
:trope:
:sneered:
:happy:
:escort:
:rapt:
:love:
:heart:
:angry:
:hate:
:sad:
:sigh:
:disappointed:
:cry:
:fear:
:surprise:
:unbelieve:
:shit:
:like:
:dislike:
:clap:
:cuff:
:fist:
:ok:
:file:
:link:
:place:
:contact:

item