Home » SQL & PL/SQL » SQL & PL/SQL » set off
set off [message #239682] Wed, 23 May 2007 01:23 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi
i want to update the data in column status and table proj
data in status column is
<e>Other issue's:</e> employee's status
update it to
<e>Other issue's:</e> employee's performance status
what is the option to set the ' off or how can i update this record
thanxs
Re: set off [message #239688 is a reply to message #239682] Wed, 23 May 2007 01:33 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

i am not sure whether i understood your question correctly
but if you are asking this

create table test_45(a varchar2(25));

insert into test_45 values('employees'||''''||'status');

SQL> select * from test_45;

A
-------------------------
employees'status

SQL> update test_45 set a='employee'||''''||'s status';

1 row updated.

SQL> select * from test_45;

A
-------------------------
employee's status


if i got it wrong ignore it

regards
shanth
Re: set off [message #239689 is a reply to message #239682] Wed, 23 May 2007 01:34 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
You can double the quote or - in 10gR2 - use the new 'quote construction':

SQL> SELECT 'employee''s status' method_one
  2       , q'$employees's status$' method_two
  3  FROM dual
  4  /

METHOD_ONE        METHOD_TWO
----------------- ------------------
employee's status employees's status


Or..a quick search could reveal more similar threads.

MHE
Re: set off [message #239693 is a reply to message #239689] Wed, 23 May 2007 01:58 Go to previous messageGo to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
thanxs it worked
Re: set off [message #239863 is a reply to message #239689] Wed, 23 May 2007 08:32 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Maaher wrote on Wed, 23 May 2007 02:34
You can double the quote or - in 10gR2 - use the new 'quote construction':

SQL> SELECT 'employee''s status' method_one
  2       , q'$employees's status$' method_two
  3  FROM dual
  4  /

METHOD_ONE        METHOD_TWO
----------------- ------------------
employee's status employees's status




Cool Maaher. That's a new one to me.
Previous Topic: how to get the two agregate count from two columns through the same query?
Next Topic: XQuery Basic Help
Goto Forum:
  


Current Time: Mon Dec 05 19:13:09 CST 2016

Total time taken to generate the page: 0.08106 seconds