On 27/02/2009 8:37 AM, anjela patnaik wrote: > Hello all, > > I'm new to sqlite3. I have data in a Oracle table with one column being a > date type. > Now, I've exported this table into a sql file with insert statements. > > Then, I ran the .read command in sqlite3 to read in the sql statements. > sqlite doesn't support the TO_Date function.
Care to show us a small sample of what the generated SQL statements look like? > > How do I get around this? My sql file is large, i.e > 8000 rows. That's an interesting definition of "large" :-) > > Is there maybe a way to define this function internally? No ... your options are to get TOAD to put it out in a more readily digested format and/or manipulate the TOAD output with sed or a Python/perl/awk script. Instead of using a file of SQl insert statements, consider using a data file, to be loaded by the sqlite3 commandline program's .import command. > > I'm using TOAD to create the sql file from Oracle. > > Your inputs appreciated!! > > Thanks. > > ps my table schema below: > > CREATE TABLE NBIAUTO > ( > OPERATION VARCHAR2(50), > INTERFACE VARCHAR2(50), > OCRELEASE VARCHAR2(8), > RUNDATE DATE, > PRODUCTS VARCHAR2(255), > SERVER VARCHAR2(50), > REQUEST VARCHAR2(4000), > REQUEST2 VARCHAR2(4000), > RESPONSE CLOB > ) HTH, John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
