Interested to Buy Any Domain ? << Click Here >> for more details...
what is the output of this query selet * from employee
where 1=2 ??
- 11 Answers
- 18574 Views
- I also Faced
- E-Mail Answers
Answer Posted / selvaraj v, anna university
In Oracle 10g :
---------------
no rows selected.
E.g:
----
SQL> SELECT * FROM job;
EMPNO JOBTITLE
--------- --------------------
1 Tester
2 Accountant
3 Developer
4 COder
5 Director
6 Mediator
7 Proffessor
8 Programmer
9 Developer
9 rows selected.
SQL> SELECT * FROM job WHERE 1=2;
no rows selected.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
Can we use delete in merge statement?
What are pl sql data types?
What information is needed to connect sql*plus an oracle server?
what are wild cards used in database for pattern matching ? : Sql dba
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is scope of pl sql developer in future?
What is the starting oracle error number?
What is field delimiter?
Explain the difference in execution of triggers and stored procedures?
What are joins in sql?
Explain dml and ddl?
how to show all tables with 'mysql'? : Sql dba
What is column?
What is sqlite format?
Why do we use sql constraints?
