what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 16868 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / samir kumar sahoo
select*from emp where null=null;
this command will not return any record bcoz the
condition null=null false as two null values are not equal.
select*from emp where 1=1;
will return all the records present in the table emp as
the condition 1=1 is always true.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is parameterized cursor in oracle?
How to drop a stored function?
What is a nested table and how is it different from a normal table?
How to get maxsal , minsal, ename department wise in single query
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Explain what are the type of synonyms?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Explain oracle 12c new features for developers?
How to revoke create session privilege from a user in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is the difference between formal parameters and actual parameters?
How does one get the view definition of fixed views/tables?
How to define an anonymous block?
How to define default values for formal parameters?
Explain the use of Merge statement in oracle 11g
