MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
1 select sum( case when to_char(josh_date + t500.id -1 ,'Dy') in ('SAT','SUN') 2 then 0 else 1 end) as days from ( 3 select max(case when first_name = 'priya' then hire_date end ) as priya_date, 4 max( case when first_name = 'joshua' then hire_date end) as josh_date 5 from employee 6 where first_name in ('priya','joshua') ) x,t500 7* where t500.id <= priya_date - josh_date + 1 SQL> / where first_name in ('priya','joshua') ) x,t500 Error comes : Table or view not exist
|Oracle 10g - insert string with special characters||8||55|
|Import and exporting Oracle Data with encrypted columns||4||26|
|create a nested synonym||4||24|
|Creation date for a PDB||5||18|