Lengkap

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

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

Kemahiran: Oracle, SQL, Linux

Lihat lagi: shell script read file delete line, flash script read file, shell script read file computer, script read file include email, php script read file file, shell script read file remove lines, action script read file, bash shell script read file, sample php script read file, script read file email, read xml insert table, script read file, read file insert data base mysql, send email php script read file, php script read file type, ms sql script bak file

Tentang Majikan:
( 4 ulasan ) Bangalore, India

ID Projek: #23526603

Dianugerahkan kepada:

adeeladeel1234

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

₹2250 INR dalam sehari
(43 Ulasan)
5.3

10 pekerja bebas membida secara purata ₹1490 untuk pekerjaan ini

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. Lagi

₹1500 INR dalam 2 hari
(20 Ulasan)
5.1
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 Lagi

₹2250 INR dalam sehari
(3 Ulasan)
1.8
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. ‌Reg Lagi

₹2500 INR dalam 2 hari
(1 Ulasan)
1.6
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

₹1500 INR dalam sehari
(0 Ulasan)
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

₹1050 INR dalam 7 hari
(0 Ulasan)
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.

₹1300 INR dalam sehari
(0 Ulasan)
0.0
bheemsv4445

I can work on your requirement. Please ping me database you are using and from which platform you will upload csv file.

₹600 INR dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0
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

₹1250 INR dalam sehari
(0 Ulasan)
0.0