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
- 19529 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
Answer Posted / chandana
NULL = NULL ...NOT TRUE
NO ROWS RETURNED
1=1 ...TRUE
ALL ROWS RETURNED
1=2....NOT TRUE
NO ROWS RETURNED
2=2,3==3 AND SO ON WILL RETURN ALL ROWS FROM A TABLE
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
State all possible different index configurations a table can possibly have?
What are the varoius components of physical database structure of oracle database?
How to recover a dropped table in oracle?
What to do if the binary spfile is wrong for the default instance?
How to convert characters to numbers in oracle?
How to run queries on external tables?
How many memory layers are in the oracle shared pool?
What is logical backup in oracle?
What is a data dictionary and how can it be created?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is the difference between alert log file and tarce file ?
Can we use bind variables in oracle stored procedure?
How to insert a new row into a table in oracle?
Can we create database in oracle using command line ?
