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.

manideep

• Jul 13th, 2016

Truncate removes all records in table where as delete removes record by record from table.

Rollback cannot be done on truncate because it is implicit commit where rollback takes place on delete.

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

sofiya

• Mar 30th, 2016

Thanks a lot your answer was helpful.

SRINIVAS

• Dec 22nd, 2012

You just copy the SQLPlusw file and copy in another location and access from that copied file.
I think you will not get the ed or edit problem.

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

Soumya

• Dec 29th, 2015

Ref cursor allows you to open a context are without any queries. Where as the normal cursor since the time of declaration to the time the data is committed holds the query in the context area and rele...

niranjan

• Nov 25th, 2015

Can you explain with one example? Rammohan..

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

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

Oracle Training in Chennai

• Mar 2nd, 2015

A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table. Using materialize...

Ashish

• Feb 10th, 2015

Materialized views stores data init at the client side only so they do not need to fetch the records each time by hitting the database. They get the refresh only when executed manually or when set to get the refresh based on the settings. Therefore they are always faster than the normal views.

Answer Question  Select Best Answer

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?

Divakar

• Oct 31st, 2014

During hot backup, once we issue the Begin Backup command respective datafile header will be freezed, if users performs transaction it will be stored in the datafiles but the SCN # will not updated as...

pavanintouch

 Profile Answers by pavanintouch Questions by pavanintouch

• May 20th, 2014

Http://orcl11gdba.blogspot.in/2014/03/taking-hot-bakcup-database-in-begin.html

check this

Answer Question  Select Best Answer

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 ?

bharahi

• Aug 5th, 2014

It can be done by analytical function using the lead function.

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

This can be done by analytical function using the LEAD function.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: Renu

• Jan 26th, 2007

---

Materialized View stores both - definition of the view and rows resulted from execution of the viewMain disadvantage of materialized view is that, its contents get outdated when underlying base table is modified .U can refresh Materialized View using DBMS_MVIEW.REFRESH

thiru

• Jun 25th, 2014

Its a one of the oracle object,its physical storage on the disk then (dbms_refresh)

shanitha

• Sep 11th, 2012

Materialized view is a database object that contains the results of a query..

Improve Answer

JP

• May 25th, 2014

When create primary constraints oracle automatically creates Unique Index .
Using "Create index" by default oracle will create B tree index .
To create other indexes like Bit map,IOT index you need mention the Index name while creating index
ex "create Bitmap index "

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Jan 31st, 2008

Index will only help you in searching the data but unique index will provide uniqueness to the indexed column. But in both the cases NULL values are allowed to insert.

Answer Question  Select Best Answer

Jp

• May 25th, 2014

Lister is Network Service to establish connection between client machine and server .

Lister are stored at server side .Each lister listen to client request and establish connection.

Innila

 Profile Answers by Innila Questions by Innila

• Dec 4th, 2006

Oracle uses all three files (tnsnames.ora, sqlnet.ora, listener.ora) for network configuration.tnsnames.ora A tnsnames.ora file maps net service names to connect descriptors. In simple words, tnsnames...

Answer Question  Select Best Answer

AMRUT SWAGAT DWIVEDY

• Apr 18th, 2014

TRUNCATE Query

Code
TRUNCATE table table_name;

Rakesh Anand

 Profile Answers by Rakesh Anand Questions by Rakesh Anand

• Aug 24th, 2013

Code
SELECT * FROM (SELECT COLUMN_NAME, ROWNUM RN FROM TABLE)
WHERE MOD (RN, 2) <> 0;

Answer Question  Select Best Answer

Amrut Swagat Dwivedy

• Apr 18th, 2014

These are different types of upgraded tools

Answer Question  Select Best Answer

Deepika S Verma

• Mar 14th, 2014

TRUNC applies to numeric and Dates values Syntax- ------- TRUNC( number, [ decimal_places ] ) TRUNC ( date, [ format ] ) Example - --------- TRUNC(125.815) would retur...

shiiva

 Profile Answers by shiiva Questions by shiiva

• Aug 6th, 2013

We cannot compare Truncate & Trim. Truncate is a DDL command which deletes the content of a table completely, without effecting the table structure.

Trim is a function which alters the output of one of the column output of a select query.

Answer Question  Select Best Answer

What is the difference between Varray And Nested Table?

Vishnu Bharath

• Jan 8th, 2014

Varrays are generally dense , that mean you cannot delete elements of the varray.But the elements of the Nested Table are generally sparse in nature and hence the elements can be deleted in between us...

Sheraz Baig

• Dec 3rd, 2013

Both are type of collections in Oracle. In Varray because its not stored in database columns so no DML operation can be implemented but on other hand as Nested tables we can perform DML operations

Answer Question  Select Best Answer