search

sindicate / solidbase

SolidBase is a database change management and version control tool that uses annotated SQL
https://code.google.com/p/solidbase/
Apache License 2.0
2 stars 0 forks source link

IMPORT CSV: Quotes or not to quotes? #84

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
When importing SDO_GEOMETRY data you don't want quotes.
Is there a way to keep the quotes off?

MDSYS.SDO_GEOMETRY(2001,28992,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,1,1),MDSYS.SDO
_ORDINATE_ARRAY(202856,505380))

Original issue reported on code.google.com by rene.de....@gmail.com on 23 May 2010 at 8:33

GoogleCodeExporter commented 9 years ago 
Should we put the quotes in the import values?
Or should we use different placeholders:

:1, adds quotes
:1:, no quotes
:'1', adds quotes

Or

':1', quotes are recognized and value is escaped
Should ' :1 ' also work?

But still, no quotes is the exception:

:1, adds quotes and escaping
::1, literal

Original comment by rene.de....@gmail.com on 23 May 2010 at 9:16

GoogleCodeExporter commented 9 years ago 
Implemented:
:1 adds quotes and escaping
::1 gets literally added to the SQL (only works with the PLBLOCK and VALUESLIST 
options).

Original comment by rene.de....@gmail.com on 24 May 2010 at 4:42