Home » SQL & PL/SQL » SQL & PL/SQL » logical oprator 'like' & 'in' not working. (8i on hp unix)
logical oprator 'like' & 'in' not working. [message #378002] Sat, 27 December 2008 12:29 Go to next message
IT Guru
Messages: 59
Registered: January 2007
production database Oracle 8i on hp unix.

if i try to use logical oprator "like" "in" on dba_free_space it get

select * from dba_free_space where tablespace_name in ('XYZ')
have check event keep on saying scatter read & session also stays
active but no result at all

where works fine with =
select * from dba_free_space where tablespace_name = 'XYZ'

Re: logical oprator 'like' & 'in' not working. [message #378006 is a reply to message #378002] Sat, 27 December 2008 13:44 Go to previous message
Michel Cadot
Messages: 65146
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate trace to know what it does.

Previous Topic: UTL_HTTP,UTL.DBWS or Table Functions?
Next Topic: Single row result from multiple sub tables (Many tables join)
Goto Forum:

Current Time: Mon Aug 21 09:06:57 CDT 2017

Total time taken to generate the page: 0.06387 seconds