We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Need help on decision table structure||7||58|
|Performance Issue in Oracle||3||48|
|In Oracle 12c how to add to the right side of my table, the colums and data of 2 other tables .||9||34|
Join the community of 500,000 technology professionals and ask your questions.