Oracle ALL About Dates PART 1 Understanding Date Components | oracle date format specifiers
Вставка
- Опубліковано 19 вер 2024
- Oracle ALL About Dates PART 1 Understanding Date Components
sivakacademy.b...
Click here to subscribe to my youtube channel / @sivaacademy
Oracle Interview questions and Answers at • oracle interview quest...
Oracle 18C New features at • Oracle 18C New Feature
Oracle 12C New features at • Oracle 12C New Feature...
Oracle PLSQL records and collections at • oracle plsql records a...
Sir I'm professional. For interviews I refer your interview playlist. It's very useful.
Thanks for your efforts.
@Karnaraj, Thank you :-)
Thanks for considering my comment . Expecting normalaization with simple project design 😍😍😍
@Viji, Its my pleasure Viji, Thank you....🙏.... Sure will post. i may take some time for normalization video, because, i always want to post with right set of example to make it as easy to understand...however i will definitely post...please stay tuned...Siva
Ur videos are awesome one day u will get recognized from all Oracle plsql people's.
@Research and Believe, Thank you bro....🙏.....Its my pleasure to read this comment :-)......Thanks Siva
I am obsessed with your videos when ever I need information about PL/SQL concepts thank you for these videos
My pleasure 💐🙏
Thank you so much..sir i have never found teacher like you who explain date in such way🙏
Thank you bro
it's a very nice session sir
every date components are very important, will know to each developer.
thank you.
@Rahul, Thank you bro....🙏
so clean and easy to understand. thankyou
Welcome bro
Nice work sir 👍👍👍
Also thanks for giving suggestion for trimming while extracting from date because I faced that problem already before
Always welcome
Really super sir, easily we can understand difficult topics from your videos
It's my pleasure. Thanks for your comment :-)
Thanks sir your videos are very helpful to learn more about oracle. keep on posting more videos.....
Welcome, sure, please stay tuned for more video's
Thank you sir very helpful video 😊
Welcome bro
Excellent video on dates..
How u explain.. even complex things looks simpler...Thanks Siva ...
My pleasure, welcome bro 💐💐
Please add detail explaination on string functions sir .. specially regular expressions as they are very confusing
Sure, please stay tuned 👍
shukriya, i have learned Date function
My pleasure 💐💐🙏
Sir your explanation is good and easy to understand.Please make complete SQL and pl SQL tutorials
Welcome, As soon as possible, pls stay tuned
Very well explained. Thank you.
Thank you
Thanks for giving learning experience
Welcome bro
Very nicely explained and understanding is very easy, thank you very much Siva.
Regards,
Sujaa
Thank you so much 🙂
Thanks Siva
Welcome bro
Simply Awesome, Thanks :)
Welcome bro
Nice explanation sir, pls make a video on reverse key index in which scenario we ll be go to create reverse key index? How its work internally? Interviewer asked about same
@Shashak, I have covred the reverse key index as part of index related video series. Please look into this video and let me know your feedback.
ua-cam.com/video/W7zm_7VLP5c/v-deo.html
Please tell explain and give tips about PLSQL
Sure, please stay tuned
Excellent sir
@Shaik, Thank your....🙏
Really great job sir... Well done... Sir can we use RRRR instead of YYYY.
@Sridhar, Thank you....🙏... Sure, will cover RRRR and YYYY in next video. Please stay tuned.
Thank u sir.. 👌👌👌👌
Welcome 💐🙏
Recorded morning 6 😮
You could have make another video for date function usage in Sql ... like first day of the month , last day of previous month , what happen with date TRUNC AND ROUND
@Viji, yeah viji, infact, thats the reason I started as a new series for date, in fact i have started work the another video in the same series regarding YYYY and RRRR format asked by one of the subscriber, sure i will cover all the date related information here, but due to some other videos, its getting delayed....please stay tuned...
Very nice sir
I am Waiting for your python videos from so long.. please create for us.🙏
Sure bro, please suggest some topics to start with
@@SivaAcademy Beginning we can start from data structures and one by one other topics...my expectation, I want to know real time python project details and how python helpful for data science....numpy and pandas packages 🙏🙏🙏 Thanks you for responding all viewers🔥
Sure bro, let me do
Hi, how to update only year to 2020 for date column in one table( which has different dates already)
Super sir
Thank you....🙏
Dear Siva,
Can you help me out with a query asked during interview.
Need to provide date of first day,last day of the week provided inputs are month-year and week number
example1- inputs- Aug-2021 and week- 3 then output- 15-Aug-2021,21-aug-2021
example2- inputs- July-2021 and week- 2 then output- 11-July-2021,17-july-2021
Yes bro, will post it tomorrow morning under subscriber question series, please stay tuned
hi..
can anyone tell me 1st iso week is considered based on either thursday or friday??
your videos make crystal clear concept... thnks for good work
Thanks for your comments bro 🙏
Do you post videos on informatica ETL also ?
If no, can you suggest something on that.. It will be a great help
Great
@Mugilan Thank you!!!
sir how to find no of weeks in a month ?????
TO_DATE(&1, 'YYYY-MM-DD') what does this mean .. how do i execute it
Nice. It is possible to get source code of Oracle defined functions?
@robertcrues, i never tried yet, so i cannot comment now...If i get to know, i will update you back.
@@SivaAcademy thank you
Side please provide the last query in this video we can't read the last line of the query
with d as (
select to_date('31/12/2018','DD/MM/YYYY') as dt from dual)
select c_date,trim(to_char(c_date,'DY')) day,
to_char(c_date,'W') week_of_month,
to_char(c_date,'WW') week_of_year,
to_char(c_date,'IW') iso_week_of_month
from(
select trunc(d.dt,'MONTH')+level-1 c_date
from d
connect by level
Hi sir is it possible to truncate all tables through procedures
Yes, please use dynamic SQL
Hello sir
👏🏻👏🏻👏🏻
🙏💐