Re: (Ovid) Re(3): How do you get Perl::DBI to do a desc table

in reply to (Ovid) Re(3): How do you get Perl::DBI to do a desc table_name?
in thread How do you get Perl::DBI to do a desc table_name?

While I am not familiar with the TOP syntax, I bet ROWNUM can be used to do the same. ROWNUM is a the number of a row as it was retrieved from the table (this differs from the display order) -- to limit results to 10 rows, you can use WHERE ROWNUM <= 10. (Please note: this takes place before sorting, so it is no good for getting the "top 10" and such.)

SELECT *
  FROM scott.emp
  WHERE ROWNUM = 1;
[download]

Comment on Re: (Ovid) Re(3): How do you get Perl::DBI to do a desc table_name? Download Code

In Section Seekers of Perl Wisdom