Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
No Answer is Posted For this Question
Be the First to Post Answer
What are the parameters that we can pass through a stored procedure?
Differentiate between function and procedure in oracle.
how to do daily transactions with out sql* loader control file regesterd in apps?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
Explain the use of consistent option in exp command.
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
what is the use of composite key constraint?
What is a snapshot in oracle database?
how to get second highest sal of emp table
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this