How to skip specific column and rows while loading the data using SQL Loader | SQL Loader in oracle

How to skip specific column and rows while loading the data using SQL Loader | SQL Loader in oracle

Siva Academy

3 года назад

9,053 Просмотров

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


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

Vinod Kopuri
Vinod Kopuri - 29.10.2023 06:33

Hi bro


could you please make a video series on sql /Pl/sql developer with project

Ответить
Sagar Jadhav
Sagar Jadhav - 28.01.2023 08:17

Your Video are very informative , Please make video on Performance tuning .

Ответить
Kalyana Chakravarthy
Kalyana Chakravarthy - 30.11.2022 16:01

Hi sir,
If I want to skip 10,12 and 15 th rows, then what would be the syntax?
Regards

Ответить
jj
jj - 23.06.2022 11:42

Hello Sir, I need to discard records if certain fields are not null however I am able to put only one condition in when clause if I put more with and it's not working. Pls help. I am suck here

Ответить
Aneesh Anni
Aneesh Anni - 13.06.2022 17:54

Can you do one video about "Direct Path Load"?

Ответить
ziad fawzi
ziad fawzi - 14.05.2022 20:57

Thank you so much

Ответить
murali krishna
murali krishna - 04.04.2022 09:11

but how to ignore nth record . here filter is depnto <>10

Ответить
GS Raj
GS Raj - 18.01.2022 06:46

Thanks Shive for this new learning concepts...

Ответить
Priyanka Pande
Priyanka Pande - 01.11.2021 08:29

How to skip trailer record or last record which specifies something that is trailer information

Ответить
Data Engineering by Neeraj
Data Engineering by Neeraj - 29.05.2021 07:27

Thanks Siva

Ответить
Vasantha Yamala
Vasantha Yamala - 25.04.2021 07:02

Can we skip the columns from x to y rows? And can we skip from last? Just trying to understand do we have this in sql loader or not? Plz help

Ответить
Vishwas Khare
Vishwas Khare - 20.03.2021 13:05

Can we use load option to skip the rows?

Ответить
Satyendra Singh
Satyendra Singh - 04.03.2021 20:48

Thanks shiva, if table contain more columns then how to do

Ответить
Tarak Das
Tarak Das - 25.01.2021 06:58

Hi Siva, is there any way to find url in oracle database ?

Ответить
azhar anees
azhar anees - 07.01.2021 21:37

Good explanation 👍. keep it up!

Ответить
Sandeep OBIODI
Sandeep OBIODI - 06.01.2021 21:19

Thanks for helping on SQL loader your videos are informative and to the point. I have couple of interesting questions 1. I don't have enough delimiters for each row and I have record separator with new line it is failing to read the data my requirement is to read all the rows and display as null ofr all other columns without delimiters 2. all my records start D some of the records are in 2 lines how do we read these kind of files using external table or sql loader ?
Once again Thanks in advance and waiting for your video on this question.

Ответить
pankaj randhe
pankaj randhe - 04.01.2021 11:19

Why always everything become very easy ..when you explains the concept

Ответить
Bharat Bagul
Bharat Bagul - 03.01.2021 22:31

Nice explanation bro...

Ответить
Nigel Smith
Nigel Smith - 03.01.2021 21:50

Thanks Siva. Good explanation. Very helpful. But please, how to load dates?

Ответить
Deva Naidu
Deva Naidu - 03.01.2021 21:01

Hello Sir.. you have done super explanation Sir 👌..I like your teaching way keep it up sir..all video are very useful us to get job sir..thank you for sharing your knowledge with us..❤️

Ответить