Using Oracle Metadata to your Advantage Explained with real scenarios.

Подписаться 34 тыс.

Просмотров 59 тыс.

50% 1

In this video I have explained who you can use the Oracle metadata tables to your advantage with real project scenarios and situations.
The video is a little descriptive it gives you much more than just the syntax and the tables.
All database offer a bunch of tables using which you can make smart inferences about your data,process and health of the database.
I have explained the below tables in this video and how to use them smartly
1.All_Source
2.all_objects
3.All_tables
4.all_tab_cons
5.all_constraints
I will be sharing more such places where we can use these metadata queries so don't forget to subscribe to my channel.
If you can questions/clarifications just drop a comment and I will be more than happy to solve your queries.
#OracleMetadata #Oracle #TechCoach

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

13 сен 2017

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 36

@ramchinthakayala2092 4 года назад

I have watched so many videos on RU-vid but yours always good because explained with what you have faced. Great!!

@TechCoach 4 года назад

Thanks ramanjini for the kind words. I have a small request, I am working on this new channel please do watch and subscribe to it. Your support is my motivation. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Oz4TbQwrrOY.html

@bongyvibes8239 2 года назад

Hi. I'm new to SQL. Still trying to get grips of programming with it. However watching this shows me so much potential. I need some raw data to help me start and complete my first project. Please can you guide me on this?

@navneetgupta9311 4 года назад

Thanks coach for this amazing video

@wrathwick6667 2 года назад

Could you please make some videos related to the metadata concepts like this........??????? Because You are the one who did the videos related to metadata concepts. #Tech_coach🔥

@swarnabhd 5 лет назад

Please make a video on impdp and expdp, what are triggers and uses of triggers.

@vikitech9029 Год назад

Truely you are awesome bro.... Kudos

@maheshbabunadigoti7050 4 года назад

Great explanation sir....

@nabjt0 8 месяцев назад

good experience. tks

@amanjoshi5752 Год назад

Situation - i need to see on a perticular past date ie last month 's date ,what was the status of my view whether valid or invalid.pls suggest asap if can

@memewala8337 8 месяцев назад

hello sir current scenario which learning you suggest ms sql or pl/sql for non it to it transition

@pavankumarp4798 6 лет назад

very nice explanation thanks for uploading ,please can u share one video on project explanation for a 2 years experience in pl sql dev any domain no matter (either dw , ad) ,i hope we will get it very soon

@TechCoach 6 лет назад

Sure Pavan, I will try to explain things. Though I would recommend that you watch my Datawarehouse , ODS ,Star and Snow Flake schema , Data Mart (Upcoming video) Videos.They provide you the basic conceps. PL/SQL is merely a way to implement suvh stuff

@thelogans926 8 месяцев назад

Extremely helpful. Thank you so much.

@TechCoach 8 месяцев назад

I am glad I could help :)

@hemantgosai1778 4 года назад

Hi Vivek, it's very useful information. I seen the video today and at work issues came which i resolved by this metadata information. Just request zoom in when writing query coz we are watching on mobile so cant able to see.

@TechCoach 4 года назад

I am glad hemant it helped, thanks for the great advice, I will definitely zoom in going forward :)

@hemantgosai1778 4 года назад

@@TechCoach i am highly inspire from your video n would like to talk. But don't know how.

@TechCoach 4 года назад

You can reach out to me on reachtechcoach@gmail.com

@shahdeena100 6 лет назад

Hi Vivek, could you please provide video on AWR, explain plan and join methods.

@TechCoach 6 лет назад

Sure Dina its on my list, I have a small request I am working on these new youtube channel.I would really appreciate if you watch and subscribe to it. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HBQHekM1U2c.html

@AcademicLife_ 3 месяца назад

can u share the data u worked with?

@ankushgondane8642 6 лет назад

Hi Vivek, thanks for such valuable video. How to contact you?

@TechCoach 6 лет назад

Ankush Gondane I am glad that you liked it, please let me know how can I help you

@ankushgondane8642 6 лет назад

Can I get your email address or phone number?

@TechCoach 6 лет назад

+Ankush Gondane Reachtechcoach@gmail.com Happy to help

@vishalkoundal5008 4 года назад

hi.....could you please tell me d Diff between TIMESTAMP and LAST_DDL_TIME ...wd some real time example ?

@TechCoach 4 года назад

Timestamp is a datatype that contains both date and time and last_ddl_time should indicate last time at which the object was changed. I hope this helps Vishal

@vishalkoundal5008 4 года назад

@@TechCoach tnxs 4 d swift response....yes it really help and ur videos r really informative ....could you tell me how can I contact you for such deeper knowledge or information ..:)

@vishalkoundal5008 4 года назад

I did d last analyzed query in my oracle DB and I found dat some tables having null value for LAST_analyzed column what it means dat it never be analyzed till now ...? please explain

@vishalkoundal5008 4 года назад

one more thing in d end in video u said dat you gave some queries in description or scenario.....but nothing is dere ...if you have such things please share ....

@TechCoach 4 года назад

@@vishalkoundal5008 yes that is correct, stats haven't been gathered till date for those tables

@muhammadadilnaeem1333 3 года назад

sir how to download oracle free plz guide me

@anTsoziaL63 5 лет назад

no offence to you would you stop talking and start demonstrating what is necessary

@TechCoach 5 лет назад

None taken, Thanks for the feedback.I will try to improve in the next videos.

@pranithhkrish1757 2 года назад

@@TechCoach To the Point, Crystal Clear, Much appreciated for real-time scenarios and talk about the office environment and please continue . Thanks. :)