Oracle views explained with real project examples

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.
#OracleViews #Viewsinoracle #TechCoach
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.

[@sushmitapandey4970]

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?

[@TechCoach]

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. kzbin.info/door/oLdaMxhfDgdgIAcRGlUvkg

[@saifparkar6078]

Hi, just want to let you know, you are doing an amazing job. Your content, teaching style is absolutely nice. Liked your videos amd subscribed.

[@syedsabeer1027]

Thank you so much.... 😊😊 very clear really I am very satisfied with view concept... I am waiting for further concepts... Thank you so much vivek anna..

[@TechCoach]

Hi Syed I have around 80 videos on similar topic that may help you. Please take some time to go through them as well. They may help you

[@mazdysoraya6121]

Thank you mister, excellent explanation, subscribed.

[@TechCoach]

Thanks mazdy Soraya for the kind words. I have a small request, I am working on this new channel and will really appreciate if you watch and subscribe to it. kzbin.info/www/bejne/fZ-5n2ajhaeFsJY

[@ranajparida3902]

Hello Nice explanation. Below are few queries and concerns if you can add in you vedio 1. Can you show how a DML operation using complex view fails. 2. At the last minute you mentioned to provide few senario regarding view, could you please provide the same. Regards, Ranaj

[@jayasuman7502]

Very good video and explanation.

[@TechCoach]

Thanks Jaya suman for the kind words :)

[@husenmobilesworld6482]

If you explain the quaries from beginning of creating tables(perticular concept) then it will be more clear, but you already created table so we don't know what data you given . Because of this it is bit hard to understand quaries. Please explain the examples like who needs some more information from you sir. It's very honour to see a guy like you to helping this video lots of people.

[@premgona5587]

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

[@TechCoach]

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. kzbin.info/www/bejne/p2XIiayFhdVggtU

[@snowflakehelpers4600]

Very nice...just gone through this

[@priyavoonna5967]

Nice explanation sir

[@ballaramya153]

Pls upload more videos brother.on each topic in plsql.this is my request why bcz I'm newly joined with role as plsql developer.i subscribed u r channel also.excellent explanation..

[@subbukakumani1843]

Thanks for the explanation!

[@TechCoach]

Glad it was helpful!

[@snowflakehelpers4600]

Thanks a lot vivek you are awesome brother....your explanation are very very clear

[@TechCoach]

Thanks a lot Sanjeev for the kind words , your support is my motivation

[@vanisusi7966]

Vivek , thanks for the real time explanation . Also I couldn't find the continuation video for this concept . Can u help me out .

[@devanaidu9406]

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

[@cmpsnehrunagar9754]

Fantastic

[@jodgaming4837]

Awesome

[@metyazidan9509]

It was helpful 😊

[@ch3ragCS]

Great Explanation.

[@TechCoach]

Thanks a lot Bharat for the kind words :)

[@kanthvalluru5424]

Hats off no words to say about your explanation bro ... Superb

[@TechCoach]

kanth Valluru Thanks for the kind words, [e-mail]

[@kanthvalluru5424]

Bro I want learn SQL

[@TechCoach]

kanth Valluru I would recommend subscribing and following this channel, I will upload more sql videos soon

[@kanthvalluru5424]

Sure bro

[@kanthvalluru5424]

Tech Coach if you have material please send to my mail id [e-mail]

[@chiranjivgupta7097]

Can we connect regarding on the topic of Editioning of DBA objects.? I would be very grateful if you can help me out.

[@ShubhamPandey-bb2ho]

Hi, Is it possible to change the column name of a view after it has been created? If yes then will you please help me out with the query.

[@shubhamchouhan8149]

awesome explanation man ! can you please make some videos on SCD -2 scenrio based informatica

[@TechCoach]

shubham chouhan Sure Shubham, I will try to upload one soon.

[@shincha133]

Hi can you share the transaction table file for performing or referring that data for beginners

[@grvmavi]

Thanks Brother

[@TechCoach]

Thanks Gaurav for the kind words :)

[@poongodibanu2036]

Can u please share view types like force view , instead view

[@anilk3417]

Excellent one :)

[@purushothamanthillaw.sa.pi8483]

can you please upload a video for " tell me about u r project" banking or insurance

[@poongodibanu2036]

Can u please share plsql videos as well

[@fathimanisha2723]

Hi brother Can I get sample transaction table DDL and DML scripts?

[@saravanabhavyakuttam7520]

How to get the data in materialized view?

[@TechCoach]

Hey buddy yoi have to refresh it to get the data

[@deep54046]

You mentioned one point. Suppose i am creating a view with 450 million records, this is a huge replication we are doing and it will surely hamper the performance. So whats the solution to this?

[@TechCoach]

Views don't contain any data , materizaled view does. Can you please clarify your doubt again??

[@Karsh.y]

hey, can't we just give the select query with where condition of fast sales(if not for security reason)...that will suffice and no need of view. So i want to know the real reason to use a view

[@TechCoach]

Your view is made up after joining 5 tables and you only want to fetch the data from last 3 years , it will be much more clean to abstract the complex joins by using a simple view I hope that clarifies.

[@Karsh.y]

@@TechCoach ya pretty much.... thanks , so in short it simplifies fetching the data.

[@TechCoach]

@@Karsh.y it does and you can limit the data access as well.you can provide access to views and not tables

[@Karsh.y]

@@TechCoach ohkay 😊 got it thanks a lot

[@priyavarthinip874]

Could u pls give a real time scenario on investment banking domain

[@TechCoach]

Priyavarthini P Sure I shall make one soon.

[@xtempo9913]

can we use INSERT in view ?

[@TechCoach]

You can but it is not advised.

[@Ganeshay-996]

How to download transaction script

[@besttube2401]

U r wrong... While doing DML operations view does not execute.. it is just rename of query

[@AnIndianAbroadd]

Thanks for your input, I will look into it.

[@rampradeepkalivarapu7753]

check option is mising......

[@TechCoach]

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. kzbin.info/www/bejne/fnO0eZihgpaIaMU