var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: load filenames to oracle table
I have csv filenames on my UNIX directory that I download from FTP site and here's what i want to do next....
copy all csv filenames (only) and insert to and oracle table with date at the end.
ORACLE filenames after upload.
You need to look at Oracle SQL*Loader (sqlldr) my friend.
If you just want a shell script to store the filenames, with a date, in a table then the above should work fine. You'll need to :
for OLD_NAME in `ls -1 *.sh`
NEW_NAME=`echo $OLD_NAME | sed "s/\./_$TODAY./"`
CONNECT_TO_DB <<- END_SQL
values ( "$NEW_NAME" )
- set the correct directory
- check the syntax for the insert (I haven't done Oracle for a long time)
- put in the correct command and params to access your database from shell.