How to last compile data and time in Oracle

Rumesh Aponso (RMAX)

Nov 20, 20241 min read

SELECT t.last_ddl_time, t.*
FROM   all_objects t
WHERE  t.object_type = 'PACKAGE BODY'
AND    t.OBJECT_NAME = 'CUSTOMER_ORDER_API';

Example 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...

FUNCTION Strip_Ora_Error ( sqlerrm_ IN VARCHAR2, sqlcode_ IN NUMBER DEFAULT NULL, strip_ora_only_ IN BOOLEAN DEFAULT...

Example 1: SELECT handling_unit_id, t.shipment_id FROM handling_unit_tab t START WITH handling_unit_id = '4558' CONNECT BY PRIOR...

Related Posts