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