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
Name three reasons why the tester may choose to record in Context Sensitive mode.
In cycle 1 we have 100 test cases out of which 95 test cases are PASS and 5 test cases are FAIL. So in cycle 2 how many test cases performed as a part of regression testing?
What is neutral test case?
Describe Testing Decomposition?
hi, I m looking for a career in manual web testing. so PLZ anybody who have the practical knowledge of dis field help me. GIVE ME UR MAIL ID so that i can ask regarding some doubts. my MAIL ID is ankurtester819@gmail.com
What is bug severity?
i want to for technical interview question paper along with in tesrviwe Phases i need
Information about Automated Software Installer
What are bug leakage and bug release?
What is localization testing (l10n testing)?
value momentum
I studied MBA, I want learn any softwarecourse, which course is better hadoop or testing tools(manual+selenium?)
How should validation activities be handled?
What is Catapult Testing in E-Learning Domain?
What do you mean by Unit Testing, Integration Testing, System Testing, and User Acceptance Testing and when do you do them?