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

Rajeshwaran

• Oct 9th, 2006

 Hi sunitha,         The difference between oracle 8 and oracle 8i is that 8i supports for Internet related technologies..that is it supports for XML this feature is supplied in oracle 8i by a package named DBMS_XMLGEN .

rajat utreja

• Sep 4th, 2006

Hi thats a pretty easy question as much i knowthe version oracle8 is ORDBMSwhereas oracle8i is OIRDBMSthat means oracle8i includes certain ( I )internet features as well.contact :09868082850rajat

Answer Question  Select Best Answer