Тёмный

Oracle PL SQL interview question | How to Exclude duplicate records while insertion| Error Log Table 

Подписаться
Просмотров 32 тыс.
% 551

Oracle PL SQL interview question | How to Exclude duplicate records while insertion|
How to use Error Log Table?
What is IGNORE_ROW_ON_DUPKEY_INDEX hint?
Oracle Error Log table : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zaCKsOPZuf0.html
---------------------------------------------------------------------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
ru-vid.com
---------------------------------------------------------------------------------------------------------------------------
Home page: sivakacademy.blogspot.com/
List of all oracle SQL/PLSQL Interview questions sivakacademy.blogspot.com/p/sql-plsql-interview-questions.html
List of all PLSQL Scenario based Interview Questions sivakacademy.blogspot.com/p/plsql-scenario-based-interview-questions.html
List of all Subscriber questions and answers sivakacademy.blogspot.com/p/all-subscriber-questions-and-answers.html
---------------------------------------------------------------------------------------------------------------------------
Oracle Interview questions playlist ru-vid.com/group/PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm
Oracle 18C New features playlist ru-vid.com/group/PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW
Oracle 12C New features playlist ru-vid.com/group/PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx-
Oracle PLSQL records and collections playlist ru-vid.com/group/PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
---------------------------------------------------------------------------------------------------------------------------
My video courses at UDEMY www.udemy.com/user/2c29d781-3879-41b5-a304-ea8325f15806/
---------------------------------------------------------------------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 10 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
---------------------------------------------------------------------------------------------------------------------------

Наука

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

 

