SQL:SQL* Loader Part-2

SQL:SQL* Loader Part-2

RRK Data N Flix

10 лет назад

34,527 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@sameeh174
@sameeh174 - 17.08.2021 19:19

is this tutorial about variable length ?

Ответить
@NaaAnveshanaAnnaSupporters
@NaaAnveshanaAnnaSupporters - 22.09.2020 11:03

Very nicee

Ответить
@milindbidve446
@milindbidve446 - 04.03.2019 17:11

Nice explanation. Just a suggestion that please increase your volume in next videos.

Ответить
@patrickilunga1535
@patrickilunga1535 - 25.10.2018 19:09

i have error message SP2-0734: unknown command beginning "LOAD DATA ..." - rest of line ignored.

Ответить
@kaesavansridhar5050
@kaesavansridhar5050 - 25.10.2017 15:16

it shows error for me as multiple values in control file path please help me

Ответить
@kunfumas
@kunfumas - 04.06.2017 17:14

Its helpful.Thank u..But some tyms u r hesitating and try to make better screenplay...windows are not covered properly...

Ответить
@santoshram08
@santoshram08 - 03.06.2017 11:16

Hey Radhika- Thanks for the tutorial, very helpful especially for a beginner like me.

Ответить
@juanfelipeperezramirez5699
@juanfelipeperezramirez5699 - 12.10.2016 19:14

I have a .txt file which contains the data to be loaded into a table in a DB. The data correspond to a table with 300 columns. Is there anyway I can generate the .ctl file automatically? I dont want to write
Field1 position(x,y) dataType,
....
....
field300 position(w,z) dataType.
Thanks

Ответить
@somesh217
@somesh217 - 17.09.2016 17:25

Thnanks radhika,
One doubt, above process if failing when i have last column as null
details:
select * from employees; exported to , seprated csv file, and using that file in above example..

Ответить
@syedtaukiralam2606
@syedtaukiralam2606 - 11.06.2016 05:07

thanx

Ответить
@anudeepv9074
@anudeepv9074 - 12.04.2016 20:37

Thank you Radika..........

Ответить
@TheAshik09
@TheAshik09 - 12.01.2016 15:20

I get an error in cmd Access is Denied. any idea of that

Ответить
@mohdsaqib2796
@mohdsaqib2796 - 14.12.2015 13:32

hi radhika.........thanks great tutorial!!!!

Ответить
@sreenivasuludevineni2411
@sreenivasuludevineni2411 - 29.11.2015 21:27

thank you veru much for your tutorial

Ответить
@Eisenhiem24
@Eisenhiem24 - 14.07.2015 14:18

Hey Radhika.....great tutorial!!!!
However i am unable to load the data in the table.
I get the following message in my command line:
Load completed  - Logical record count 22

Also it creates a bad file but how do I read the bad file

Ответить
@superkutta
@superkutta - 28.04.2015 22:45

Thank you sister very much for sharing this knowledge.

Ответить
@sunitapandey4077
@sunitapandey4077 - 24.04.2015 12:06

hi Radhika ...nice video but i had one doubt you said at the end  that there is no log file as there was no error but log file is just a summary so it should have been created even when there is no error.

Ответить
@ravichandra436
@ravichandra436 - 01.09.2014 12:11

tnx for the video very useful :)

Ответить