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 ?
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 |
is 'tech' is a Reserved word in WinRunner or not?
What are command line options?How to invoke winrunner with vb add in using command line options?
What is parameterizing in winrunner?
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)
What is open STA?Explain in detail.
what is the syntax for regular expression.dont send the types like regexp_label,regexp_msw_class
what happens when the script is executed in verify mode
what is TSL script to connect testdirector through winrunner
What Is Test policy and what is Test Strategy ? differenciate between them? Explain with examples?
can we write exception handlers (object,tsl,pop-up) programatically then how should we insert this in the script?
how can we make use of virtual object wizard to identify similar object can u explain with an example
How to fetch a value which is in a particular cell in a html table?