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
- 18956 Views
- IMS Health, NIIT, I also Faced
- E-Mail Answers
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 functional dependency and its relation with table design?
How to define a variable of a specific record type?
What is difference between truncate and delete?
How to drop a stored procedure in oracle?
What is a server parameter file in oracle?
How will you identify oracle database software release?
How to run create database statement again?
How to create an initialization parameter file?
What is the use of oracle?
Can a formula column referred to columns in higher group ?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What are the different types of trigger and explain its various uses and functions?
Explain overloading. Can functions be overloaded?
Is there a function to split a string in plsql?
Is primary key indexed by default in oracle?
