Hi guys pls any one help me , I am facing this problem since
last one week ,

my question is

in there 1000 rows and 1000 coloums , i want to pick the one
record , how ?



Hi guys pls any one help me , I am facing this problem since last one week , my question is ..

Answer / themba tjnas ngobeni

Hi, If you already know what record to pick then before
recommend what you need to do:

1. do you know how your table structure looks like? I guess
u know but do you have indexes build on your major select
columns?

2. irrespective of how many columns are there if you know
how to describe your table you will know which columns are
of importance to you.

With that I will recommend this:

Write your sql statement similar to:
1. Select *
From My_table
where major_column = :my_value --Primary key view all
columns

2. Select *
From My_table
limit 1 -- without primary key but view all columns

3. Select my_column1,my_column2,my_column3, etc
From My_table
where my_column1 like '%:my_value%' -- without using
primary key
limit 1

you can still write more sql statements to achieve the same
results if you want to be vendor specific like Oracle you
can use limit 1 or rownum =1 etc.

I hope this answers you questions.
Regards

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More WinRunner Interview Questions

is 'tech' is a Reserved word in WinRunner or not?

1 Answers   FCG,


What are command line options?How to invoke winrunner with vb add in using command line options?

1 Answers   BeBo Technologies,


What is parameterizing in winrunner?

5 Answers   FCG, GE,


What r the recording methods in winrunner and wht r the uses and where do we use and how do we use? pls dont mention recording modes(context sensitive and analong)

2 Answers  


What is open STA?Explain in detail.

1 Answers  






what is the syntax for regular expression.dont send the types like regexp_label,regexp_msw_class

1 Answers   QA,


what happens when the script is executed in verify mode

3 Answers  


what is TSL script to connect testdirector through winrunner

2 Answers  


What Is Test policy and what is Test Strategy ? differenciate between them? Explain with examples?

5 Answers   Accenture,


can we write exception handlers (object,tsl,pop-up) programatically then how should we insert this in the script?

2 Answers  


how can we make use of virtual object wizard to identify similar object can u explain with an example

2 Answers  


How to fetch a value which is in a particular cell in a html table?

1 Answers   BeBo Technologies,


Categories