sangeetha

• Dec 27th, 2006

In oracle,DDL command,if u give TRUNCATE command,storage of data will get lost and structure of table will be there as it,roll back option is not there once u truncate the table

gouthami

• Aug 15th, 2006

Truncate is a DDL Command. When used in SQL Statement Deletes the data of the table permanently?i.e It Cannot be rolledback Leaving only the structure behind.Ex.truncate table tablename;if the needs to be restored than use the delete command .Ex.Delete *or columns from tablename;

Answer Question  Select Best Answer

Boiler plate imagesImage Items

Srinivasa V Rao

• Dec 29th, 2006

I think there are 2 types of images one is Boiler Plate Images and another Image Items.

Answer Question  Select Best Answer

lakshmi1

 Profile Answers by lakshmi1 Questions by lakshmi1

• Jan 5th, 2007

Hey staging area is just used for data cleansing. We dont load data to the target table in the staging area.

Answer Question  Select Best Answer

By selecting the cross products tool and drawing a new group surrounding the base group of the cross products.

raju

• Jan 23rd, 2007

we can do this by cartesian productno condition to be here in querryselect e.name,e.idfrom emp e, emp p

Answer Question  Select Best Answer

shivaleela

• Jan 30th, 2007

i thk it requires 14 joiner,bcoz as per d rule 4 N table to joine v required (N-1) joins

Answer Question  Select Best Answer

Mohit Sethi

• Jan 31st, 2007

Data Pool basically explains key terminologies involved and how data are grouped into "messages", and the different classes or subclasses and "levels" within this organization.

Answer Question  Select Best Answer

An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• Feb 3rd, 2007

Lists of Values (LOVs) enable end users to choose entry field values in a form or database portlet customization form.

E.gomathi

• Feb 7th, 2006

LOV is list of values, used to popup the single or multiple values at run time

Answer Question  Select Best Answer

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

there is a concept called dependencies .please check in oracle websiteif tables is altered then view becomes invalid...............but some conditions it is not invalid for example create table table1...

ravitala

• Jul 18th, 2006

NO, the view do not get refreshed when you update a data base table immediately.We have to recompile, to get them refreshed.There are 2 methods to get that refreshed .Method One:Manual approach:-ALTER VIEW COMPILEMethod Two:Automatic approach:-Select * from

Answer Question  Select Best Answer

Sandhya Rani

• Feb 16th, 2007

Hi Satish,Instead of creating a object what you mentioned above(x/y)*100., better to create an variable so that it will solve the problem as for as my knowledge goes.lets say1, object (x)2, object (y)create a varible naming (% of x & y)you will get the proper report.Thanks & RegardsCheers,Sandhya

Answer Question  Select Best Answer

I have read somewhere as DDL statement as it has implicit commit statement.

Chiranjeevi Manne

• Mar 30th, 2007

TRUNCATE is a DDL statement which can't be rolled back as there won't be any redolog generated during the trun operation and it is the fastest way of dropping big tables avoiding tons and tons of redolog generation.

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

Other point it will not fire any trigers so it is fast .and it releases the storage space also. where delete command slower than truncate command fires triggers

Answer Question  Select Best Answer

Chiranjeevi Manne

• Mar 30th, 2007

Using OPATCH Utility

Answer Question  Select Best Answer

Chiranjeevi Manne

• Mar 30th, 2007

You can store the images in oracle database as BLOBS (Binary Large OBjetcS).

Priya

• Oct 15th, 2006

S, u can upload the image in data base,by taking datatype as Image.

Answer Question  Select Best Answer

Chiranjeevi Manne

• Mar 30th, 2007

Infact your question is not straight forward,but anyhow if you are routing the transactions to the newly created database on another server then you can export the pending data and import into new dat...

Answer Question  Select Best Answer

Laxmi Prasad

• Apr 2nd, 2007

U can call that data using database name.tablename.fields

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 22nd, 2006

since the data is in two different tables you have two different choices, JOIN or UNION.  In this case you would probably use UNION. However you can make it much simpler by just leaving the data ...

Answer Question  Select Best Answer

visitor

• Apr 13th, 2007

Normalization is a process to reduce  the redundancy in databases.meaning finding a way to represent a particular data in such a way that  with least representation also it can be accessed in all the ways possible. There are a few ways of doing it like 1nf 2nf 3nf bcnf etc..

lance cheng

• May 22nd, 2006

It adds data integrity

Answer Question  Select Best Answer