Тёмный

Oracle views explained with real project examples 

Tech Coach
Подписаться 33 тыс.
Просмотров 58 тыс.
50% 1

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.

Опубликовано:

 

14 сен 2017

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 67   
@sushmitapandey4970
@sushmitapandey4970 6 лет назад
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
@TechCoach 6 лет назад
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. ru-vid.com/show-UCoLdaMxhfDgdgIAcRGlUvkg
@saifparkar6078
@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
@syedsabeer1027 3 года назад
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
@TechCoach 3 года назад
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
@mazdysoraya6121 4 года назад
Thank you mister, excellent explanation, subscribed.
@TechCoach
@TechCoach 4 года назад
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GnVn3mPBRz4.html
@premgona5587
@premgona5587 6 лет назад
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
@TechCoach 6 лет назад
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-q4eXyOPp-Ls.html
@snowflakehelpers4600
@snowflakehelpers4600 4 года назад
Very nice...just gone through this
@anilk3417
@anilk3417 5 лет назад
Excellent one :)
@ranajparida3902
@ranajparida3902 4 года назад
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
@snowflakehelpers4600
@snowflakehelpers4600 4 года назад
Thanks a lot vivek you are awesome brother....your explanation are very very clear
@TechCoach
@TechCoach 4 года назад
Thanks a lot Sanjeev for the kind words , your support is my motivation
@cmpsnehrunagar9754
@cmpsnehrunagar9754 3 года назад
Fantastic
@jodgaming4837
@jodgaming4837 Год назад
Awesome
@devanaidu9406
@devanaidu9406 6 лет назад
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
@vanisusi7966
@vanisusi7966 3 года назад
Vivek , thanks for the real time explanation . Also I couldn't find the continuation video for this concept . Can u help me out .
@jayasuman7502
@jayasuman7502 4 года назад
Very good video and explanation.
@TechCoach
@TechCoach 4 года назад
Thanks Jaya suman for the kind words :)
@priyavoonna5967
@priyavoonna5967 Год назад
Nice explanation sir
@subbukakumani1843
@subbukakumani1843 2 года назад
Thanks for the explanation!
@TechCoach
@TechCoach 2 года назад
Glad it was helpful!
@husenmobilesworld6482
@husenmobilesworld6482 3 года назад
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.
@ch3ragCS
@ch3ragCS 3 года назад
Great Explanation.
@TechCoach
@TechCoach 3 года назад
Thanks a lot Bharat for the kind words :)
@ballaramya153
@ballaramya153 2 года назад
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..
@metyazidan9509
@metyazidan9509 2 месяца назад
It was helpful 😊
@kanthvalluru5424
@kanthvalluru5424 6 лет назад
Hats off no words to say about your explanation bro ... Superb
@TechCoach
@TechCoach 6 лет назад
kanth Valluru Thanks for the kind words, Reachtechcoach@gmail.com
@kanthvalluru5424
@kanthvalluru5424 6 лет назад
Bro I want learn SQL
@TechCoach
@TechCoach 6 лет назад
kanth Valluru I would recommend subscribing and following this channel, I will upload more sql videos soon
@kanthvalluru5424
@kanthvalluru5424 6 лет назад
Sure bro
@kanthvalluru5424
@kanthvalluru5424 6 лет назад
Tech Coach if you have material please send to my mail id Kanth.8011@gmail.com
@shubhamchouhan8149
@shubhamchouhan8149 6 лет назад
awesome explanation man ! can you please make some videos on SCD -2 scenrio based informatica
@TechCoach
@TechCoach 6 лет назад
shubham chouhan Sure Shubham, I will try to upload one soon.
@grvmavi
@grvmavi 3 года назад
Thanks Brother
@TechCoach
@TechCoach 3 года назад
Thanks Gaurav for the kind words :)
@ShubhamPandey-bb2ho
@ShubhamPandey-bb2ho 3 года назад
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.
@chiranjivgupta7097
@chiranjivgupta7097 3 года назад
Can we connect regarding on the topic of Editioning of DBA objects.? I would be very grateful if you can help me out.
@purushothamanthillaw.sa.pi8483
@purushothamanthillaw.sa.pi8483 4 года назад
can you please upload a video for " tell me about u r project" banking or insurance
@poongodibanu2036
@poongodibanu2036 2 года назад
Can u please share view types like force view , instead view
@priyavarthinip874
@priyavarthinip874 6 лет назад
Could u pls give a real time scenario on investment banking domain
@TechCoach
@TechCoach 6 лет назад
Priyavarthini P Sure I shall make one soon.
@deep54046
@deep54046 4 года назад
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
@TechCoach 4 года назад
Views don't contain any data , materizaled view does. Can you please clarify your doubt again??
@Karsh.y
@Karsh.y 3 года назад
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
@TechCoach 3 года назад
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
@Karsh.y 3 года назад
@@TechCoach ya pretty much.... thanks , so in short it simplifies fetching the data.
@TechCoach
@TechCoach 3 года назад
@@Karsh.y it does and you can limit the data access as well.you can provide access to views and not tables
@Karsh.y
@Karsh.y 3 года назад
@@TechCoach ohkay 😊 got it thanks a lot
@fathimanisha2723
@fathimanisha2723 Год назад
Hi brother Can I get sample transaction table DDL and DML scripts?
@poongodibanu2036
@poongodibanu2036 2 года назад
Can u please share plsql videos as well
@saravanabhavyakuttam7520
@saravanabhavyakuttam7520 2 года назад
How to get the data in materialized view?
@TechCoach
@TechCoach 2 года назад
Hey buddy yoi have to refresh it to get the data
@xtempo9913
@xtempo9913 3 года назад
can we use INSERT in view ?
@TechCoach
@TechCoach 3 года назад
You can but it is not advised.
@Ganeshay-996
@Ganeshay-996 2 года назад
How to download transaction script
@rampradeepkalivarapu7753
@rampradeepkalivarapu7753 6 лет назад
check option is mising......
@TechCoach
@TechCoach 6 лет назад
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HBQHekM1U2c.html
@besttube2401
@besttube2401 5 лет назад
U r wrong... While doing DML operations view does not execute.. it is just rename of query
@AnIndianAbroadd
@AnIndianAbroadd 5 лет назад
Thanks for your input, I will look into it.
Далее
Materialized views in oracle - Part 1
19:03
Просмотров 75 тыс.
Ayollar orzusidagi er😂😂
01:01
Просмотров 963 тыс.
Never waste PASTA SAUCE @itsQCP
00:19
Просмотров 7 млн
What is ETL | What is Data Warehouse | OLTP vs OLAP
8:07
Indexing in Oracle :B-Tree,Bitmap Indexing
25:47
Просмотров 88 тыс.
MySQL VIEWS are awesome
6:03
Просмотров 51 тыс.
Partitioning in Oracle - Performance Basics
28:35
Просмотров 51 тыс.
Why I Quit the Scrum Alliance
7:58
Просмотров 9 тыс.