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

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

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

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

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Dec 24th, 2006

Hi,  I have checked ur query it's right. select power(2.5,3) from dual; it gives 15.625 right ans.thanks.

Answer Question  Select Best Answer

gangadharam.p

 Profile Answers by gangadharam.p Questions by gangadharam.p

• Dec 24th, 2006

hi,  IN is used to pick one by one value from a list of values.Supports numbers,chars,dates.It is a special operator.  Exists: It is also a special operator but it returns a BOOLEAN value.

Answer Question  Select Best Answer

Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc.,) and boilerplate objects (boxes, lines, images etc.,) that operators interact with us they run your form . Each canvas views displayed in a window.

Kishor Wadhi

• Dec 20th, 2006

Canvas is associated with windows , where we can define different items and Attributes.

Answer Question  Select Best Answer

Master Deletes Property Resulting Triggers ---------------------------------------------------Isolated On-Clear-Details On-Populate-Details

Manikandan

• Dec 18th, 2006

On_clear_details -form level-> calls Clear_All_Master_Details proc.on_populate_details block level->calls Query_Master_Details proc. after checking foriegn key of null value.

Answer Question  Select Best Answer

Modal windows are usually used as dialogs, and have restricted functionality compared to modelless windows. On some platforms for example operators cannot resize, scroll or iconify a modal window.

Harish

• Dec 15th, 2006

A modal window is any type of window that is a child (secondary window) to a parent window and usurps the parent's control. It is commonly associated with an Internet Web site pop-up window&...

Answer Question  Select Best Answer

Before report, Before form, After form , Between page, After report.

Prasant

• Nov 23rd, 2006

There are 3types of trigger available in report1.Report triggerbefore parameter formAfter parameter formBefore reportBetween pageAfter report2.Data Model TriggerFormula triggerGroup filter3.Layout TriggerFormat Trigger

imran zaher

• May 23rd, 2006

sequence of execution of the various report triggersBefore form , After form , Before report, Between page, After report.

Answer Question  Select Best Answer

giridhar

• Nov 3rd, 2006

Generally oracle uses Cost_based optimisation. In this method it will calculate all the execution plans for the query to execute and chooses the best optimal plan. Sometimes we may know the best execu...

Tejaswini Mohanty

• Sep 12th, 2006

HINTS  are nothing but the comments used in a SQL statement to pass instructions to the Oracle optimizer.The optimizer uses these hints as suggestions for choosing an execution plan for the state...

Answer Question  Select Best Answer

Annapurna

• Sep 20th, 2006

select (rowid) count*(distinct schoolcode)     from ( select schoolcode(rowid)                from teacher&nbs...

namita

• May 12th, 2006

Select count(distinct schoolcode) from ( select schoolcode from teacher where sex 'female') ;

Answer Question  Select Best Answer