what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 18145 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
how may join possible between (requisition with purchase order)
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Differentiate between function and procedure in oracle.
What is an Oracle Instance?
What is save point in oracle database?
How to sort output in descending order in oracle?
What is an oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the roles of dba?
How remove data files before opening a database?
How many memory layers are in the oracle shared pool?
What are the ways tablespaces can be managed and how do they differ?
How to delete a user account in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
How to resolve name conflicts between variables and columns?
