Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 19282 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / anitha
select * from emp where null=null: will not return any rows
in the table since two null values are not always same.
select * from emp where 1=1 : will return all the rows in
the table because 1 is always equal to 1.
| Is This Answer Correct ? | 36 Yes | 1 No |
Post New Answer View All Answers
How to execute the package in oracle?
What is rowid and rownum in oracle?
Explain an exception and its types?
How to write a query with an inner join in oracle?
How different is ms access and oracle?
What happens in oracle commit?
What are the attributes of cursor?
How can we create the complete backup of data in the 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?
How to end the current transaction in oracle?
What is the difference between formal parameters and actual parameters?
How to write a query with a left outer join in oracle?
How to create a testing table in oracle?
How to invoke the original export import utilities?
Describe varray?
