answersLogoWhite

0

SQL and iSQL* Plus Sql is command language for communication with the Oracle server any tool or application Oracle Sql contains many extensions iSQL* Plus is an Oracle Tool that recognizes and submits SQL statements to the Oracle serverfor execution and contains its own command language

Whereas PL is Procedural Language when used in conjunction with SQL is termed PL/SQL.

The benefit of PL is it gives programming and logical capability to Oracle , (in other words tight integration with Oracle) . You can create variables variables, arrays etc. and handle exceptions which are not otherwise handled but just thrown back to user in oracle.

You can create a logical block of code to do specific task within databse. Functionality of SQL is quite limited when it comes to providing a flexibility of programming language, for that PL/SQL was developed. Not only you can write your code to do specific tasks and extract meaningful information from databse(by doing logical operations on set of data) but you can reuse your code when similar tasks need to be done.

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

Pl sql programs executes in sql server?

PL\SQL is an Oracle product (the PL stands for procedural language), while Sql Server most commonly refers to Microsoft SQL Server, although at one point Sybase also marketed its product as Sql Server. Microsoft and Sybase both have a procedural language feature, called T-SQL (Transact-SQL), which is similar in concept to PL\SQL, but there are significant differences in syntax and structure. An experienced developer could convert PL\SQL to T-SQL readily, but conversion would be required. It would not run without conversion.


What is PLSQL?

The Oracle Corporation's application development language is PL/SQL. It is a superset of SQL that uses standard programming-language to supplement the SQL. PL/SQL stands for Procedural Language/Structured Query Language.


Who is Denis Orlov?

He is excellent PL/SQL programmer


Which language is used to develop the oracle?

pl/sql


Is PL or SQL is one of the version of oracle?

PL usually stands for a file extension for PERL. SQL is a database structure and querying LANGUAGE. Oracle is a software manufacturer that creates TOOLS for its own SQL database engines.


How to define a user defined function in SQL?

Not possible in SQL, but possible in many vendor-specific SQL-based languages like Oracle PL/SQL.


Which database programming languages are supported by DB2?

Pl/sql


What has the author Kevin T Owens written?

Kevin T. Owens has written: 'Building intelligent databases with Oracle PL/SQL, triggers, and stored procedure' -- subject- s -: Oracle - Computer file -, PL/SQL - Computer program language -, Relational databases 'Building intelligent databases with Oracle PL/SQL, triggers, and stored procedures' -- subject- s -: Oracle - Computer file -, PL/SQL - Computer program language -, Relational databases


What is general technique that you use for debugging a pl sql unit?

dbms_out


What is the Oracle Developer Responsibility?

SQL, PL/SQL, Forms and Reports Development, Database Design, Stored Procedures, Functions, Triggers


What Is ANSI SQL?

ANSI SQL is the American National Standards Institute standardized Structured Query Language. ANSI SQL is the base for several different SQL languages such as T-SQL and PL/SQL. ANSI SQL is used to Create, Alter, and View data stored within a database. For more information about ANSI: http://www.ansi.org/ For more information about SQL: http://en.wikipedia.org/wiki/SQL


What skills does one need to apply for PL SQL jobs at Oracle?

There are several skills necessary to obtain a job at Oracle in the PL SQL field. The requirements include a bachelor's degree, experience with report writing, and progressive experience with programming and database design.