NYCPHP Meetup

[Nunez, Eddy]

I'm been working with Oracle a long time.  I have been trying to avoid
using double quotes for strings.  Single quotes (') works best.
And, yes, doubling up on the quotes acts as an escape character for them
in strings.

-EAN

-----Original Message-----
From: Daniel Convissor [mailto:danielc at analysisandsolutions.com]
Sent: Wednesday, February 04, 2004 1:33 PM
To: NYPHP Talk
Subject: [nycphp-talk] oracle delimited identifiers


Hi Y'all:

Working on a new method for PEAR DB that would quote identifiers.  The SQL 
standard, and Oracle supports, delimiting identifiers using double quotes:

   create table "name w space" (...

This works fine in Oracle.  The SQL standard also says if one wants to use
quotes inside the name, escape them with double quotes:

   create table "name w ""quote and space" (...

But, when I do this under Oracle, it chokes saying "ORA-03001:  
unimplemented feature."  So, in Oracle, are quotes inside delimited
identifiers verboten or is there some other escaping method?

Tried finding it in the docs and oracle news group archives but couldn't 
locate an answer in a reasonable amount of time.

Thanks,

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409
_______________________________________________
talk mailing list
talk at lists.nyphp.org
http://lists.nyphp.org/mailman/listinfo/talk


**************************************************************
This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is protected by law.  If you are not the intended recipient, please contact sender immediately by reply e-mail and destroy all copies.  You are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
TIAA-CREF
**************************************************************