Parameters include the name, mode,l, and the data type.Ģ. Header: header part contains the name of the procedure along with the parameters that are to be passed. Stored Procedure in PL/ SQL contains the main 2 parts:ġ. It has a unique name and is used once they are called, or some specified event triggers.Ģ. Stored Procedures in PL/SQL work similarly to Functions. END: It specifies the end of the stored procedure.īelow given are some of the points describing how the stored procedure work in PL/SQL:ġ. ![]() EXCEPTION: It is a keyword that contains the exception-handling part, basically the actions that need to be performed in case of an exception.BEGIN: It is a keyword that specifies the starting of the code having the main logic and the sql statements that need to be executed.AS: AS keyword is used when the procedure is a standalone procedure. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |