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

How its helps? Why we go for Conceptual Model?

vivekanand

• Dec 9th, 2013

Conceptual modeling is the very first level of data modeling once gathering the Business requirements. It tells about only the Entity and attributes , not the relations(constraints) or physical tables...

Sheraz Baig

• Dec 3rd, 2013

When we talk about Conceptual Model , so we definitely mean the High Level of information. Unlike Physical Model, Conceptual model doesn't discuss the data, but it discuss the process. as we told its ...

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

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

Amrut Swagat Dwivedy

• Apr 18th, 2014

These are different types of upgraded tools

Answer Question  Select Best Answer

AMRUT SWAGAT DWIVEDY

• Apr 18th, 2014

TRUNCATE Query

Code
 

Rakesh Anand

 Profile Answers by Rakesh Anand Questions by Rakesh Anand

• Aug 24th, 2013

Code
 

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

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

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

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

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

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

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

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

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

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 17th, 2015

For getting input and output

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

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

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

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