How to use SQL loader to format and load the data | sql loader in oracle | SQL Loader for formatting

Подписаться 47 тыс.

Просмотров 20 тыс.

50% 1

ow to use SQL loader to format and load the data | sql loader in oracle | SQL Loader for formatting
Introduction to SQL Loader : • Oracle PL SQL intervie...
--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
/ sivaacademy
Home page: sivakacademy.blogspot.com/
Telegram Channel : t.me/SivaAcademy
--------------------------------------------------------------
Home page: sivakacademy.blogspot.com/
List of all oracle SQL/PLSQL Interview questions sivakacademy.blogspot.com/p/s...
List of all PLSQL Scenario based Interview Questions sivakacademy.blogspot.com/p/p...
List of all Subscriber questions and answers sivakacademy.blogspot.com/p/a...
--------------------------------------------------------------
Oracle Interview questions playlist • oracle interview quest...
Oracle 18C New features playlist • Oracle 18C New Feature
Oracle 12C New features playlist • Oracle 12C New Feature...
Oracle PLSQL records and collections playlist • oracle plsql records a...
--------------------------------------------------------------
My video courses at UDEMY www.udemy.com/user/2c29d781-3...
--------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos
For any questions, please drop me a mail at siva.k.academy@gmail.com
--------------------------------------------------------------

Наука

Опубликовано:

11 сен 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

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

@srinivasreddy186 3 года назад

Yes Mr. Siva, I hv learned new thing that whn we hv complex rules, we hv to create custom functions again which we must use in control file and thank you...

@SivaAcademy 3 года назад

Welcome 🙏💐👍

@chandudevarapu1578 3 года назад

Hi sir your videos are more informative and explanation is too good and mostly the key points are useful for experienced people. If it is possible plz upload performance tuning videos... tq sir

@raghum660 3 года назад

Good effort.. Thanks for sharing information...

@deepakjagdale6215 3 года назад

Nice video sir.. Thank you

@ranajparida3902 3 года назад

Nice video. Every videos are too much informative that I never skip any single second also.

@SivaAcademy 3 года назад

Thank you bro

@devanaidu9406 3 года назад

Super explanation Sir..if it is possible please do a real time example by taking one flat file data and load through sql loader sir we need to see how data will populate and tell me what is staging table and actual tables sir

@jagadeeshdora5987 3 года назад

Thanks for your video. Suppose in the external file having data in other languages (hindi or french). How can I read it convert as English and load into Oracle ? This is one of the interview question recently I faced. I'm not sure this will possible in SQL loader.

@atishkumarbarik1375 2 года назад

Hi sir, What's the use of "direct path and conventional path" in SQL loader.. Please explain the concept.

@gsekar824 3 месяца назад

Hi sir, Suggestion plz: Have multiple file like file1,file2,file3....file100 with same column name so I want append all files into single table

@kothasriharsha6501 2 года назад

Hi what if I have some terminated by comma and some data with pipe symbol How I can load that file

@govindchavhan3225 3 года назад

Superb Sir

@gsraj511 2 года назад

Thanks Siva for this detailed and very informative video...

@SivaAcademy 2 года назад

Thank you bro

@manasdash6751 Год назад

Thanks a lot for the tutorial.its very useful in realtime environment

@SivaAcademy Год назад

You are welcome

@vijayak7473 3 года назад

Shiva sir, please do make a videos on performance tuning ..

@nileshdivate1 Месяц назад

Can you please make video on below topics Methods in sql loader Oops concepts in pl-sql

@devikas1125 3 года назад

Can you please explain the unit convertion in plsql..like 5.874 kg into 5 kilo and 874 gram..?

@jsnow07grad 5 месяцев назад

This is so helpful!

@SivaAcademy 5 месяцев назад

Thank you

@ShivaKumar-ps1vh 3 года назад

Very nice and detailed explanation 👌

@SivaAcademy 3 года назад

Thanks a lot 😊

@KISHOREKUMAR-yv2sd 2 года назад

SQL*Loader-522: lfiopn failed for file (gna.log).. bro,could you please tell me reason for this error

@vandanapatel5884 Год назад

How can we load Object storage *.dat file oracle cloud data into ATP table using SQL Loader ?