15 авг 2020

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 68   
@wonkhong
@wonkhong 3 года назад
Great quality content & presentation- I went through all 66 videos and thoroughly enjoyed the review/learning, thank you thank you thank you!!!
@SivaAcademy
@SivaAcademy 3 года назад
My pleasure 🙏, thank you 💐💐👍
@nareshreddy6450
@nareshreddy6450 3 года назад
If anyone watch this video they must remember this subject. Because your explanation way is awesome brother ..... We just loved it
@SivaAcademy
@SivaAcademy 3 года назад
My pleasure :-) thank you
@parthkulkarni5373
@parthkulkarni5373 3 года назад
Perfectly explained. Thanks sir
@SivaAcademy
@SivaAcademy 3 года назад
Thank you 🙏
@shashank2004
@shashank2004 3 года назад
Awsome explanation bro as always, i am eagerly waiting ur performance tuning videos
@SivaAcademy
@SivaAcademy 3 года назад
Welcome bro, starting next week, please stay tuned
@samkhan4214
@samkhan4214 5 месяцев назад
Very nice video. Please start creating such more video. really very helpful video. Thanks a lot for your hard work.
@amarsharma5616
@amarsharma5616 3 года назад
Watching ur videos have helped a lot.. Keep posting 😊
@SivaAcademy
@SivaAcademy 3 года назад
Thank you
@suraj454
@suraj454 3 года назад
Great content! Excellent ..
@SivaAcademy
@SivaAcademy 3 года назад
welcome :-)
@bhamidipatikittu
@bhamidipatikittu 3 года назад
Excellent Presentation..!!
@SivaAcademy
@SivaAcademy 3 года назад
Thank you
@chavannamdev1959
@chavannamdev1959 2 года назад
Great sir 👌🙏
@SivaAcademy
@SivaAcademy Год назад
Thank you
@masalhemant4255
@masalhemant4255 3 года назад
Nice explanations....
@SivaAcademy
@SivaAcademy 3 года назад
Thanks and welcome
@vikaskumar-qr5tj
@vikaskumar-qr5tj 2 года назад
@Siva do you provide any training on Oracle forms and reports you are just great sir I am already following you since last 6 months
@masalhemant4255
@masalhemant4255 3 года назад
I'm big fan of your all vedio's
@SivaAcademy
@SivaAcademy 3 года назад
Thank you
@dhanrajramekar9378
@dhanrajramekar9378 2 года назад
We can use below insert with subquery as : insert into emp_target SELECT * FROM emp_source where empno not in (select empno from emp_target);
@vijiinfo
@vijiinfo 3 года назад
Awesome video .. Great 👍 .
@SivaAcademy
@SivaAcademy 3 года назад
Welcome :-) Thank you 👍
@vijiinfo
@vijiinfo 3 года назад
Hi Siva , can u send me your personal number ? avijayakanth@gmail.com
@SivaAcademy
@SivaAcademy 3 года назад
Please send me mail to Siva.k.academy@gmail.com
@riyazbabushaik8393
@riyazbabushaik8393 3 года назад
Good explanation Siva bro, Recently I have faced few interview question from TCS Techincal panel Q: Can we use Aggregate functions(min,max,count,avg) on check constaint while table creation? Q: while calling the procedure, If the procedure gets an exception how can we find out the error line number?
@akshayjoshi4106
@akshayjoshi4106 3 года назад
regarding second question you can use dbms_utility.format_error_backtrace to identify the errored line. Please let me know if i am incorrect or any differences.
@paricherlamathaiah5820
@paricherlamathaiah5820 3 года назад
Tq bro ...........
@SivaAcademy
@SivaAcademy 3 года назад
Welcome
@GurmelSingh03
@GurmelSingh03 3 года назад
Great explanation 👌. Can you please give me sql developer query without creating error log table based on below query and conditions. Query: Insert into table1(name, sallery, state) Select name, sallery, 'delhi' from table2 Where name='tom' 1. I want to insert new rows only into table1. If same row data already present then ignore otherwise add new entry. 2. I want to insert and update data into table1 if data is already present then update same otherwise add new entry.
@SivaAcademy
@SivaAcademy 3 года назад
Thank you, I guess you are looking for MERGE STATEMENT
@amolrao3464
@amolrao3464 3 года назад
Nice explanation sir. Thank you. Can u plz make video on oracle hints sir.
@SivaAcademy
@SivaAcademy 3 года назад
Thank you, please stay tuned
@yogiacooldude
@yogiacooldude 3 года назад
Thanks for this video. i have one question. what will be the performance of Hint in case we are inserting millions of rows? is there any other method to insert unique only in other table having maximum performance. this question is asked generally on the basis of performance. there is a one way i.e. Exchange Partition . do we have any other in case of INSERT?
@eddiehapson1730
@eddiehapson1730 Год назад
Nice
@SivaAcademy
@SivaAcademy Год назад
Thank you
@elmorautube
@elmorautube 3 года назад
What about MERGE INTO statement? Great video nevertheless!
@SivaAcademy
@SivaAcademy 3 года назад
Yes, adding the merge statement in next video
@sasoyu8922
@sasoyu8922 3 года назад
Nice explanation! But i'm quite sure that It Is possible to insert that tuples adding a NOT EXISTS clause in the query (After the part insert into)
@SivaAcademy
@SivaAcademy 3 года назад
Yes, its covered in part 2 of video
@vinodnapa7889
@vinodnapa7889 3 года назад
Can you drop a video on using error log table method with merge statements?
@Kk-yn7dk
@Kk-yn7dk 3 года назад
We can use left outer join and then insert the non matching records from source table into target table. Please let ne know if my understanding is wrong
@ankandey7583
@ankandey7583 3 года назад
Cant We use merge update insert and load the data from source to target
@hariprasathmp9893
@hariprasathmp9893 3 года назад
If we disable the constraint in the target table if that works for the similar rule
@SivaAcademy
@SivaAcademy 3 года назад
it wont work, for that other options are there, you can merge statement, i will explain in next video, please stay tuned
@devilmaycry3537
@devilmaycry3537 3 года назад
We can use minus also right?
@bhojrajsingh8737
@bhojrajsingh8737 Год назад
Hi Sir, Why cant we use merge statement??
@poojabhat7698
@poojabhat7698 10 месяцев назад
Can we use merge
@praveencbharadwaj
@praveencbharadwaj 3 года назад
Can you please create Oracle architecture of key concepts ,sga pga,log writer etc
@SivaAcademy
@SivaAcademy 3 года назад
sure, please stay tuned
@praveencbharadwaj
@praveencbharadwaj 3 года назад
@@SivaAcademy Thanks a lot
@mahendrasinghthakur9471
@mahendrasinghthakur9471 3 года назад
Is it vedio out for oracle architecture?
@nareshreddy6450
@nareshreddy6450 3 года назад
Bro can u please make BULK_EXCEPTIONS consept ....
@SivaAcademy
@SivaAcademy 3 года назад
Yes, please stay tuned.
@ramkumarvaratharajan4980
@ramkumarvaratharajan4980 3 года назад
Is it available in all versions? Like 10g and 11g...
@SivaAcademy
@SivaAcademy 3 года назад
Not sure in older version, but available from 12 onwards
@surajnalawade4019
@surajnalawade4019 3 года назад
Can we use simple where condition? where empid not in (select empid from target table ); Might be dumb question, nobbie here :)
@SivaAcademy
@SivaAcademy 3 года назад
Yes we can use, thats covered in part 2 of the video
@prasadkumbhar1935
@prasadkumbhar1935 3 года назад
Siva Sir...how can i solve this question using oracle sql???
@PrayasITandRobotics
@PrayasITandRobotics 2 года назад
For insertion, cannot we merge operator ??
@SivaAcademy
@SivaAcademy 2 года назад
Yes we can, that's covered in next video
@mohammedalikhan7306
@mohammedalikhan7306 11 месяцев назад
You could have written not in in where
@moviemaRKer
@moviemaRKer 3 года назад
Can't we simply " Merge" for this desired output ?????
@SivaAcademy
@SivaAcademy 3 года назад
yes, we can, posting the merge in next video