using perl to generate sql statement from csv file
Hi, dear gurus,
I am oracle dba trying to learn Perl to help with my oracle. But I am not good enough to write a code to do what i want to do. Could anybody help me with a simple code to generate a insert statement from say a csv file.
example,the csv file:
I need a perl script to read this file and generate output of:
insert into emp values(20,'smith',200,'03-01-02','developer',500,3000,200;
Any help would be appreciated. Thanks.