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

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

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

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

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

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

Oracle Training in Chennai

• Mar 3rd, 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

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

In PL/SQL if we write select statement with INTO clause it may return two exceptions NO_DATA_FOUND or TOO_MANY_ROW .To avoid these execeptions. How do you write SQL statement in alternative way?

Ananda Kumar Behera

• Nov 12th, 2013

To avoid use:

Code
 

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

We can use explicit cursor to avoid Oracle exception - NO_DATA_FOUND and TOO_MANY_ROWS.

Answer Question  Select Best Answer

Rahul

• Jul 11th, 2013

It retrieve or fetch all data from Emp table,and show all data of table like Emp as result.

vaasukk@yahoo.com

• Dec 13th, 2012

First it will check the syntax and semantics in library cache, after that it will create execution plan. Already data in the buffer cache it will directly return to the client. If not it write the fetched to the dB buffer cache after that it will send server. Server sends to the client.

Answer Question  Select Best Answer

Can we pass a function name as a parameter value?? will it have any effect in performance degradation when used in a Large online transaction process?

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

About performance, it depends upon the computations you will be performing inside that function. Also, if we are using (user-defined) function in SQL (rather than creating PL/SQL), then it will give better performance.

While using user-defined functions, we need to avoid Mutating functions error.

murugesan

• Jan 19th, 2013

Yes we can pass but the function should return a value of type appropriate for the calling function

Example

round(trunc(100))

Answer Question  Select Best Answer

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 14th, 2013

We need to use triggers whenever we wish to perform an automatic operation on a DML query. In our organization we have Unix and OpenVMS servers. Due to some reason, Unix server is used to send and re...

talktobishu

 Profile Answers by talktobishu Questions by talktobishu

• May 20th, 2013

We use trigger when we want some event should happen automatically on certain desirable scenario. Lets take an example. You have a table which changes frequently,now you want to know how many times a...

Answer Question  Select Best Answer

What is the actual processing being done at backend or server side to retrive the data or complete the DML operation.

KSPradeep Rayavarapu

• Jan 28th, 2013

The order of Query Execution is following
1)From Clause
2)Where Clause
3)Group By Clause
4)Having Clause
5)Select
6)Order By Clause

Sachin Garg

• May 22nd, 2012

Hi Friends, When we pass a SELECT query it executes under some phases. That includes 1) Checking by Server Process - Which type of Query is this - Sql or Pl/sql. 2) If sql - server process puts the ...

Answer Question  Select Best Answer