OraFAQ Forum: Client Tools » query for select and update

Home » Other » Client Tools » query for select and update (oracle Database 10g)

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

query for select and update [message #617525]

Tue, 01 July 2014 04:54

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

Respected Sirs

i have a column value in a table 'C C&R'.
when i am trying to select and update column value using sql query,
not able to do so.

my query is

SELECT * FROM <tablename> WHERE <columnname>='C C&R';
above query not getting executed.first time i came across such column values.
please help.
thanks.

Report message to a moderator

Re: query for select and update [message #617526 is a reply to message #617525]

Tue, 01 July 2014 04:57

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

In SQL*Plus :

set define off;

Report message to a moderator

Re: query for select and update [message #617528 is a reply to message #617526]

Tue, 01 July 2014 05:03

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

thank you very much sir for your quick and correct response and answer
grateful to you..thanks again.

Report message to a moderator

Re: query for select and update [message #617530 is a reply to message #617528]

Tue, 01 July 2014 05:29

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Or another way :

SQL> WITH DATA AS(
  2  SELECT 'C C&' || 'R' t FROM DUAL)
  3  SELECT * FROM DATA WHERE t='C C&' || 'R';
T
-----
C C&R

Report message to a moderator

Re: query for select and update [message #617531 is a reply to message #617530]

Tue, 01 July 2014 05:37

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Or:

SQL> SELECT 'C C'||chr(38)||'R' from dual;
'CC'|
-----
C C&R

Report message to a moderator

Re: query for select and update [message #617545 is a reply to message #617531]

Tue, 01 July 2014 07:51

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Or one more way :

SQL> set escape;
ESCAPE character is \

SQL> set scan off;
SQL> 
SQL> WITH DATA AS(
  2  SELECT 'CC&R' t FROM DUAL)
  3  SELECT * FROM DATA WHERE t='CC&R';
T
----
CC&R

Report message to a moderator

Previous Topic:	Unable to see database list in dropdown of pl/sql developer
Next Topic:	Issue in connecting from SQL Developer 3.2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 16:04:11 CST 2025