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
Hi friends, currently i am working with banking domain project in the part of testing..what kind of questions will be ask at interviews.. can anybody listout the project oriented questions which are asked in interviews...
How does your preferred work style work with the ideal test-manager role that you just described? What is different between the way you work and the role you described?
how to test the case with 5 combination and inputs
You want a automation tool to be used for your project. How will you convince the client for the same. Please give me specific answer.
Can you explain the elementary process?
What is data matrix? What is the use of it?
How do you go about testing a project?
In Manual testing how to test proxy servers? can u please explain with example?
What exactly you do as a Configuration controller?
What are the different levels of manual testing?
What is the difference between a defect and a failure?
Why did you choose the Software Testing Field?
How does compatibility testing differ while testing in Internet explorer and testing in Firefox?
What are the various test case for google analytics, api keys , pay pal if you know please post me a answer. And how we will test
Relative to other technical groups in the company? Relative to your staff?