What is view? Complex query a database la store panrathuku view use panrom.. Where complex query getting data? Normalla, yeppa ellam nama query run panromo Oracle gets data from the underlying base table. Incase of complex query namma multiple table use panni result ta get panrom... i.e view act as a 3rd party.. whenever we apply DML operation on view it will affect the base table bcoz view does not have/hold any data of its own instead getting data from base table... So it will affect base table.... While performing DML operation on view we have some restrictions... We cannot directly apply DML on the complex views(getting data from multiple table) in this case we have to use INSTEAD OF TRIGGERS to do DML operations
Hi, Your video was awesome. You have clearly explained the complex topics in simple way. Kindly upload the triggers, cursors and packages concepts. It will really helps to learn!!
Hi bro video explanation is very nice.but I have one doubt.dml view use panna base table entha changes aakathu thana.please tell me
What is view?
Complex query a database la store panrathuku view use panrom..
Where complex query getting data?
Normalla, yeppa ellam nama query run panromo Oracle gets data from the underlying base table. Incase of complex query namma multiple table use panni result ta get panrom... i.e view act as a 3rd party.. whenever we apply DML operation on view it will affect the base table bcoz view does not have/hold any data of its own instead getting data from base table... So it will affect base table....
While performing DML operation on view we have some restrictions... We cannot directly apply DML on the complex views(getting data from multiple table) in this case we have to use INSTEAD OF TRIGGERS to do DML operations
Thanks lot bro...
Hi, Your video was awesome. You have clearly explained the complex topics in simple way. Kindly upload the triggers, cursors and packages concepts. It will really helps to learn!!
Good explanation bro
Good explain
👍👍
Hi BRO, please upload SQL loader and external table....
Nalla solli kiduthinga bro ana ethana ok va
Flow la varuthu bro. Don't worry will recreate the SQL series without ok va.
Broo neega Institute yethachi run pantrigala?
No, bro..