| Back to Questions Page |
| |
| Question |
what are collection attributes |
Rank |
Answer Posted By |
|
Question Submitted By :: Nkrrish |
| This Interview Question Asked @ GE |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | collection collection  |
| Satheesh
|
| |
| |
| Question |
can we use a having cluase in groupby clause.
if there are 500 records i will give rownumber<250 then how
many records does it retrieve.
wt is the result of nvl2(null,notnull,null)
if there are four tables without using cartesian how many
joins can be there.
in the sql subqueries wt is the parent ans1)select
2)update,3) delete 4)2&3 |
Rank |
Answer Posted By |
|
Question Submitted By :: Chandra1983 |
| This Interview Question Asked @ i2 |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | having cluase can only be used with group by clause.
if there are 500 records i will give rownumber<250 then it
fetch 249 records.
NVL2( string1, value_if_NOT_null, value_if_null )
if string1 is not null then it returns 'value_if_NOT_null'
and if string1 is null then it returns 'value_if_null'.
if there are four tables without using cartesian we have n-
1 join where n is number of tables. i.e 4-1=3 join required
four tables without using cartesian. |
| Pranab
|
| |
| |
| Question |
what is difference between sap and oracle applications and
which is now market leader? |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | both are enterprice resorce planning,sap is now market
leader |
| Guest
|
| |
| |
|
|
| |
|
| |
|
Back to Questions Page |
Site Map
