Updating stored procedure

In more recent releases both triggers and procedures are compiled when created (stored p-code) and one can add as much code as one likes in either procedures or triggers.

One can build a history of PL/SQL code changes by setting up an AFTER CREATE schema (or database) level trigger (available from Oracle 8.1.7).SQL is a declarative language that allows database programmers to write a SQL declaration and hand it to the database for execution.As such, SQL cannot be used to execute procedural code with conditional, iterative and sequential statements. PL/SQL is Oracle's Procedural Language extension to SQL.Not to mention the numerous PL/SQL enhancements made in Oracle 10g and 11g.PL/SQL and Java appeal to different people in different job roles.

Search for updating stored procedure:

updating stored procedure-52

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating stored procedure”

  1. Dating Latina women and Latino men is something that is considered highly desirable, whether it’s because of the dark hair, the tanned skin, the accent, or the passion that they are generally credited with.