 |
What are the benefits of PL or SQL? |
[Edit] |
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 server for 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.
First answer by Dilnrd. Last edit by Rahulsince83. Contributor trust: 0 [recommend contributor]. Question popularity: 0 [recommend question]
|
Research your answer: |
Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Databases > What are the benefits of PL or SQL?
Our contributors said this page should be displayed for the questions below. (Where do these come from ) |
| If any of these are not a genuine rephrasing of the question, please help out and edit these alternates. |
