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
- 19250 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
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is the difference between translate and replace?
How to start instance with a minimal initialization parameter file?
Explain enable novalidate constraint.
How to use "out" parameter properly?
Where do you use decode and case statements?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What are the restrictions on external table columns?
What is Undo Management Advisor in Oracle?
How to convert dates to characters in oracle?
How to delete a user account in oracle?
What are the different types of record groups in oracle? Explain each of them
What is private procedure oracle?
What is tns entry?
How index is implemented in oracle database?
