Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

get dates between two date per person

user222Feb 3 2024 — edited Feb 10 2024

hi every one

I want Your Support to solve this query

I f i have table EMP_TRANS


CREATE TABLE EMP_TRANS
(
  EMP_ID      NUMBER,
  START_DATE  DATE,
  END_DATE    DATE
);
SET DEFINE OFF;
Insert into  EMP_TRANS
   (EMP_ID, START_DATE, END_DATE)
 Values
   (1001, TO_DATE('1/3/2021', 'MM/DD/YYYY'), TO_DATE('5/1/2021', 'MM/DD/YYYY'));
Insert into FAMILY_SURVEY.EMP_TRANS
   (EMP_ID, START_DATE, END_DATE)
 Values
   (1002, TO_DATE('7/30/2022', 'MM/DD/YYYY'), TO_DATE('9/22/2022', 'MM/DD/YYYY'));
Insert into  EMP_TRANS
   (EMP_ID, START_DATE, END_DATE)
 Values
   (1003, TO_DATE('1/5/2023', 'MM/DD/YYYY'), TO_DATE('5/30/2023', 'MM/DD/YYYY'));
Insert into  EMP_TRANS
   (EMP_ID, START_DATE, END_DATE)
 Values
   (1004, TO_DATE('1/30/2023', 'MM/DD/YYYY'), TO_DATE('4/1/2023', 'MM/DD/YYYY'));
COMMIT;

i want the out put like this

– get month year per emp

I try To use connect by level but not work good

I use oracle database 19.0.0.0.0

thanks in advance

This post has been answered by mathguy on Feb 3 2024
Jump to Answer
Comments
Post Details
Added on Feb 3 2024
5 comments
168 views