Answer Posted / mithun

hi everyone ,
its a trick to copy the structure of the table wthout the
data .
1 SQL> create table employee1
2 as select * from emp
3 where 1=2;

the compiler will look for the statment 2 first
then it will come to the 3 line to check the condition ,when
it gets a 0 [means false] at that time only the table
structure was there in the buffer ; now it will return to
the 1st statement to create a table with the structure only .
so it will return only the structure of the table .
similarly when this
SELET *
FROM EMP
WHERE 1=2;
querry is executed as per the false conditon it will only
show no rows selected .
hope you get the answer .
have a nice time for any more assistance you can mail me to
ermithun.c@gmail.com

How to integrate Bugzilla with QTP?

2837

---

.In languages testing, what is the fixed part and changing part?

2151

---

What are the advantages of black box testing?

1086

---

Hi All. How can we write negative test cases for Logout Operation ? Please place the answer with a few details and if possible add some related object properties. "A tester exposes his/her ability not only by words he/she also proof it by work"

2985

---

Hi friends Does anyone have screen shot of POWERMHS and please can anyone post anything which will be helpful to understand POWERMHS. thanks.

3060

---

What is the difference between GUI Testing,UI testing and Usability TEsting

2481

---

How quickly we need to fix the bug? Or how soon the bug should get fixed?

1157

---

I have to give weights to 5 stones so that using a simple balance and the stone i should be able to weight any number between 1-100

2303

---

Can anyone tell me about banking project? abt the transactions? the flow?

1969

---

Hi I am searching job please send some details abuot ERP project and real time test plan,traceability report,test case if any relate to erp project Please help me out to get a job in testing.my email address is chiku_69@yahoo.in Thank u

2810

---

what is localization and globalization.and what are the ways way are going to test the particular application?how can we identify factual, visual, corrupted characters, link errors, formatting errors, etc in locallization?iam going to attend the interview on localization concepts and languages like : German, Japanese, French, Russian, Italian, Chinese, Korean, Portuguese and Spanish .tell me the process how to do testing above concepts let me know its urgent:anilaluvala@gmail.com 9908814046

2077

---

What processes/methodologies are you familiar with?

2385

---

Beyond the customary advantages of having a testing group, what are the benefits does a company receive from a well run, automated testing group?

3428

---

What about the test case if the field only takes a certain number of characters or a minimum number?

1196

---

Usually customers won’t give all the requirements. How will you manage & collect all the necessary information?

1216

---