Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
select 1 - ( (shelf_exp_date-trunc(sysdate)) / (add_months(trunc(sysdate),60) - trunc(sysdate)) ) from built_items where bar_code = 33502238 select shelf_exp_date, trunc(sysdate), shelf_exp_date-trunc(sysdate) from built_items where bar_code = 33502238; select add_months(trunc(sysdate),60) - trunc(sysdate) from dual;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|oracle database - pl sql code - for connecting to multiple databases from 1 database using database links||30||116|
|Assistance required for troubleshooting an issue - ORA-12154: TNS error - MS SQL Server 2008||3||69|
|how to tune the query||17||85|
|only show the last 365 days||6||35|
Join the community of 500,000 technology professionals and ask your questions.