The o/p of the below query.. select 1/0 from dual ;
Error: Syntax error
INFINITY
NULL
0
Error: divisor is equal to zero
The o/p of the below query.. select 0/1 from dual group by dummy;
1
Error: Not a GROUP BY clause
select dummy,count(1) from dual group by dummy; O/p:
Error: Not a GROUP BY Clause
X,0
X,1
Two rows of value (X,0) & (X,1)
No rows returned
select max(5)*min(5)/avg(5) from dual group by dummy; o/p:
5
25
125
select avg(dummy) from dual; o/p:
Error: Invalid Number
Error: Invalid Character
select min(dummy) from dual union all select max(dummy) from dual group by dummy; o/p: ??
Two rows of value X and X
Error: SQL command not properly ended
Error: Not a proper GROUP BY clause
X
select min(dummy) from dual order by dummy union all select max(dummy) from dual; O/p:
Error: Not a proper ORDER BY clause
select connect from dual; o/p:
Error: Missing expression
connect
It will show connection string name
select rowid from dual;
It will show one row but no no column,no value,not even NULL value
select rownum from dual;
It will show one row but no no column,no value-,not even NULL value