Using Oracle Metadata to your Advantage Explained with real scenarios.

[@ramchinthakayala2092]

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

[@TechCoach]

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

[@thelogans926]

Extremely helpful. Thank you so much.

[@TechCoach]

I am glad I could help :)

[@sujaa1000]

Thank you, was very very helpful!

[@vikitech9029]

Truely you are awesome bro.... Kudos

[@navneetgupta9311]

Thanks coach for this amazing video

[@maheshbabunadigoti7050]

Great explanation sir....

[@nabjt0]

good experience. tks

[@wrathwick6667]

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🔥

[@bongyvibes8239]

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?

[@pavankumarp4798]

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]

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

[@memewala8337]

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

[@shahdeena100]

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

[@TechCoach]

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

[@swarnabhd]

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

[@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

[@Emanos_Girl]

can u share the data u worked with?

[@hemantgosai1778]

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]

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

[@hemantgosai1778]

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

[@TechCoach]

You can reach out to me on [e-mail]

[@ashishrai472]

How to edit SQL query in notepad

[@TechCoach]

What are you trying to achieve Ashish?

[@ankushgondane8642]

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

[@TechCoach]

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

[@ankushgondane8642]

Can I get your email address or phone number?

[@TechCoach]

+Ankush Gondane [e-mail] Happy to help

[@ShahMdNazmulAlam-h6x]

Where is the data set.

[@vishalkoundal5008]

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

[@TechCoach]

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]

@@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]

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]

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]

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

[@muhammadadilnaeem1333]

sir how to download oracle free plz guide me

[@CodingK143]

hii

[@TechCoach]

Hello

[@anTsoziaL63]

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

[@TechCoach]

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

[@pranithhkrish1757]

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