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
what are the advantages of running a database in archive log mode?
What is the difference between PFILE and SPFILE in Oracle?
What is a procedure in oracle?
Can we use bind variables in oracle stored procedure?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is oracle sid?
How many categories of data types?
Explain oracle insert into command?
What is dynamic proxy?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to experiment a data lock in oracle?
How to insert a new row into a table in oracle?
Which environment variables are absolutely critical in order to run the OUI?
Explain the different normalization forms?