OraFAQ Forum: Server Administration » How do I compare two columns in a two different table that are of type LONG?

Home » RDBMS Server » Server Administration » How do I compare two columns in a two different table that are of type LONG?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do I compare two columns in a two different table that are of type LONG? [message #374105]

Thu, 24 May 2001 20:30

Khanh Hua
Messages: 7
Registered: May 2001

Junior Member

I would like to do a join between two tables on a column that is of type LONG.

I tried doing something like this:

Example:

select a.emp_id, b.dept_id from emp a, dept b
where a.dept_id = b.dept_id AND
a.desc like '%b.desc%'

but the results did not join based on the desc column between the two tables. I suspect it is because the dataType is LONG for the desc column.

Any help would be much appreciated.

Thanks

Report message to a moderator

Previous Topic:	Export the result of a query to text file
Next Topic:	question on oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 17:14:26 CDT 2024