what is the output of this query selet * from employee
where 1=2 ??

Answer Posted / rakesh anand

In Oracle Database 10g Express Edition
it shows "no data found"

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is log shipping? : Sql dba

603


Is it possible to sort a column using a column alias?

599


What is coalesce sql?

509


a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

1767


What is Materialized View? In What Scenario we Use Materialized View?

8506






Can procedure in package be overloaded?

604


what are aggregate and scalar functions? : Sql dba

546


Is postgresql a nosql database?

529


what are string data types? : Sql dba

505


Which table is left in join?

511


what is a database? : Sql dba

602


What is composite data type in pl sql?

552


What type of database is cloud sql?

572


What is range partitioning?

512


Explain some predefined exceptions.

580