need a sql script which will read csv file and insert into table based of one of the column value in csv

₹600-1500 INR

Completed

Posted

about 4 years ago

₹600-1500 INR

Paid on delivery

Need a Sql loader Ctl script. We have a csv like id, name, trans_id, trans_type, trans_amount 11,test1,2,TL,100 12,test1,3,BB,200 13,test3,2,TL,300 14,test4,5,TR,400 So trans_type_EXT will be table name like TL_EXT, BB_EXT like that if Id is alreay there then update else insert the record in table mentioned above column mapping will be manual based on csv reading id will go to id, name will go to name etc please ping me once you see this msg Need this urgent by today asp

Oracle

SQL

Linux

Project ID: 23526603

About the project

9 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@adeeladeel1234

Hi i can do this project please review my profile and send me message to discuss your requirements in details

₹2,250 INR in 1 day

4.5

(65 reviews)

6.3

9 freelancers are bidding on average ₹1,589 INR for this job

@finecodervw

Hi, Is it ok to provide a PL/SQL procedure for this. Let me introduce myself as an expert in Database design and analysis. I have worked on several database technologies like MS Access , SQL Server, Oracle,MySQL etc. I have more than 10 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks

₹1,500 INR in 2 days

5.0

(29 reviews)

5.3

@aap31374

Hi I have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I have attached my profile. I am immediate available to join. I am ready to work any time zone. Thanks Anil Patel

₹2,250 INR in 1 day

5.0

(5 reviews)

3.4

@anchalsingh0005

Hello, ‌Hope you doing well.I have checked all your requirements and we able to do this and deliver in time.I have 5 years of experience in these types of work. So, I believe we can do that work with your support. ‌Regards

₹2,500 INR in 2 days

5.0

(2 reviews)

2.8

@ijerdna

Good day. Over three years of experience with Python mostly using numpy and pandas. This project should not be a problem due to my previous experience. Looking forward to hearing from you. Regards, Andrej

₹1,250 INR in 1 day

5.0

(2 reviews)

0.8

@annakamatchi

Dear client I saw your requirement regarding to develop an application mapping a CSV data to database. I can develop this application within a few hours. Let share further details. Thanks and regards KT

₹1,500 INR in 1 day

0.0

(0 reviews)

0.0

@softogenel

hello, ping me I will do that right away. I am too good at SQL and these data migration system . so give that to me oi will do that Let me know if you find this helpful

₹1,050 INR in 7 days

0.0

(0 reviews)

0.0

@htoomaungthait

SQL statement that will load csv file first into temp table of targeted database and then desired column will be copied to designated table.

₹1,300 INR in 1 day

0.0

(0 reviews)

0.0

@aravindkumarv96

Since I have 3+ years experience in SQL development I can complete this project in shceduled time. Also, I can help you in optimizing existing applications.

₹700 INR in 1 day