what is the output of the query select * from emp where 1=2
- 10 Answers
- 39625 Views
- TCS, I also Faced
- E-Mail Answers
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 are the possible test scenarios around AVS check of any credit card? (Testing through payment gateway online) (What are the fields we should check while checking AVS and CVV)
What are the factors affecting a manual testing project and what are the ways to overcome it?
what is e-tester?
1. what is a date guidelines ?
what is the technical challange you faced in your module.please ans me the question i just want example can me any example please very important
What do you mean by Unit Testing, Integration Testing, System Testing, and User Acceptance Testing and when do you do them?
In what situation would you want to parameterize a text verification check?
functional testing test cases for transfer funds ?
How much the bug is affecting the functionality of the application?
Can any one say me how to do Performance testing step by step plz for a desktop application(offline application).all the data is stored in internal server itself can any plz help me. ts quite urgent friends.
When to stop testing? (Or) how do you decide when you have tested enough?
How do you test google or gmail application??tell me step by step process??
Hi i am looking for Test Engineer Job, i have done the course, but i don't have work experience on it, Is it So important to have real time Exp or knowledge is enough? and please let me know like how i can improve for the interview. You can send me a mail on this id: rashmi_vastred@yahoo.co.in
I need your help, actually am facing lots of problem in interview am not able to answer in right way what ever questions asked about project. Could you please answer few questions? You must have seen the project I have mention as current project so please help on this, tell me how to explain project in details am prepare on HR module but don’t know how to explain it properly. If you can send me few documents like SRS, and few test case that will help me to get the clear picture, and want ask u what is tier1, tier2, and tier3 in project.
is it not possible to automate full project??what r the parts in project that cant be automated(tht has to be done manually)?
