locked
assign variable in a sql - oracle RRS feed

  • Question

  • User-1075092149 posted

    I have declared many variable in package's stored procedure.

    how can i assign many variables in a sql like belows:

    variable_1 varchar2(100);

    variable_2 varhcar2(100);

    select sum(col_a) into variable_1 , sum(col_b) into variable_b from table_A group by col_c,;

    or

    i need to assign value to 1 variable in a sql. if i have 2 variable. i need to write 2 sql??

     

    any other methods?

    Thursday, September 20, 2012 11:13 PM

Answers

All replies