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
Member
production database Oracle 8i on hp unix.


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

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

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


Current Time: Sun Dec 04 04:19:54 CST 2016

Total time taken to generate the page: 0.06651 seconds