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. ruclips.net/channel/UCoLdaMxhfDgdgIAcRGlUvkg
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. ruclips.net/video/q4eXyOPp-Ls/видео.html
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..
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. ruclips.net/video/GnVn3mPBRz4/видео.html
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.
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..
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.
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
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?
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. ruclips.net/video/HBQHekM1U2c/видео.html
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.
ruclips.net/channel/UCoLdaMxhfDgdgIAcRGlUvkg
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.
ruclips.net/video/q4eXyOPp-Ls/видео.html
Very nice...just gone through this
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
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
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.
Very good video and explanation.
Thanks Jaya suman for the kind words :)
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.
ruclips.net/video/GnVn3mPBRz4/видео.html
Thanks for the explanation!
Glad it was helpful!
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
Nice explanation sir
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.
Great Explanation.
Thanks a lot Bharat for the kind words :)
Fantastic
It was helpful 😊
Awesome
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..
Hi can you share the transaction table file for performing or referring that data for beginners
How to get the data in materialized view?
Hey buddy yoi have to refresh it to get the data
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.
Hi brother
Can I get sample transaction table DDL and DML scripts?
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
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.
Can u please share view types like force view , instead view
Excellent one :)
Can u please share plsql videos as well
Vivek , thanks for the real time explanation . Also I couldn't find the continuation video for this concept . Can u help me out .
can we use INSERT in view ?
You can but it is not advised.
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
Could u pls give a real time scenario on investment banking domain
Priyavarthini P Sure I shall make one soon.
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.
can you please upload a video for " tell me about u r project" banking or insurance
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??
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.
ruclips.net/video/HBQHekM1U2c/видео.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.