Tamamlanmış

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

Beceriler: Oracle, SQL, Linux

Daha fazlasını gör: 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

İşveren Hakkında:
( 4 değerlendirme ) Bangalore, India

Proje NO: #23526603

Seçilen:

adeeladeel1234

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

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% INR
(43 Değerlendirme)
5.3

Bu iş için 10 freelancer ortalamada ₹1490 teklif veriyor

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. Daha Fazla

₹1500 INR in 2 gün içinde
(20 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(3 Değerlendirme)
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 Daha Fazla

₹2500 INR in 2 gün içinde
(1 Yorum)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
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 in 7 gün içinde
(0 Değerlendirme)
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 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)
0.0