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
- 19306 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
What is transport network substrate (tns) in oracle?
How to delete a user account in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
Explain what are the characteristics of data files?
List the types of joins used in writing subqueries?
Explain the use of compress option in exp command.
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
How to save query output to a local file?
What is the difference between a hot backup and a cold backup in oracle?
What is the usage of merge statement?
What is sharded cluster?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
Explain oracle insert into command?
How to view existing locks on the database?
How to define a data source name (dsn) in odbc manager?
