WebDec 2, 2024 · The cursor FOR loop is an elegant and natural extension of the numeric FOR loop in PL/SQL. With a numeric FOR loop, the body of the loop executes once for every integer value between the low and high values specified in the range. With a cursor FOR loop, the body of the loop is executed for each row returned by the query. WebFeb 14, 2024 · SYSTEM.CURSOR_RECORD brings in post_query-trigger allways 1 back (Doc ID 265380.1) Last updated on FEBRUARY 14, 2024 Applies to: Oracle Forms - Version 10.1.2.3.0 and later Information in this document applies to any platform. Goal SYSTEM.CURSOR_RECORD brings in post_query-trigger allways 1 back but it should …
Diff between :system.trigger_record and :system.cursor_record
WebJul 4, 2011 · how to focus on current record in oracle forms. for ex:- I have 10 records in line level.i want to focus my cursor on perticular like (5th record) how to possible in form. Is there any built-in like current_record? The current record is the record the cursor is in - :system.cursor_record will get you the number. WebJul 29, 2011 · Use :SYSTEM.CURSOR_RECORD or :SYSTEM.TRIGGER_RECORD to find the current record number, then use GO_RECORD after you execute the query to return to that record. Of course, that only works if you are retrieving the same number of records in the same order as the block currently displays. 2x地宫同调
OraFAQ Forum: Forms » system.cursor_record
Create POST-QUERY trigger on DISPLAY_COMM_DET block like this: declare cursor c_reason is select comm_value from common_master where comm_reason = :display_comm_det.comm_reason; begin open c_reason; fetch c_reason into :display_comm_det.ndb_comm_reason_value; close c_reason; end; Share Follow answered Oct 30, 2015 at 7:25 Petr Pribyl WebJul 20th, 2009 at 2:45 PM. SYSTEM.TRIGGER_RECORD represents the number of the record that Form Builder is processing. This number represents the record's current physical order in the block's list of records. The value is always a character string. SYSTEM.CURSOR_RECORD represents the number of the record where the cursor is … Web• Worked extensively on Ref Cursor, External Tables and Collections. • Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE. • Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS. • Expertise in Client/Server Technology using Oracle Forms and Reports 9i/10g/11g. 2x乗 積分