-
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:
20,smith,200,03-01-02,developer,500,3000,20
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.
Deltafun
Still learning
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|