What is the difference of using cursor for loop and open,fetch,close. Which one is better? Both are giving same output

Hi I want to know what are thw common oracle production support issues that we face when we deal with banking domain and as general too.

I am now using an Access program that was created years ago and I used it 5 yrs ago and am now back - and when I attempt to go from 1 record to another with the arrows at the bottom - it use to scan very quickly and now I have to click on the arrow each time to make it go from one record to another. Is there an easy way to make that move quickly without having to click on the arrow each time?

I have some datafiles were there on a secondary disk and that disk has become damaged and new disk at this time not available. How will I recover from this situation?

thanks in advance.
Ibrahim

In the hint, pq_distribute, which is the outer distribution table and which is the inner distribution table?

How we can decide at run time that which database is going to use among Oracle, SQL Server, MS Access and so on available databases?

What is PCTIncrease in Oracle? How the memory is allocated, reallocated and autoextended while creating tablespaces? What is meant by initial and default in tablespaces and How the next is a multiple of five times DB_BLOCK_SIZE?

What is dump destination?

What is Growth Factor?

What are Oracle Catlog & Oracle Archive Log?

What is the difference between Constraints and Validations?

Why we need both the SID and the Serial no's to kill the session?How to offload query processing from the Production DB to Standby DBWhy some times startup /as sysdba starts only the instance (Why not opening the DB)Explain the Functionality of sqlplus /nolog?

What is Wrap?

What is PGA_AGGREGRATE_TARGET parameter?

How we can increae Oracle Database Size?

How to delete disks from ASM, Delete Disk Groups from ASM when ASM instance is mount state. Provide ASM INSTNACE creation steps.

What is meant by excessive log in hot backup?

How to configure the LANFree backup using TSM in TBM AIX Platform?

What is cache hit ratio in Oracle 9i?

How to write a trigger in order to invoke a stored procedure in Oracle?