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.
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
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.
Difference between Object-based Data Model and Record-based Data Model?
RECORD type works only in PL/SQL. But OBJECT type gets stored in database and can be used in both SQL and PL/SQL (without redefining it in PL/SQL).
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
A query language for relational databases?
Currently T-SQL for MS SQL, PL/SQL for Oracle databases, and XBASE for others. All try to adhere to the SQL-92 standard but each vendor adds their own twist
