Can we use a having clause in groupby clause?
Submitted by: Administratorhaving 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online OCI Job Interview Questions And Answers
Top OCI Questions
☺ | What is database normalization? |
☺ | What is the main difference between foreign key and primary key? |
☺ | Tell me in function why return single value? |
☺ | What is difference between SQL Server and Oracle? |
☺ | Can we use a having clause in groupby clause? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |