Skip to Main Content
Forums

Oracle Database Discussions

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!

like condition with any column

APPSDUDEDec 31 2009 — edited Jan 1 2010
hi all


can u anybody give a suggestion.

SELECT *
FROM TABLE_NAME
WHERE column_name1 like 'columnname2'_

My question is here

in the above query..
can i give column_name2 in like condition,?
normaly we will give column like 'h%' or 'DSSD%' or '23%'

pls let me know...very urgetn
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 29 2010
Added on Dec 31 2009
#general-database-discussions
8 comments
5,213 views