and intelligent - or we all
misunderstood what he meant (including me).
Mogens
[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject:RE: Using ' in Update statement
You guys are mean !! Tom Kyte would have given me 10 ways of writing
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
.dk Subject: Re: Using ' in Update statement
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/10/2003 12:54 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Using ' in Update statement
You guys are mean !! Tom Kyte
of list ORACLE-L [EMAIL PROTECTED]
ng.com cc:
Sent by: Subject: Re: Using ' in
Update statement
[EMAIL PROTECTED
]To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
ng.com cc:
Sent by: Subject: Re: Using ' in
Update statement
[EMAIL
:
Sent by: Subject: RE: Using ' in Update
statement
[EMAIL PROTECTED]
.com
cc:
Sent by: Subject: RE: Using ' in
Update statement
[EMAIL PROTECTED]
.com
10/10/2003 10:19
AM
]
ng.com cc:
Sent by: Subject: RE: Using ' in Update
statement
of list ORACLE-L
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Using ' in Update
statement
[EMAIL PROTECTED]
disys.comTo: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Using ' in
Update statement
: Using ' in Update statement
ity.com
:
[EMAIL PROTECTED]Subject: RE: Using ' in Update statement
ity.com
10/10/2003
List,
How can I user comma ' in my update statement?
update tablea set fielda =' james'ste Camp 'first,'sec' '
Thanks,
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hamid Alavi
It's in the documentation. Start with the concepts manual, then SQL*Plus
manual and SQL reference. I'm sure that you'll run across the answer
because that's where I have found the answer to the very same question.
On Thu, 2003-10-09 at 13:59, Hamid Alavi wrote:
List,
How can I user comma '
Do you mean a single quote? like this?:
SQL update tablea set fielda = ' james''ste Camp ''first,''sec'' ';
1 row updated.
SQL select * from tablea;
FIELDA
james'ste Camp 'first,'sec'
1 row
]
ng.com cc:
Sent by: Subject: Re: Using ' in Update
statement
[EMAIL PROTECTED
' in Update
statement
[EMAIL PROTECTED]
.com
by: Subject: Re: Using ' in Update
statement
[EMAIL PROTECTED]
.com
18 matches
Mail list logo