what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 16871 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / anitha
select * from emp where null=null: will not return any rows
in the table since two null values are not always same.
select * from emp where 1=1 : will return all the rows in
the table because 1 is always equal to 1.
| Is This Answer Correct ? | 36 Yes | 1 No |
Post New Answer View All Answers
Please explain oracle data types with examples?
Explain how are indexes update?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the usage of control file in oracle?
How to retrieve data from an explicit cursor?
How to create a stored function in oracle?
What is a cursor in oracle?
What is the oracle implicit cursor?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What are oracle functions?
How to define a variable to match a table column data type?
What is query image?
Explain oracle data types with examples?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is the difference between PFILE and SPFILE in Oracle?
