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. ua-cam.com/video/Oz4TbQwrrOY/v-deo.html
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
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?
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. ua-cam.com/video/HBQHekM1U2c/v-deo.html
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🔥
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
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
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.
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
@@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 ..:)
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
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 To the Point, Crystal Clear, Much appreciated for real-time scenarios and talk about the office environment and please continue . Thanks. :)
I have watched so many videos on UA-cam but yours always good because explained with what you have faced. Great!!
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.
ua-cam.com/video/Oz4TbQwrrOY/v-deo.html
Extremely helpful. Thank you so much.
I am glad I could help :)
hello sir current scenario which learning you suggest ms sql or pl/sql for non it to it transition
Thank you, was very very helpful!
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
Thanks coach for this amazing video
Great explanation sir....
Truely you are awesome bro.... Kudos
good experience. tks
Please make a video on impdp and expdp, what are triggers and uses of triggers.
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?
Hi Vivek, could you please provide video on AWR, explain plan and join methods.
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.
ua-cam.com/video/HBQHekM1U2c/v-deo.html
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🔥
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
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
can u share the data u worked with?
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.
I am glad hemant it helped, thanks for the great advice, I will definitely zoom in going forward :)
@@TechCoach i am highly inspire from your video n would like to talk. But don't know how.
You can reach out to me on reachtechcoach@gmail.com
hi.....could you please tell me d Diff between TIMESTAMP and
LAST_DDL_TIME
...wd some real time example ?
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
@@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 ..:)
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
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 ....
@@vishalkoundal5008 yes that is correct, stats haven't been gathered till date for those tables
How to edit SQL query in notepad
What are you trying to achieve Ashish?
Hi Vivek, thanks for such valuable video. How to contact you?
Ankush Gondane I am glad that you liked it, please let me know how can I help you
Can I get your email address or phone number?
+Ankush Gondane Reachtechcoach@gmail.com
Happy to help
Where is the data set.
sir how to download oracle free plz guide me
hii
Hello
no offence to you would you stop talking and start demonstrating what is necessary
None taken, Thanks for the feedback.I will try to improve in the next videos.
@@TechCoach To the Point, Crystal Clear, Much appreciated for real-time scenarios and talk about the office environment and please continue . Thanks. :)