Pl Sql

9 Cursors in PL/SQL: Every SQL didactics executed by the RDBMS has a private SQL sphere that contains information about the SQL narration and the bent grass of data returned. In PL/SQL, a pointer is a fig assigned to a unique(predicate) private SQL bea for a specific SQL financial rehearsal. There lavatory be all static pointers, whose SQL statement is determined at compile time, or dynamic pointers, whose SQL statement is determined at runtime. Static cursors be covered in greater detail in this section. propellent cursors in PL/SQL atomic number 18 implemented via the built-in tract DBMS_SQL. 9.1 diaphanous Cursors Explicit cursors ar SELECT statements that atomic number 18 DECLARED definitely in the undertake keep going section of the current block. Use undecided, FETCH, and attached in the execution or exception sections of our programs. 9.1.1 Declaring stated cursors To aim an explicit cursor, we must first declare it in the contract bridge sec tion of a block or package.

There are three types of explicit cursor declarations: A cursor without contentions, such as: cursor go with_cur IS SELECT follow_id FROM company; A cursor that accepts arguments through a parameter list: CURSOR company_cur (id_in IN NUMBER) IS SELECT name FROM company WHERE company_id = id_in; A cursor header that contains a RETURN clause in pull of the SELECT statement: CURSOR company_cur (id_in IN NUMBER) RETURN company%ROWTYPE IS SELECT * FROM company; This technique can be use in packages to conceal the implementation of the c ursor in the package body. 9.1.2 Opening ex! plicit cursors To open a cursor, use the following syntax: OPEN cursor_name [(argument [,argument ...])]; where cursor_name is the name of the cursor as stated in the declaration section. The arguments are required if the definition of the cursor contains a parameter list. We must open an explicit cursor before you can fetch rows from that cursor. When the cursor is opened, the processing includes...If you postulate to get a full essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay