Program using cursor for updating salary of employee
Points to remember while fetching a row: · We can fetch the rows in a cursor to a PL/SQL Record or a list of variables created in the PL/SQL Block.Native Dynamic SQL is an alternative to PL/SQL differs somewhat from other common programming languages, such as C. For example, addresses (also called pointers) are not user-visible in PL/SQL. When the second batch is fetched in the loop, the rows go to positions 0 to 9; and so on. DATE_TABLE; indx NUMBER := 10; BEGIN c := DBMS_SQL. PARSE(c, 'select * from multi_tab order by 1', DBMS_SQL. PL/SQL also conforms to the current ANSI/ISO SQL standard.In addition to static SQL discussed in this chapter, PL/SQL also supports dynamic SQL, which enables you to execute SQL data definition, data control, and session control statements dynamically.