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!

how to mention column names in LIKE clause ?

784721Jan 4 2012 — edited Jan 4 2012

Hi.
i need a query like this. is it possible ?
select * from tableA inner join tableB on a.col1 = b.col1 and a.col1 LIKE b.col1||'%'

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2012

Added on Jan 4 2012

#plsql

2 comments

4,122 views