I am trying to import (with .import) into SQLite3 some tables that are currently in an Oracle instance. To do this I am using an Oracle script (a nice one I found at http://www.tek-tips.com/viewthread.cfm?qid=1250849&page=8) . This script produces another script which is then executed. The result is almost what I want, but there are a couple of minor issues. The first is that every value is surrounded by double quotes. This is OK except that SQLite keeps the quotes. So for instance in the file I might have "5.4", which sqlite evidently keeps as a string instead of the number 5.4 (the column is declared numeric). I can fix that problem by removing the quotes from the produced script, but I wondered if there was a way for sqlite to interpret a value depending on the type of the column. The second issue is null values. With the quotes removed, null values come out as nothing beteween the delimiters, e.g. 2007-06-08,70,70,5,70,70,5,,,,,,,, ends with eight null values. Sqlite interprets each as the empty string "", which is not the same thing. I presume if it said NULL it would be right, but I can't figure out how to make the script output NULL instead of nothing (and Oracle's NVL doesn't do the right thing for me). So is there a way to have SQLite interpet a missing value as NULL?
Thanks, Liam
