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
- 19054 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
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
how may join possible between (requisition with purchase order)
What is oracle database client?
How to create an oracle database?
How many types of table in Oracle?
What is oracle update statement with inner join ?
What is varray?
What privilege is needed for a user to connect to oracle server?
How to create a table index in oracle?
What types of joins are used in writing subqueries?
Is the After report trigger fired if the report execution fails ?
What are the different oracle database objects?
How to unlock the sample user account in oracle?
What is a user role in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is the difference between translate and replace?
