Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Feb 1st, 2008

Select * from user_indexes where status ='Invalid'you can specify index_name in the same query to look for a particular INDEX.

deepsk singh

• Jul 16th, 2007

If you want to know which one?is invalid/valid; you find out from the data dictonary table user_objects and execute query select * from user_objectswhere object_type = 'INDEX'and status ='INVALID' ---and status ='VALID'

Answer Question  Select Best Answer

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

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

KAMRANSAJID

 Profile Answers by KAMRANSAJID Questions by KAMRANSAJID

• Sep 21st, 2007

Crystal Report supports to create report from third party database, Oracle Report supports to create report from Oracle Database only.

najeebasghar

 Profile Answers by najeebasghar Questions by najeebasghar

• May 11th, 2007

Crystal Report is third party tool to develop different types of reports, just to connect database which are oracle , ms sql 2000 and ms access etc where as Oracle report is specially used for oracle data base

Answer Question  Select Best Answer

Catalina

• Sep 25th, 2007

It seems that, if the main query selects from a great number of rows, than Oracle will have a better execution plan if you use EXISTS. If the main query selects from a small number of rows, while...

Answer Question  Select Best Answer

roniprasan

 Profile Answers by roniprasan Questions by roniprasan

• Sep 4th, 2007

Char(size) max size upto 2000 min  1varchar2(size) max upto 4000 min 1

Answer Question  Select Best Answer

roniprasan

 Profile Answers by roniprasan Questions by roniprasan

• Sep 2nd, 2007

Raise_application_error(error number,error discription)

aseemnaithani

 Profile Answers by aseemnaithani Questions by aseemnaithani

• May 3rd, 2006

Hi,,it is Raise_Application_error

Answer Question  Select Best Answer

Vrushali

• Aug 9th, 2007

Tablespace : A tablespace is a logical structure on a Oracle database consisting of one or more datafiles. The objects are stored in a tablespace.Clusters: When two or more tables have a requirements ...

Ramco

• Oct 9th, 2006

Table space is the logical data units of a database. every database is divided into Database -> tablespace -> segments - > externsin short (tablespace is a logical group of data files in a da...

Answer Question  Select Best Answer

Magu

• Aug 5th, 2007

Isolated join is a join which is not connected to any of the context.

Answer Question  Select Best Answer

Asad

• Jul 30th, 2007

Index are reference to data in tables's columns on what they are based. Index work exactly in way? like we have book's index describing its chapters and what page # chapter can be found.They only con...

Answer Question  Select Best Answer

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

When you execute query oracle checks for various things syntax, access and then generate optimize plan and in this stage parsing happens. when the query plan is already there in sga you get hit and that is soft parsing..else hard1. Soft parsing2. Hard parsing

Answer Question  Select Best Answer

sik tauk

 Profile Answers by sik tauk Questions by sik tauk

• Apr 26th, 2007

If you are a DBA, login on the host using sqlplus to the database using sys as sysdba privilege.$ export ORACLE_HOME=<ORACLE_HOME>$ export ORACLE_SID=<ORACLE_SID>$ sqlplus "/ as ...

daniels

• Dec 18th, 2006

You could also do the following.dbms_utility.compile_schema(schema IN VARCHAR2,compile_all BOOLEAN DEFAULT TRUE,reuse_settings BOOLEAN DEFAULT FALSE);exec dbms_utility.compile_schema('SCOTT');

Answer Question  Select Best Answer

Innila

 Profile Answers by Innila Questions by Innila

• Mar 22nd, 2007

Hi,Lookup tables are like master tables which are static & will be referred by other Base tables for reference.Lookup tables are basically used for referring a predefined data which are stored in these tables.*** Innila ***

Red

• Mar 11th, 2007

A look up table is a table whose values are seldom or never updated. They are basically used for references. A good example of a look-up table is a 'country's' table.

Answer Question  Select Best Answer

mani

• Mar 6th, 2007

Connect as sysdba and typeselect * from v$sgainfo;

rajatm2

 Profile Answers by rajatm2 Questions by rajatm2

• Dec 1st, 2006

connect sqlplus using sys or system or any user .and type show sgaregardsRajat

Answer Question  Select Best Answer

vigneshkumar

 Profile Answers by vigneshkumar Questions by vigneshkumar

• Feb 16th, 2007

The large pool is created to avoid contention in the shared pool in the case of shared server environment..The UGA process takes place in the shared pool in the case of shared server environment..so to avoid contentions all the user processes are shifted to the large pool..

Answer Question  Select Best Answer

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 13th, 2007

New Features in 9i are 1.Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4....

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 13th, 2007

New Features in 9i are1. Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4....

Answer Question  Select Best Answer