what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 16894 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
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
Explain the difference between a procedure and a function? What do you understand by those terms?
Can we convert a date to char in oracle and if so, what would be the syntax?
What are the advantages of oracle?
How to unlock the sample user account in oracle?
How to retrieve data from an cursor to a record?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is Undo Management Advisor in Oracle?
How do we get field detail of a table?
How to do clean up if create database failed?
How to drop a stored procedure in oracle?
What is the difference between hot backup and cold backup in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are the different types of failures that occur in Oracle database?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is format trigger?
