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?
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.
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.
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?
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
Great quality content & presentation- I went through all 66 videos and thoroughly enjoyed the review/learning, thank you thank you thank you!!!
My pleasure 🙏, thank you 💐💐👍
If anyone watch this video they must remember this subject. Because your explanation way is awesome brother ..... We just loved it
My pleasure :-) thank you
Very nice video. Please start creating such more video. really very helpful video. Thanks a lot for your hard work.
Thank you 🙏
Awsome explanation bro as always, i am eagerly waiting ur performance tuning videos
Welcome bro, starting next week, please stay tuned
@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
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?
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.
Perfectly explained. Thanks sir
Thank you 🙏
Watching ur videos have helped a lot.. Keep posting 😊
Thank you
I'm big fan of your all vedio's
Thank you
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.
Thank you, I guess you are looking for MERGE STATEMENT
Excellent Presentation..!!
Thank you
What about MERGE INTO statement? Great video nevertheless!
Yes, adding the merge statement in next video
Nice explanation sir. Thank you. Can u plz make video on oracle hints sir.
Thank you, please stay tuned
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?
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)
Yes, its covered in part 2 of video
Great sir 👌🙏
Thank you
Great content! Excellent ..
welcome :-)
Awesome video .. Great 👍 .
Welcome :-) Thank you 👍
Hi Siva , can u send me your personal number ? avijayakanth@gmail.com
Please send me mail to Siva.k.academy@gmail.com
Can you drop a video on using error log table method with merge statements?
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
Nice explanations....
Thanks and welcome
We can use minus also right?
Nice
Thank you
Cant We use merge update insert and load the data from source to target
If we disable the constraint in the target table if that works for the similar rule
it wont work, for that other options are there, you can merge statement, i will explain in next video, please stay tuned
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);
Can we use simple where condition?
where empid not in (select empid from target table );
Might be dumb question, nobbie here :)
Yes we can use, thats covered in part 2 of the video
Is it available in all versions? Like 10g and 11g...
Not sure in older version, but available from 12 onwards
Tq bro ...........
Welcome
Hi Sir,
Why cant we use merge statement??
Can we use merge
Can you please create Oracle architecture of key concepts ,sga pga,log writer etc
sure, please stay tuned
@@SivaAcademy Thanks a lot
Is it vedio out for oracle architecture?
Siva Sir...how can i solve this question using oracle sql???
yes, you can do using sql also, explaining in the next video, please stay tuned
Bro can u please make BULK_EXCEPTIONS consept ....
Yes, please stay tuned.
For insertion, cannot we merge operator ??
Yes we can, that's covered in next video
Can't we simply " Merge" for this desired output ?????
yes, we can, posting the merge in next video
You could have written not in in where