OCI Question:
Download Job Interview Questions and Answers PDF
Can we use a having clause in groupby clause?
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.
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.
Download OCI (Oracle Call Interface) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell me in function why return single value? | What is difference between sap and oracle applications and which is now market leader? |