What is the syntax for setting columns of type Oracle DATE ?
Lets assume that in an Oracle database with open file handle db there is a column sched in table foo that has been created as follows : direct db, “create table foo (event char(20) primary key, sched date)” To variously populate the rows by means of the compile-time DIRECT statement : direct db, “insert into foo values (vacation_start, null)” direct db, “insert into foo values (birthday_ time, to_date(‘19970811211405′,’YYYYMMDDHH24MISS’) )” direct db, “insert into foo values (today, sysdate)” Alternatively, to populate the rows by means of the run-time COPY after using the Warehouse SETVAR statement to assign a value to the sched column : setvar sched = $null setvar sched = str2date(“19970811 211405″,”YYYYMMDD HH24MISS”) setvar sched = $today
