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

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

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

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

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

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

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

shantanu

• Jun 18th, 2006

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

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

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

A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.

Phani

• May 13th, 2006

A user Exit is the program that can be written and linked into the Report builder Executable. We normally get information from the Multi Organization Views ( in Reports). We have 5 different types o...

Answer Question  Select Best Answer

RATIKANTA MOHANTY

• May 13th, 2006

ImmediateDifferred->Yes  Autoquery->YesDifferred->Yes  Autoquery->No

Answer Question  Select Best Answer

namita

• May 12th, 2006

Table is not normalizedfirst we need to normalizedempid empname age officezip persozip102 bbb 24 zipc001 zipc002zipcode city street ...

Answer Question  Select Best Answer

Record group column names cannot exceed 30 characters.

srinu

• May 8th, 2006

Hi,your answer is wrong because the maximum column length is 1024 character.srinu.T

Answer Question  Select Best Answer

my_name

 Profile Answers by my_name Questions by my_name

• Apr 14th, 2006

Go to tool box ->click on mysqlDataAdapter->sql datadase is created-> sql.prompt-> click on ok button->in toolbox->windows-> datagrid->in properties of datagrid->data source & data member

Answer Question  Select Best Answer

manu

• Apr 6th, 2006

   Using group by we get set of records for particualar value or content  in column ;Means it is usde to get group of records for selecting column or grou[While Order by is used to get sorting list of  records .

Neelam Jain

• Mar 31st, 2006

groupby clause is used to group the set of record. groupby clause is used with having clause.whereas order by clause is used to sort th record either acc. or dec. order

Answer Question  Select Best Answer

Get_view_property, Set_view_property

Venkat80

 Profile Answers by Venkat80 Questions by Venkat80

• Mar 23rd, 2006

For setting the canvas properties you can use any one of the followingSET_CANVAS_PROPERTY  (canvas_id  CANVAS,   property   NUMBER,   value   &nb...

Answer Question  Select Best Answer

Issues dynamic Sql statements at run time, including server side pl/SQl and DDL

Venkat80

 Profile Answers by Venkat80 Questions by Venkat80

• Mar 23rd, 2006

This is used in form builder.To develope sql statements at run time, it may be DDL or DML statement also.

Answer Question  Select Best Answer

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 22nd, 2006

By the way, they're called columns not fields and there's no reason to expect or even thing that they will be of the same datatype. Unless it's a very special type of table it's almost guaranteed that...

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 22nd, 2006

Every Relational Database Management System has a relational catalog, (also called the data dictionary or the systme tables). It contains meta data, that's data about data. The catalog is a relational...

Answer Question  Select Best Answer

durga4578

 Profile Answers by durga4578 Questions by durga4578

• Mar 11th, 2006

Select count(empid),d.deptname from emp, dept d where d.deptno=emp.deptno group by deptno

madhu

• Feb 23rd, 2006

the query isselect d.dname,count(*)from emp e, dept dwhere e.deptno = d.deptnogroup by d.dname

Answer Question  Select Best Answer