User will be able to add the looping as well as if. The set of SQL statement has been written in begin section. The business logic needs to be added in Begin section. In between Begin and End the actual program, code is written. In Declarative section all the variable declaration as well as function declaration is defined. The block structure is converted in to 3 parts : In this article I will try to give you the idea of writing simple PL/SQL code using the block structure. This is universal block structure of PL/SQL. Every user will start with how to write the PL/SQL block. The above is the simple block structure of PL/SQL code. The block structure should contain set of SQL statements, Set of Exceptions, Error handlers, functions, variable declaration etc. The PL/SQL language has a block structure. Let us start with the Anonymous block in PL/SQL. Starting with Anonymous block in PL/SQL : Means PL SQL is used to add the complex business logic, business rules in database language. PL SQL provides the mechanism for developers to add the procedural component at server level. User will able to add complex business logic as well as business rules using PL SQL. ![]()
0 Comments
Leave a Reply. |