Hello All,
Oracle 12c
Do you have any idea why there is no corresponding row to PROGRAM_ID?
SELECT
(SELECT a.OBJECT_NAME FROM DBA_OBJECTS a WHERE a.OBJECT_ID = V.PROGRAM_ID) OBJECT_NAME,
V.PROGRAM_ID,
V.PROGRAM_LINE#
FROM V$SQL V
WHERE SQL_ID = 'lkjasd7843k';
OBJECT_NAME PROGRAM_ID PROGRAM_LINE#
-------------------- ---------- -------------
525398476 2015
Thanks