what is the output of select * from emp where null=null &
select * from emp where 1=1
- 8 Answers
- 16880 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / raj
Null=Null returns no row but 1=1 returns entire row of the
table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to create a temporary table in oracle?
What are the attributes of cursor?
What is materialized view in Oracle?
Calculate difference between 2 date / times in oracle sql?
Can multiple columns be used in group by in oracle?
How to bring a tablespace offline?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
what is difference between sql plus and sql*plus? (not sql and sql plus).
What are a query and state the different types of queries and their uses?
Name the three major set of files on disk that compose a database in Oracle?
what are bitmap indexes? How does they work?
What is ordinary table in oracle?
how to join query for one source type is oracle another source type is sql server ?
Explain the use of grant option in exp command.
What is partitioned table in Oracle?
