Oracle PL-SQL Question:
Download Job Interview Questions and Answers 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.
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 Question | Next Question |
| State the difference between implict and explict cursors? | How can a function retun more than one value in oracle with proper example? |