SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem in fetching data for a single column

Anindya GayenJul 29 2013 — edited Jul 31 2013

Hi,

I have a requirement where I have to fetch three records (intf.INTERFACE_DEF_ID , b2b.B2B_TPA_DEF_ID , osb.OSB_INF_DEF_ID) for the select statement to a particular column(val_id)

The below query is giving error.

Please help..

select

(intf.INTERFACE_DEF_ID or b2b.B2B_TPA_DEF_ID or osb.OSB_INF_DEF_ID) as val_id

FROM

ABC.INTERFACE_DEF intf,

ABC.B2B_TPA_DEF b2b,

ABC.OSB_INF_DEF osb;

Thanks.

This post has been answered by BluShadow on Jul 30 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 28 2013

Added on Jul 29 2013

#data, #error, #in, #pl, #pl-sql, #plsql, #query, #select, #sql

17 comments

1,411 views