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
- 19532 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
Difference between the “verify” and “feedback” command?
How to define default values for formal parameters?
What is an oracle database table?
Is oracle a programming language?
What are the extensions used by oracle reports?
interview questions with answer for cts
What is the data pump import utility?
How to create a stored function in oracle?
What privilege is needed for a user to create indexes in oracle?
Explain the use of indexes option in exp command.
What is blob data type in oracle?
How to use "if" statements on multiple conditions?
Explain integrity constraint?
How would you change old and new values in an insert, delete and update triggers?
How to select all columns of all rows from a table in oracle?
