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 sight of data returned. In PL/SQL, a pointer is a have-to doe with assigned to a detail private SQL bea for a specific SQL education. There lavatory be all static pointers, whose SQL contestation is determined at compile time, or dynamic pointers, whose SQL statement is determined at runtime. Static arrows be covered in greater detail in this section. propellent cursors in PL/SQL ar implemented via the built-in software system DBMS_SQL. 9.1 diaphanous Cursors Explicit cursors atomic number 18 SELECT statements that are DECLARED definitely in the find link section of the current block. Use undecided, FETCH, and attached in the execution or exception sections of our programs. 9.1.1 Declaring denotive cursors To aim an explicit cursor, we must first declare it in the contract bridge section of a block or pac kage.

There are three types of explicit cursor declarations: A cursor without contentions, such(prenominal) as: cursor go with_cur IS SELECT association_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 base of the SELECT statement: CURSOR company_cur (id_in IN NUMBER) RETURN company%ROWTYPE IS SELECT * FROM company; This technique can be employ in packages to conceal the implementation of the cur sor in the package body. 9.1.2 Opening expl! icit cursors To open a cursor, use the pursual syntax: OPEN cursor_name [(argument [,argument ...])]; where cursor_name is the name of the cursor as declared 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 necessity 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