Oracle PL-SQL Question:

How to know the last executed procedure?

Tweet Share WhatsApp

Answer:

Execute procedure name (parameter1,parameter2)

Select timestamps, owner, obj_name, action_name from dba_audit_trail;this statement gives last executed time for procedure , function & package.

Download Oracle PL-SQL PDF Read All 52 Oracle PL-SQL Questions
Previous QuestionNext Question
State the difference between implict and explict cursors?How can a function retun more than one value in oracle with proper example?