Home » SQL & PL/SQL » SQL & PL/SQL » IN Clause Problem
IN Clause Problem [message #194046] Wed, 20 September 2006 09:32 Go to next message
alibawa
Messages: 11
Registered: May 2006
Junior Member
I am searching for records with the IN clause. But the problem is that when i search with this e.g

select * from abc where name
in 'ABC & Communication';


The query starts taking input. Kindly help me in doing it.


Re: IN Clause Problem [message #194051 is a reply to message #194046] Wed, 20 September 2006 09:48 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
SET DEFINE OFF
Re: IN Clause Problem [message #194062 is a reply to message #194046] Wed, 20 September 2006 11:13 Go to previous messageGo to next message
alibawa
Messages: 11
Registered: May 2006
Junior Member
thanx mate...
could you just tell me the story behind it..
Re: IN Clause Problem [message #194064 is a reply to message #194062] Wed, 20 September 2006 11:33 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
This should help explain it Special Characters.
Re: IN Clause Problem [message #194173 is a reply to message #194062] Thu, 21 September 2006 01:59 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
SQL*Plus has the concept of substitution variables. These are strings starting with & or &&.
At the point where a piece of SQL is executed, SQL*Plus will prompt you to enter a value for any undefined substitution variables, and these variables will be replaced with the exact strings you enter.

SET DEFINE OFF simply disables substitution variables.

See ACCEPT, DEFINE and UNDEFINE here for other ways of entering sub. variables.
Re: IN Clause Problem [message #194176 is a reply to message #194173] Thu, 21 September 2006 02:03 Go to previous message
alibawa
Messages: 11
Registered: May 2006
Junior Member
i really thank u all for this help..
Previous Topic: DBMS_SQL parsing problem
Next Topic: How can I do a one-to-one join without keys
Goto Forum:
  


Current Time: Wed Dec 07 18:54:37 CST 2016

Total time taken to generate the page: 0.05515 seconds