Difference between SQL,SQL*PLUS and PL/SQL

[Landan]

Hello guys !

I am so confused to get some points.would you help me solve this ? There are different terms used in oracle database technology.There are three terms, SQL,PL/SQL,SQL*PLUS. I need to know the difference between these three terms.As we use both SQL and PL/SQL on same prompt then what are the differences in functionality of both.I will be highly obliged to you.

Thanks.

[opaper]

These three are the most important components of oracle database to manage it reliable.These are used on different nodes of oracle structure.

The SQL is used to fetch the data from database server,SQL*Plus is used by the client of database in network environment and PL/SQL is used to construct the application manipulation through which we can handle the stored procedures and different objects of database.

[MindSpace]

SQL(Structure Query language) :

SQL was developed at IBM and initially called as SEQUEL.it is also called as Structure Query Language.it is used to query on Relational database,You can make queries on different objects of the database and you can create also according to the limitation and scope of database.

It has been adopted by two different large organizations,ISO( International standards Organization) and ANSI(American National Standards Institute).It is the base of database and whenever you execute SELECT,CREATE,UPDATE, DELETE commands are the part of SQL.

[Modifier]

SQL*PLUS in database

SQL*Plus is an Intellectual application which is used to access the database from server with the help of Structure query language.You can execute the PL/SQL codes also here. The different types of operations are performed like creating stored procedure and functions.

When you execute any statement under SQL*Plus,you it traverses from different executions and processing.

The query is executed at client end using SQL*Plus and query transmitted to database server.The database checks the privileges and network authentications after that send it back to the SQL*Plus to display the results of query.

[Praetor]

PL/SQL in database :

The PL/SQL is a procedural language which is used to create the procedures and function of oracle database. You can access the data from database server using complex operation.The operations can be implemented in an application.

The different tools of oracle database provides the facility to create the application using this language.You can change the behavior of errors during database access with the help of exception technique and block.

[Katty]

dbms_output.put_line Procedure :

The dbms_output.put_line Procedure is a procedure which is used to print the statement in oracle database.
The procedure contains the package and functions.The defined procedure contains the package named "dbms_output" and function is "put_line".
The dbms_output contains many functions related to perform the output of statement.The example is given below for above procedure :

dbms_output.put_line('Hello Dear.... ');

To print the Character values,you have to specify single court and for integer values pass the variable without any court.