1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Place Holder Columns

Discussion in 'SQL PL/SQL' started by Abdul32156, May 1, 2012.

  1. Abdul32156

    Abdul32156 Guest

    Hi, Friends this is Abdul.

    For eg: My report header consist user_name,resp_name,application_name . for displaying pupouse we take place holder columns and we write pl/sql code in before report trigger
    like
    select user_name into :cp_1 from fnd_user
    where user_id=fnd_srwinit('user_name');


    like that ,is it possible to take all parameters with in a single select statement.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Yes, you can pass as many variables in the INTO clause as you need (in this case it would be three):

    select user_name, resp_name, application_name into :cp_1,:cp_2, :cp_3 from fnd_user
    wher user_id=fnd_srwinit('user_name');

    Also, it is easier to answer quiestions if they are in the correct forum; this was moved to SQL/PLSQL.