Thus, it receives from, as well as sends a value to the program IN OUT: It is the combination of both IN and OUT.OUT: It will send output value to the program.IN: It is the default parameter that will receive input value from the program.In the syntax mentioned above, the only thing to note here are the parameters, which can be the following three types: The syntax of SQL stored procedure is:ĬREATE or REPLACE PROCEDURE name(parameters) How to Create a Simple Stored Procedure in SQL?Ĭreating a stored procedure in SQL is as easy as it can get.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |