What will be the output for the below Query
Select 'High' from dual where null = null;
- 12 Answers
- 28652 Views
- Infosys, Satyam, I also Faced
- E-Mail Answers
Answer Posted / vijay repe
Query will give o/p as 'High' if condition u put as null is
null insteat of null = null.
It considers as false where condition same as 1=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of stored procedure?
what is the command used to fetch first 5 characters of the string? : Sql dba
what is a control file ? : Sql dba
Explain the working of foreign key?
what is the syntax used for partition in tsql? : Transact sql
What are joins in sql?
what is the difference between a web-garden and a web-farm? : Sql dba
How to get help at the sql prompt?
Explain what is a column in a table?
Are sql database names case sensitive?
what are the different functions in sorting an array? : Sql dba
What is difference between pls_integer and integer?
Do we need to rebuild index after truncate?
how to create a new table in mysql? : Sql dba
Is left join faster than inner join?
