yeah rownum is a pseudo column in oracle database tables and I guess in your case this is not a standard db table it might be a custom table and rownum is not defined for it.ROWNUM is basically used to limit the number of rows returned by a query, so you can use something other than rownum in the where clause to limit the no of rows returned by the query.
On Sun, Dec 6, 2009 at 5:14 AM, <[email protected]> wrote: > That's how you get certain # of rows from oracle like select top 10 * from > <Table_Name> in sqlserver to get the 1st 10 records... > > > On Sat, Dec 5, 2009 at 11:47 AM, Parke Kuntz <[email protected]>wrote: > >> One of those dumb questions, is "rownum" one of the field names in your >> Oracle db? >> >> >>> -- >>> You received this message because you are subscribed to the Google >>> "QTP - HP Quick Test Professional - Automated Software Testing" >>> group. >>> To post to this group, send email to [email protected] >>> To unsubscribe from this group, send email to >>> [email protected]<mercuryqtp%[email protected]> >>> For more options, visit this group at >>> http://groups.google.com/group/MercuryQTP?hl=en >>> >> >> >> -- >> You received this message because you are subscribed to the Google >> "QTP - HP Quick Test Professional - Automated Software Testing" >> group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected]<mercuryqtp%[email protected]> >> For more options, visit this group at >> http://groups.google.com/group/MercuryQTP?hl=en >> > > -- > You received this message because you are subscribed to the Google > "QTP - HP Quick Test Professional - Automated Software Testing" > group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<mercuryqtp%[email protected]> > For more options, visit this group at > http://groups.google.com/group/MercuryQTP?hl=en > -- regd, mrinal -- You received this message because you are subscribed to the Google "QTP - HP Quick Test Professional - Automated Software Testing" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/MercuryQTP?hl=en
