When and for what purpose do we use refcursor instead of other data type?

• May 28th, 2017

Refcursor or cursor variable....is used in scenarios when you need to pass on data (as variable) between two calling programs. The data can be a result set or singular value too.

Answer Question  Select Best Answer

Scenario: I forgot to Close the Cursor in PL/SQL block. I executed the block successfully. Again I am going to execute that block without Closing the cursor. An error will be thrown or not?

M Shaun Varney

• May 13th, 2017

That depends. If the cursor is declared inside the block in question, it will be automatically closed when the block ends and you will not get an error when you open it again. However, if the cursor ...

Answer Question  Select Best Answer

How do you verify the number of Databases running on a Host?

How does CURSOR and BULK COLLECT work logically?

If there no table but we can create a synonym. If it raises error or not. If raises error what error it raises.

If a table contains 2 million rows, consider the below scenarios?
- DELETE command to delete just few rows in a 2 million row table.
- TRUNCATE command (will obviously deletes 2 million rows)
Which is faster. Truncate or Delete?

Is it possible to autoextend on option for two datafiles of same tablespace? How?

What is the use of IGNORE option in the Export and Import?

Can Multiple Database access one Instance ?
Yes or No ? Explain

What is PCT increase parameter in segment?

If it reduce the traffic then please give an example for that one

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.

Where will the transactions be stored during Hot Backup?
During hot backup we specify the tablespace during beginning backup mode and now if a user perform some transactions then where such transactions are stored?

A employee getting variable salary like Jan 3000,Feb 5000,Mar 1000 ,Apr 7000,May 500 write query to display his next salary "increse" or "decrese" as compare to previous month ,three column in the employee table empname ,salarydate,salary ?