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: 64622
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate trace to know what it does.

Previous Topic: Better than GOTO
Next Topic: Explicit Cursor
Goto Forum:

Current Time: Thu Mar 30 00:02:06 CDT 2017

Total time taken to generate the page: 0.05198 seconds