@abhijitmane9949 Год назад

great , Thanks

@SivaAcademy Год назад

Welcome bro

@KarupuSuper 3 года назад

Nice sir super

@subbareddygade4586 3 года назад

sir plz make a videos, regular expression concepts

@ramchinthakayala2092 Год назад

Can we invoke SQL loader in SQL* plus, if yes please let me know the script? Thanks in advance!

@deivajothilakshmanan3273 3 года назад

Great work bro

@SivaAcademy 3 года назад

Thank you

@mukeshchitte3870 3 года назад

Thank you...

@SivaAcademy 3 года назад

Welcome

@akhilpagadala50 3 года назад

Hi Sir, Could you please explain, what is fragmentation,defragmetation, how it is benficial in size, performance.

@SivaAcademy 3 года назад

sure, please stay tuned.

@sagarvallal331 3 года назад

Hi sir, I am big fan of your videos , can u please make some videos on Oracle architecture , dba concepts ? Thanks in advance

@SivaAcademy 3 года назад

Sure bro, please stay tuned

@nagaswathichaluvadi3523 3 года назад

Hi sir ,can you please make a detailed video on regular expression s and wild characters

@SivaAcademy 3 года назад

Please stay tuned 👍

@shanmugapriya2880 Год назад

Can we add date column in control file which is not in datafile

@SivaAcademy Год назад

But, what's the need to add in control file? Do you want to populate some default date value to a column?

@kartickchakraborty9135 3 года назад

Hi Siva, I'm Kartick from Kolkata, how are you? I've just started learning Oracle. But, I find it difficult to make out the Tablespace concept in oracle. Can you make a complete video on Tablespace like what is Tablespace, how to create it, why is it so important, how to create users, roles and pass the role to users. I can't understand at all from my Book. Please make a video on this as soon as possible. Because books are really hard to understand sometimes.❤️❤️❤️

@SivaAcademy 3 года назад

Hi Kartick, thanks for your comments, sure, please stay tuned, I will add to upcoming list of videos, please stay tuned

@manoranjanray8181 3 года назад

Can't we edit the file then load it😜.. Thanks, please keep uploading new videos

@SivaAcademy 3 года назад

😀, this is a sample file having few records, editing real time files having thousands of lines is not possible

@jainaraianrai8807 3 года назад

I have learnt much from you but I have a question if you help me, I will be grateful to you. I want generate attendance sheet. Logic is------- I. Minimum 4 day should be present. II. at least one side of holiday should be present otherwise weekly off/holidays counted as absent. Example is given bellow: date emp_no Status Remarks 01-AUG-20 12.00 JJT0000002 on leave from leave table (paid) 02-AUG-20 12.00 JJT0000002 Sunday from dual table (paid) 03-AUG-20 12.00 JJT0000002 on leave from leave table (paid) 04-AUG-20 12.00 JJT0000002 Present attendance table (paid) 05-AUG-20 12.00 JJT0000002 Present 06-AUG-20 12.00 JJT0000002 Present 07-AUG-20 12.00 JJT0000002 Present 08-AUG-20 12.00 JJT0000002 Present 09-AUG-20 12.00 JJT0000002 Sunday Paid 10-AUG-20 12.00 JJT0000002 Absent Absent one day 11-AUG-20 12.00 JJT0000002 holiday paid 12-AUG-20 12.00 JJT0000002 Present paid 13-AUG-20 12.00 JJT0000002 Absent All count absent due to both side absent 14-AUG-20 12.00 JJT0000002 holiday 15-AUG-20 12.00 JJT0000002 holiday 16-AUG-20 12.00 JJT0000002 Sunday 17-AUG-20 12.00 JJT0000002 Absent 18-AUG-20 12.00 JJT0000002 Absent Absent due to 4 day absent before Sunday 19-AUG-20 12.00 JJT0000002 Absent 20-AUG-20 12.00 JJT0000002 Absent 21-AUG-20 12.00 JJT0000002 Working Day 22-AUG-20 12.00 JJT0000002 Working Day 23-AUG-20 12.00 JJT0000002 Sunday

@SivaAcademy 3 года назад

Whats the expected output for the dataset you have given about?