what is the output of select * from emp where null=null &
select * from emp where 1=1
Answer Posted / anee desai
first command will give no records whereas 2nd command will
provide all records as 1 is equal to one.it is similar to
select * from emp;.if 2=2 will also provide the same
result.it makes no sense in writing 1=1;
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is system global area (sga) in oracle?
How do you store pictures in a database?
What is object data modeling?
What are operators in oracle?
how may join possible between (requisition with purchase order)
What is the difference between formal parameters and actual parameters?
What happens if the update subquery returns multiple rows?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to drop a stored procedure in oracle?
What is the difference between hot backup and cold backup in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is sharded cluster?
How to drop an index in oracle?
What is save point in oracle database?
How to apply filtering criteria at group level in oracle?