1.如标题。sql中的值也是非常明确。需要时进行替换即可
select p_name,p_type from (
select gen_day.dates as p_name,trim(TO_CHAR(gen_day.dates,'DAY')) as p_type from (
SELECT
to_date('2022-09-21','YYYY-MM-DD')+level-1 as dates
FROM
dual
CONNECT BY
level <= to_date('2022-09-21','YYYY-MM-DD')-to_date('2022-01-12','YYYY-MM-DD')+1) gen_day
) pv_day
where p_type in ('SATURDAY','SUNDAY');
该sql作用:查询2022-09-21到2022-01-12之间的星期六和星期天日期
2.补充两个在线调试oracle的网站:
Oracle Live SQL
和
SQL Fiddle