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

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?

---------------------------------------------------------------------------------------------------------------------------

This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------
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

---------------------------------------------------------------------------------------------------------------------------

[wonkhong]

Great quality content & presentation- I went through all 66 videos and thoroughly enjoyed the review/learning, thank you thank you thank you!!!

[nareshreddy]

If anyone watch this video they must remember this subject. Because your explanation way is awesome brother We just loved it

[yogiacooldude]

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?

[Kk-yndk]

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

[samkhan]

Very nice video. Please start creating such more video. really very helpful video. Thanks a lot for your hard work.

[vikaskumar-qrtj]

@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

[GurmelSingh]

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.

[riyazbabushaik]

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?

[shashank]

Awsome explanation bro as always, i am eagerly waiting ur performance tuning videos

[sasoyu]

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)

[amarsharma]

Watching ur videos have helped a lot.. Keep posting 😊

[vinodnapa]

Can you drop a video on using error log table method with merge statements?

[masalhemant]

I'm big fan of your all vedio's

[ankandey]

Cant We use merge update insert and load the data from source to target

[surajnalawade]

Can we use simple where condition?
where empid not in (select empid from target table );
Might be dumb question, nobbie here :)

[bhojrajsingh]

Hi Sir,
Why cant we use merge statement??

[C.Morandini]

What about MERGE INTO statement? Great video nevertheless!

[ramkumarvaratharajan]

Is it available in all versions? Like 10g and 11g...

[amolrao]

Nice explanation sir. Thank you. Can u plz make video on oracle hints sir.

[hariprasathmp]

If we disable the constraint in the target table if that works for the similar rule