what is the output of the query select * from emp where 1=2
Answer Posted / suresh kumar somayajula
Hi Anfal,
Try the following Query.
SQL> CREATE TABLE EMP_NEW
AS
SELET *
FROM EMP
WHERE 1=2;
Table Created
SQL> SELECT * FROM EMP_NEW
no rows selected.
SQL> DESC EMP_NEW;
Structure will be displayed.
Please correct me if any mistakes.
Thank you,
Suresh
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
What is manual testing and what is it process?
What are the advantages of black box testing?
Which criteria should take in account while doing CMS testing of any project?
functional testing and usability testing test cases for transfer funds...
Do write a separate test case for regression testing? If it is yes, explain how to write the test case?
Diffrernce between client server testing and web server testing.
write 5 critical test cases on product payment form on flipkart.com?
how deployment phase of SDLC differs in product based and in service based company ?
how to write the test cases for mark as read/unread mails for gmail inbox?and what are the testings we will do?
iwant know IEEE formate ,how it is used and exactly where it is used? i have details it follows test plan, testcases...etc. i want real time explanation. pls any one give?
what are the tests u did in entire project? when it did in the project? (means at the release build to end of project) plz explain clearly
what is Test management fundamental?
Work flow in testing in your company?
can u plz give an example for regression testing with example.
What is Stability and Performance Testing in Testing the TV