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
- 18954 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
What is oracle join syntax?
What are the differences between date and timestamp in oracle?
What do you mean by redo log file mirroring?
How to bring a tablespace online?
Differentiate between post-database commit and post-form commit?
what is meant by magic query
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is an oracle function?
How do I spool to a csv formatted file using sqlplus?
What are the uses of linked server and explain it in detail?
What are the differences between interval year to month and interval day to second?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to define a cusotmer as a supplier in ORACLE R12
How to rename an existing table?
What is the difference between PFILE and SPFILE in Oracle?
