Results 1 to 2 of 2

Thread: Cursor

  1. #1
    Join Date
    Jun 2004
    Posts
    42

    Unanswered: Cursor

    hI ,
    i have a list of value that is as follow
    select x from table1 union select 'All' from dual;
    now i have in the list the new All value.
    this list in the master block and in the detaills block i need to insert values to the All .
    so it should automatic add the values i inserted under All to all of the other list values.how can i do that .
    does any one have an example to show me how to do it.
    i know that i need to write explicit cursor ,but can i do so.

    the detailed block has three fields need to be intered

    thanks

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    setup an on-insert trigger on your block.

    if :my_block.flag = 'ALL' then
    insert into my_table (select x,:my_block.value2,:my_block.value3 from table1);
    else
    insert into my_table values(:my_block.flag,:my_block.value2,:my_block.v alue3);
    end if;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •