Oracle SQL Practical question | SQL to Get all dates for the given input month and year | date range

Oracle SQL Practical question | SQL to Get all dates for the given input month and year
--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

--------------------------------------------------------------

[ranajparida]

Nice video. Highly appreciated and recommended

[being__maniac]

Interview ques set is really great... Thanks a lot...

[smitanjalipatra]

Very nice explanation. Can you please share, how to find the dates for any month or year given dynamically?

[Pmreedy]

thank you, sir, keep on posting interview questions, Great sir

[rashmikrao]

print date, month, year in different columns from sysdate in oracle sql

[k.ganeshkumar]

hi sir, input given as sysdate but it will come from current month from start date to current date how to write the query

[shashank]

Awsome as always.. Bro Pls make a video on pipeline function and explain plan how it's internally worked and what is the use of nested loop join, sort merge join, hash join? 🙏

[fayasmohamed]

Trunc(<date literal>, 'MM') returns first date of the month

[RaviKumar-tcmn]

Please help me anyone in connecting to the database for SQL developer application...I am getting the error like this...TNS 12560: protocol adapter error

[srarts]

Hi Sir, i got one question in one of the interview i.e whenever they execute that query it has to give 1st day of the month. Will you please let me know which logic we shoud apply for it.

I'm thinking that, by trunc function we will get it. If yes, apart from that is there any another way to achieve that?

[chandudevarapu]

Last week We are waiting for the new video... Plz post video on regular expressions

[pintukumar-uknt]

Hi Sir,
I have a question from nvl
I have two table with date1 and date2 columns
Logic is nvl(date1, date2)
Could you please tell me how I write query for above logic

[pradiptakarmakar]

How to print start day and last day of every financial year starting from a given date

[akshaykumarpasupunooti]

Hi sir,
Can you write Query on Calendar to display all the days in that particular year?.

[praveenwin]

Dear Siva, am your channel subscriber and learning oracle concepts.Now am preparing for interview can u share the interview question u have.It will help me to get the job.please reply.

[elmorautube]

Using approximate same logic, but much less code:

SELECT TO_DATE('Jan2020', 'MonYYYY')+ (level -1) AS str
FROM dual
CONNECT BY level <= EXTRACT(DAY FROM LAST_DAY(TO_DATE('Jan2020', 'MonYYYY')))

[veeranjaneyulughantasala]

i have data like below

26 -feb 2021
27-feb-2021
28-feb -2021
30-feb-2021
31-feb-2021
31-jun-2021
32-jun-2021

i want to display on good data from each months 30, 31 -feb 2021 bad data in table
can you explain this scenaio

[sitaramsahoo]

select to_date('JAN 2021', 'MON YYYY') + (level -1) dt
from dual connect by level <= add_months(to_date('JAN 2021', 'MON YYYY'), 1)- to_date('JAN 2021', 'MON YYYY')

[ntg]

Bro I didn't know how to increment the given date by 6months

[debadattabeura]

SELECT
TO_CHAR(trunc(SYSDATE, 'MON') + level - 1, 'DD-MON-YYYY')
FROM
dual
CONNECT BY
level <= last_day(SYSDATE) - trunc(SYSDATE, 'MON') + 1