Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    14

    Unanswered: forms6 -sql in menu

    hi,
    I am working with menu in forms 6.
    I want to fetch value from table & wants to store it in variable.
    how can I do this.
    Plese help me.

    Abhijit.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Code:
    begin
      my_variable number;
    begin
      select my_column 
      into my_variable
      from my_table
      where col23 = ....;
    end;
    It's called a sql block and if you don't know about it, then you have no business writing oracle forms.
    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
  •