what is the output of select * from emp where null=null &
select * from emp where 1=1
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
How to create an initialization parameter file?
How to use values from other tables in update statements using oracle?
What is the quickest way to export a table to a flat file?
Can you tell me how to add new column in existing views?how?How is possible?
What are advantages of dateset in datastage?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is merge statement used for?
what is Single Byte Overhead...?
What are the advantages of oracle 12c?
what are bitmap indexes? How does they work?
How to best split csv strings in oracle 9i?
What is oracle data type?
Explain how are indexes update?
what is the use of system.effective.date variable in oracle?
How to estimate disk space needed for an export job?