what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 16833 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / bhavish
1.statament "no rows select"
2.statament "the 14 rows displayed
why because the true condition and null values are different
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe varray?
How to write numeric literals in oracle?
What are the uses of synonyms?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Is oracle a language?
What is the quickest way to export a table to a flat file?
Is a rollback possible to any savepoint?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is ordinary table in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is a connect identifier?
What is backup in Oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is the sid in oracle?
