Oracle views explained with real project examples
Вставка
- Опубліковано 14 вер 2017
- 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.
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.
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?
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.
ua-cam.com/channels/oLdaMxhfDgdgIAcRGlUvkg.html
Thank you mister, excellent explanation, subscribed.
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.
ua-cam.com/video/GnVn3mPBRz4/v-deo.html
Excellent one :)
Fantastic
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..
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
Nice explanation sir
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
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.
ua-cam.com/video/q4eXyOPp-Ls/v-deo.html
Very nice...just gone through this
Awesome
Great Explanation.
Thanks a lot Bharat for the kind words :)
Thanks for the explanation!
Glad it was helpful!
Very good video and explanation.
Thanks Jaya suman for the kind words :)
Thanks a lot vivek you are awesome brother....your explanation are very very clear
Thanks a lot Sanjeev for the kind words , your support is my motivation
It was helpful 😊
Vivek , thanks for the real time explanation . Also I couldn't find the continuation video for this concept . Can u help me out .
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
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..
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.
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
Hats off no words to say about your explanation bro ... Superb
kanth Valluru Thanks for the kind words, Reachtechcoach@gmail.com
Bro I want learn SQL
kanth Valluru I would recommend subscribing and following this channel, I will upload more sql videos soon
Sure bro
Tech Coach if you have material please send to my mail id Kanth.8011@gmail.com
awesome explanation man ! can you please make some videos on SCD -2 scenrio based informatica
shubham chouhan Sure Shubham, I will try to upload one soon.
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.
Thanks Brother
Thanks Gaurav for the kind words :)
Can we connect regarding on the topic of Editioning of DBA objects.?
I would be very grateful if you can help me out.
Can u please share view types like force view , instead view
can you please upload a video for " tell me about u r project" banking or insurance
Hi brother
Can I get sample transaction table DDL and DML scripts?
Can u please share plsql videos as well
Could u pls give a real time scenario on investment banking domain
Priyavarthini P Sure I shall make one soon.
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?
Views don't contain any data , materizaled view does. Can you please clarify your doubt again??
can we use INSERT in view ?
You can but it is not advised.
How to get the data in materialized view?
Hey buddy yoi have to refresh it to get the data
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
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.
@@TechCoach ya pretty much.... thanks , so in short it simplifies fetching the data.
@@Karsh.y it does and you can limit the data access as well.you can provide access to views and not tables
@@TechCoach ohkay 😊 got it thanks a lot
How to download transaction script
check option is mising......
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.
ua-cam.com/video/HBQHekM1U2c/v-deo.html
U r wrong... While doing DML operations view does not execute.. it is just rename of query
Thanks for your input, I will look into it.