![]() ![]() ![]() Read: Oracle Change Database Name What is recursive stored procedure in oracle? local subprograms – procedures nested inside other subprograms.Subprograms – Procedures defined within a package.Standalone subprograms – Procedures created outside of a package.There are 3 types of stored procedures in oracle: To overcome this problem oracle created PL/SQL which allows writing functions and store procedures. Oracle clauses – where, group by, having are not sufficient to perform advance operations on the database also they are comparatively slow. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |