After the query is executed but before the report is executed and the records are displayed.

krishna631

 Profile Answers by krishna631 Questions by krishna631

• May 31st, 2006

HaiBefore report trigger fires after, the parameter trigger raises and before data fetch for that query.Krishna Mohan

Answer Question  Select Best Answer

jatinder

• Jun 6th, 2006

The suggested size of SGA should be half of RAM i.e 1GB in this case.For OLTP database

sapna

• Apr 4th, 2006

What is the answer?

Answer Question  Select Best Answer

shantanu

• Jun 18th, 2006

no, its not possiable, coz packge is a database object personal to database.

Answer Question  Select Best Answer

Ramasamy PL

• Jul 24th, 2006

The trigger followed by a DML Operation is called dml triggers.Here the constraint is table used by the DML operation cant be used by trigger.Voiding this will to runtime error.

missoracle

• Jul 18th, 2006

Wrap :- this is used to encript the PL/SQL .sql file.

Answer Question  Select Best Answer

Anupam Bera

• Aug 9th, 2006

If you use CASE , then optimize your query by adding /*+CHOOSE*/..This way case is faster than decode.Also if there any case where you need to use decode under decode then that would be cumbersome and trickier. Then it's better to use CASE.

samir das

• Oct 31st, 2005

Yes

Answer Question  Select Best Answer

sunildas4U

 Profile Answers by sunildas4U Questions by sunildas4U

• Aug 24th, 2006

SQL injection is a security vulnerability that occurs in the database layer of an application. The vulnerability is present when user input is either incorrectly filtered for string literal escape cha...

Answer Question  Select Best Answer

murali

• Aug 29th, 2006

Cube is a multidimensional structure through which v can view the information in different perspectives.Specifiaclly this cube is created whenever we want to represants the huge volumes of data in a report.one cube is used for one report generation.

Answer Question  Select Best Answer

singapore_li

 Profile Answers by singapore_li Questions by singapore_li

• Sep 15th, 2006

Subject AreasParty,Party Asset,Location,Campaign,product .................

singapore_li

 Profile Answers by singapore_li Questions by singapore_li

• Sep 15th, 2006

FSLDM COnsists of 10 Subject Areasparty,party asset,address,compaign.......

Answer Question  Select Best Answer

A combo box style list item combines the features found in list and text item. Unlike the pop list or the text list style list items, the combo box style list item will both display fixed values and accept one operator entered value.

HiTen Kotak

• Sep 20th, 2006

It's like pre-defined box having a list of value & operator can select any of them...for an example "Sex:" or "State" here you can use combo box..as you can pre-define these values.

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

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

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

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

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

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

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

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

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