what is the output of select * from emp where null=null &
select * from emp where 1=1
Answer Posted / shree
first command will give no records whereas 2nd command will
provide all records as 1 is equal to one.it is similar to
select * from emp;.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain about achiever in sql?
How to define an anonymous procedure with variables?
How to recover a dropped table in oracle?
What is a static data dictionary in oracle?
How to drop an index in oracle?
What is an oracle database?
Explain the use of inctype option in exp command.
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to download oracle database 10g xe?
How to run the anonymous block again?
How to get a create statement for an existing table?
How view is different from a table?
How do I reset a sequence in oracle?
What is logical backup in oracle?
What is the difference between primary key and unique key and foreign key in oracle?