Oracle PL-SQL Question:
Download Questions PDF

How to know the last executed procedure?

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 Interview Questions And Answers PDF

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?