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

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

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

How to find out the max high value using varray?

Kaushik Nayak

• Jan 19th, 2018

Code
v_array_max := varray_1( varray_l.COUNT );
OR
v_array_max := varray_1( varray_l.LAST  );

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

Ranjan

• Dec 11th, 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

Harishankar Sahu

• Nov 24th, 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

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

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

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

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?

bhanu prakash

• May 6th, 2017

We can verify number of databases running by using pf -ef|grep pmon or smon.

aravindhreturns

 Profile Answers by aravindhreturns Questions by aravindhreturns

• Apr 22nd, 2010

Renjith, Waseem has explained for UNIX. Let me tell you how you can find the same on Windows. Go to Start Menu, Then RUN. Type “Regedit” and Get inside the registry. Go to this path &ldquo...

Answer Question  Select Best Answer

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?

Mayur

• Jan 25th, 2017

Truncate will be faster as there is no condition to check however with delete it will go through the 2 million records to find which ones fit the condition.

Answer Question  Select Best Answer

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

Dipika

• Aug 8th, 2016

Yes, a tablespace can have 2 datafile which is having autoextend on option

Answer Question  Select Best Answer

Sakshi

• Feb 21st, 2016

With Blenders, you can perform these actions:
l Process adds, moves, or deletes to an existing hierarchy
l Process activations and promotions (leaf to limb)
l Act upon any combination of hierarchies
l Create new hierarchies
l Map top nodes from a source hierarchy to nodes in a target hierarchy.

Answer Question  Select Best Answer

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

viswanath

• Jul 30th, 2015

When you put IGNORE=Y it is simply ignore the previous backup. That means, while during backup where you can stop and add another backup or file. It store the that adding file only, not whole backup.

Balakumar

• Jul 16th, 2015

For getting input and output

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: thiru

• Jun 25th, 2014

---

Using for low cardinality purpose

meera

• Apr 27th, 2015

Indexes in general speeds up the data retreival from database. Generally the index we use in OLTP or the operational database is B-Tree index. But, Bitmap index is very much important in case of data...

thiru

• Jun 25th, 2014

Using for low cardinality purpose

Improve Answer

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

Swathika

• Apr 22nd, 2015

Yes. You can use dblink to connect to multiple DB in same instance

Answer Question  Select Best Answer

What is PCT increase parameter in segment?

S. Lee

• Mar 9th, 2015

The percent increase in size of each subsequent extent that is added to your segment as it grows. Table test1 was created and is 4K in size. Initial size is set to 1K and pct increase set to 5. Once t...

Answer Question  Select Best Answer