topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Thu, 31 Jul 2008 18:42:28 GMT

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 — Thu, 31 Jul 2008 18:44:31 GMT

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 — Thu, 31 Jul 2008 18:44:33 GMT

select a b

from tab

into (a, b)

where condition.

it is accepted, use ( )