SQL & PL/SQL

Hello,

i have a table with the date column name “document_date” Using this column i need to get the date .

condition is "document_date" - 50 working days and this excluding weekends and holidays(we have separate table)

below is the script:

create table sample_dt
(
id number(3),
document date

);

1 ‘01-02-23’
2 '03-03-23'
3 '04-04-23'
4 '02-05-23'

Holiday table:

create table hol
(
hol_dt date
);

‘04-04-23’
'02-05-23'

Thanks in advance.