select statement

[Former Member]

hey,

i m facing a very simple issue...just want to confirm if my understanding is right...

select single a b into x y from table where m = n.

ny problem with this statement ??

can't i select the needed fields and move them to local variable of my choice with such a single select statement ??.

it does not work..keeps on giving syntax error...saying y is not expected !! any help ?

[Former Member]

correct statement is:

select single a b into (x, y) from table <table name> where m = n.

Regards,

Joy.

Edited by: Joyjit Ghosh on Jul 31, 2008 8:45 PM

[Former Member]

select a b

from tab

into (a, b)

where condition.

it is accepted, use ( )