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 14th, 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

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

How does CURSOR and BULK COLLECT work logically?

SATHISH S

• Jul 28th, 2017

Cursor is storage area which stores the queried results whereas bulk collect will get bulk amount of data from cursor and insert into some cursor variables.

anil

• Apr 26th, 2017

Cursor is record by record process coming to bulk collect clause select column data at a time

Answer Question  Select Best Answer

Devanath Behera

• Oct 26th, 2017

The basic difference between Normal Cursor and Ref Cursor is as follows: 1. A Normal Cursor is a simple cursor which act as a static one where as Ref Cursor is a Dynamic Cursor which acts dynamically...

Rupesh

• Aug 29th, 2017

Normal cursor is associated with one select statement but ref cursor is associated with more than one select statement.ref cursor is dynamics cursor.

Answer Question  Select Best Answer

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

Akshay Sharma

• Nov 8th, 2017

A synonym will be created without giving any error, but before using the synonym the user must first create the table other wise it will raise an error "Synonym translation is no longer valid".

Bansilal

• Feb 19th, 2017

Yes. We can create in Oracle.

Answer Question  Select Best Answer

Harishankar Sahu

• Nov 25th, 2017

Truncate is faster. Because, its a DDL. So, no rollback information is stored. Truncate also does not consider integrity constraints; while delete does.

shaik

• Sep 7th, 2016

DELETE is a Safe mode of operation as it can be ROLLBACKed whereas TRUNCATE is Faster operation but cannot be ROLLBACKed.
DELETE can be Few Records based on WHERE Clause while the TRUNCATE is a Full operation.

Answer Question  Select Best Answer

Ranjan

• Dec 12th, 2017

Try with ed/

vipul gupta

• Mar 22nd, 2017

Is there any way to fix the ed command issue or every time we need to use define_editor=command.
Is there any permanent solution so please tell me.

Answer Question  Select Best Answer

CREATE OR REPLACE PACKAGE XX14_SO_INBOUND_PKG AS PROCEDURE main ( x_errbuf OUT NOCOPY VARCHAR2 , x_retcode OUT NOCOPY NUMBER , p_data_file_path IN VARCHAR2 ); END XX14_SO_INBOUND_PKG;

In above procedure what is the use of NOCOPY...?

Sasirekha

• Jan 8th, 2018

NOCOPY is used to pass the out variables also by reference

Answer Question  Select Best Answer

How to find out the max high value using varray?

Kaushik Nayak

• Jan 19th, 2018

Code
 

Answer Question  Select Best Answer

How to insert records into Oracle db table if I got error while inserting 4th record then how to insert 5th,6th.... records continuously

Sunil Borra

• Sep 6th, 2018

I am pretty sure that unless you correct the 4th rec or remove it altogether from all the other inserts you would not make past the 4th insert. How are you inserting the data by the way?

Answer Question  Select Best Answer

What is PCT free and PCT used?

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 15th, 2018

-- PCTFREE , PCTUSED and High Level Watermark in datablock: ------------------------------------------------------------------------------ --> HLW is a term used with table segment in DB to show the...

Answer Question  Select Best Answer

mani

• Oct 12th, 2021

Clob

Answer Question  Select Best Answer