what is the output of select * from emp where null=null &
select * from emp where 1=1
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
How to connect to oracle using service name instead of sid?
How to change program global area (pga) in oracle?
What are advantages of dateset in datastage?
How to call a stored function with parameters?
How to establish administrator authentication to the server?
Why does oracle 9i treat an empty string as null?
How will you differentiate between varchar & varchar2?
What is the order of defining local variables and sub procedures/functions?
What are the limitations oracle database 10g xe?
How can I create database in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How do you find current date and time in oracle?
What is an oracle recycle bin?
What are the types of trigger in oracle?
Why oracle is used?