Nice explanation sir,pls make a video on all types of hints, reverse key index, deterministic function, pipeline function , performance tuning & tricky sql interview questions.
@TechCoach
6 жыл бұрын
Hints and reverse key index are in my plan and you should see a video on them soon. For performance tuning I will also recommend watching my video series on partitioning.Thanks a lot for the kind words :)
@priyankasuryawanshi6911
Жыл бұрын
Create Or Replace Procedure Proc1(table_name varchar2) As Begin Execute Immediate 'delete from' ||table_name; End Proc1; execute Proc1('Exe_Tab2'); --when I tried to execute: execute Proc1('Exe_Tab2'); this command I am getting error that 'table or view does not exist'.. but table is already created with records.. can you please help.
@anirudhalluru8021
Жыл бұрын
We can run dml statements inside a procedure, but why its not happening with delete ??
@devanaidu9406
6 жыл бұрын
Hi bro superb explanation..every one can easily understand thank you for sharing bro..and also pls share 1).what is WHERE CURRENT OF CLAUSE,2).WHAT IS FOR UPDATE CLAUSE.and 3).what is refcursor why we using..thank you in advanced bro
@abdulmazid7615
2 жыл бұрын
Sir have created 24partitions of each hour table now I want to drop 20 partitions and insert data into 4 partitions in the same block using execute immediate please share your answer
@TechCoach
2 жыл бұрын
Created named partition so that you can easily identify and delete them
@mynamefootball
6 жыл бұрын
Hi Vivek, You have explained it very well please explain complete oracle sql in detail. Thanks in advance .
@TechCoach
6 жыл бұрын
Sure Kajal, I will upload more videos soon.Thanks for the kind words :)
@cybernetinc3775
2 жыл бұрын
Will I be able to do this without execute Immediate? BEGIN FOR Row_Call IN (SELECT * FROM My_Tmp_Tbl) LOOP DELETE FROM My_Orig_Tbl WHERE user_id = Row_Call.user_id AND join_date = Row_Call.join_date; -- Some more task END LOOP ; END;
@ztech4634
3 жыл бұрын
Awesome explanation
@TechCoach
3 жыл бұрын
Thanks a lot buddy for the kind words :)
@VikramKumarpage
6 жыл бұрын
thanks vivek sir,,,,,could you please make videos on types/collection/array. thanks in advance
@ayush120793
6 жыл бұрын
Hi Vivek, First of all, thanks for wonderful explanation. While executing a procedure where I am passing an integer into procedure block Egi: exec proc1(7);...This integer is nothing but an Employee ID of a certain table name as Employee. And when the block statement is getting executed, it is deleting the record. PFB procedure: Create or replace procedure proc1(Emp_ID) As Begin Delete from Employee where empid=Emp_ID; End; Here Employee is table having column as empid and empname. As per my understanding the sql over there is dynamic one where it is accepting runtime value 7. But it is getting executed successfully without using 'Execute Immediate' Could you please clarify what I misunderstood? Appreciate all your help!!!
@TechCoach
6 жыл бұрын
Thanks a lot for the kind words.Dynamic sql is slightly different from what you have mentioned.Dynamic sql statements are usually used when you don't know the table name or where clause or similar stuff.
@ayush120793
6 жыл бұрын
Thanks for the clarification Sir!!!...I got your point...
@TechCoach
6 жыл бұрын
Hi Ayush I am working on this new youtube channel, It would be of immense help if you and subscribe. kzitem.info/rock/oLdaMxhfDgdgIAcRGlUvkg
@ayush120793
6 жыл бұрын
Done!!!!
@aishwaryaghumekar4819
4 жыл бұрын
Thank you. This video was helpful. However I am trying to implement a query where I want to copy the data from 1 table to another and the table names have to be provided dynamically. I am using the below query and it's throwing error as: 'PLS-00103: Encountered the symbol "select * from " when expecting one of the following: . ( * @ % & = - + ; < / > at in is mod remainder not rem or != or ~= >=
@TechCoach
4 жыл бұрын
Hi Aishwarya, you are missing || before select.
@aishwaryaghumekar4819
4 жыл бұрын
@@TechCoach Thanks, this worked. Also, do you have any knowledge about how to import and use this procedure in Informatica Powercenter? Just curious.
@harikavitechnologicalfacts1334
3 жыл бұрын
Thanks for the video... helped a lot
@TechCoach
3 жыл бұрын
Thanks Buddy I am glad I could help
@ushathoughts7182
3 жыл бұрын
Hi friend. How to use DQL statement in PL/SQL.means what about select statement
@TechCoach
3 жыл бұрын
They Can be used easily inside begin end section , Let me know if you need some sample code :)
@rohitjethwani626
4 жыл бұрын
nyc video but I want to know more uses of execute immediate with examples.Please upload more video on it.
@TechCoach
4 жыл бұрын
If you want to execute a DDL inside a procedure you need to use execute immediate, if you want to create sql dynamically based on data driven scenarios then you need to use execute immediate
@mahendraeee3637
2 жыл бұрын
I need plsql job support can you help me
@TechCoach
2 жыл бұрын
I am sorry Mahendra, I am not providing any job support at the moment
@vickypatekar9532
4 жыл бұрын
It's a waaaww! Vedio Thanks Sir 🙏
@TechCoach
4 жыл бұрын
Thanks a lot for the kind words Vicky :)
@ramKumar-lf7er
2 жыл бұрын
Dynamic SQL how to use using class in SQL injection
@ankushgondane8642
6 жыл бұрын
Thank you Vivek 😊
@TechCoach
6 жыл бұрын
+Ankush Gondane You are welcome :)
@ruchitrivedi7841
6 жыл бұрын
Can you explain Collections,Triggers and Cursors?
@AnIndianAbroadd
6 жыл бұрын
Sure Ruchi I will work on it soon. I need a small help I am working on this new youtube channel and would really appreciate if you watch and subscribe to it. kzitem.info/news/bejne/kmd6sWGlsoSin2U
Пікірлер: 37