HomeОбразованиеRelated VideosMore From: Tech Coach

Oracle views explained with real project examples

70 ratings | 3693 views
This video demonstrates what are oracle views and why and when you should use them. It explains abstraction and security that the views offer with different real project examples. The DML operations you can perform on views and the restrictions. Syntax : CREATE VIEW view_name AS SELECT columns FROM tables [WHERE conditions]; Please do watch the video and leave your inputs/questions in the comments section, If you like the video give a thumbs up and share it with your friends who can benefit from this.
Html code for embedding videos on your blog
Text Comments (22)
Prem Gona (3 months ago)
I would like to add few more points on top of this tutorial. DML operations can't be performed if the view is created from more than one table.. Possibility is with instead of triggers... DML can't be done if the view has aggregate functions Set operators Check constraints Group by clause Having clause Etc etc... Row Id of the view and base table is same that's the reason when we query the view... data will be fetched from the base table.... Please add if I missed any other points
Tech Coach (3 months ago)
Thanks for adding the Information Prem.I will make another video series on trigger to explain the 1st point. I have a small request I am working on this new youtube channel. "An Indian Abroad" It will really help me if you watch and subscribe to it. https://youtu.be/q4eXyOPp-Ls
An Indian Abroad (4 months ago)
Guys please support me in building my new youtube channel "An Indian Abroad " by watching subscribing and sharing with your friends https://www.youtube.com/c/AnIndianAbroadd
rampradeep kalivarapu (4 months ago)
check option is mising......
Tech Coach (3 months ago)
Sure I will review it, I have a small request I am working on this new youtube channel " An Indian Abroad" it will really help me if you watch and subscribe to it. https://youtu.be/HBQHekM1U2c
deva able (6 months ago)
Hi bro How are you,,your explanation is very well its very helpful to all thank you for sharing your knowledge and keep sharing bro..and i have a question bro..thai is what is View with check option why it is using?pls tell me bro
Sushmita Pandey (6 months ago)
I am working in a retail based project and all your explanation with examples are really helping me understanding the project both technically and functionally. Thank you. Can you please make videos on Bigdata concepts too?
Tech Coach (6 months ago)
Thanks Sushmita for the kind words, I plan to make some videos on data science soon. May be that will help further. I am working on a new youtube channel it would be of great help if you watch and subscribe to it. https://www.youtube.com/channel/UCoLdaMxhfDgdgIAcRGlUvkg
Priyavarthini P (8 months ago)
Could u pls give a real time scenario on investment banking domain
Tech Coach (8 months ago)
Priyavarthini P Sure I shall make one soon.
rajasekhar reddy (8 months ago)
Hi sir can you please give me your mail id
Tech Coach (8 months ago)
+rajasekhar reddy [email protected]
kanth Valluru (9 months ago)
Hats off no words to say about your explanation bro ... Superb
kanth Valluru (9 months ago)
Tech Coach if you have material please send to my mail id [email protected]
kanth Valluru (9 months ago)
Sure bro
Tech Coach (9 months ago)
kanth Valluru I would recommend subscribing and following this channel, I will upload more sql videos soon
kanth Valluru (9 months ago)
Bro I want learn SQL
Tech Coach (9 months ago)
kanth Valluru Thanks for the kind words, [email protected]
kanth Valluru (9 months ago)
Can you please give me your mail id bro
siddhesh rane (9 months ago)
You can simply write insert statement as INSERT INTO VW_EMPLOYEE_DATA_PQR (EMPLOYEE_ID, FIRST_NAME, EMAIL, MANAGER_ID) VALUES(99999,'ABC','[email protected]',100);
shubham chouhan (9 months ago)
awesome explanation man ! can you please make some videos on SCD -2 scenrio based informatica
Tech Coach (9 months ago)
shubham chouhan Sure Shubham, I will try to upload one soon.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.