ASKER
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.
TRUSTED BY
This would be for performance only. This is the same functionality as what you had but more efficient
SELECT service_date,
open_qty,
closed_qty,
cancelled_qty,
open_closed_canc_qty
FROM dashboard_servticket_disps
WHERE service_date >= TRUNC(SYSDATE - 1) AND service_date < TRUNC(sydate)