bhanuchander333

 Profile Answers by bhanuchander333 Questions by bhanuchander333

• Jan 5th, 2008

RAISE statement is used to raise exception explicitly with in the EXECUTABLE sectionwhere: Exception is previously declared in declaration section as 'exception'.

ramaswamy80in

 Profile Answers by ramaswamy80in Questions by ramaswamy80in

• Sep 26th, 2007

No   you  use 'raise' to raise  exceptions   and  we  raise exceprions in Executable sectionso we are most likely to see the ' raise ' in   Eecutable sectoin

Answer Question  Select Best Answer

mala321

 Profile Answers by mala321 Questions by mala321

• Dec 24th, 2007

Hello,SQL * LOADER is a utility tool which comes inbulit with any versions of Oracle. it is used to load data (.txt,.xls, tables, Doc ...) any flat files of this type can be loaded into  Oracle d...

SrikanthPeru

 Profile Answers by SrikanthPeru Questions by SrikanthPeru

• Aug 18th, 2007

SQL*Loader is a tool used to load flat files quickly into Oracle Tables. Using this, a single flat file can be loaded into multiple tables during the same load.

Answer Question  Select Best Answer

Hi Any body know what is Crossroads skill in Oracle DBA? Please help me.

arnab

• Nov 20th, 2007

Some objects are stored in the database and can be created and manipulated with SQL but are not contained in a schema. Its called non schema object. Non schema objects are given below:- Contexts D...

Answer Question  Select Best Answer

Mudit Sharma

• Oct 27th, 2007

-?? A cluster is a set of 2 or more machines (nodes) that share or coordinate resources to perform the same task. ??????? - A RAC database is 2 or more instances running on a set of clustered...

Answer Question  Select Best Answer

pramod

• Oct 22nd, 2007

In the above code '-2' specifies that the only two digits before the decinmal points needs rounding up.and '+2' would mean two digits after the decimal point.

sudheer_ml

 Profile Answers by sudheer_ml Questions by sudheer_ml

• Apr 26th, 2006

as in u'r comment second prameter is negative,so it will count 2 digit from decimal point to left side .i.e 23 this 23 is less than 50 so it will round it zero.if u take above 50 it will round it to 1...

Answer Question  Select Best Answer

parthokonar1

 Profile Answers by parthokonar1 Questions by parthokonar1

• Sep 28th, 2007

1. Show SGA.2. It is related to block oracle has to search more.3. Increase the size of Undo segment.

Answer Question  Select Best Answer