Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answer Posted / anee desai

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;.if 2=2 will also provide the same
result.it makes no sense in writing 1=1;

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I know if oracle is installed on windows?

908


What is oracle sid?

939


How would you go about verifying the network name that the local_listener is currently using?

2027


if you ctreate table identity

2353


What is a data lock in oracle?

1080


How to use null as conditions in oracle?

1055


How to estimate disk space needed for an export job?

1032


Explain mutating triggers.

1010


How to enter a new row into a table interactively?

993


What are the logical operations?

1102


What is literal?

987


how the indexes are stored in the Oracle Database?

2257


How to do paging with oracle?

983


How do I limit the number of oracle database connections generated by weblogic server?

1052


What is procedure overloading in oracle?

1032