I should clarify... when using rownum <= desired_max_number_of_rows in Oracle, you will get the first xx rows that meet your other where clause criteria, in primary key order. That is, you cannot force a sort order in a simple query.
For reference: http://www.devx.com/tips/Tip/14251 If you wanted to pull 10 employee's names from a table, sorted by last_name, first_name, but the emp_table had a primary key on the employee_number column, you could write: select * from ( select last_name, first_name from emp_table order by last_name, first_name) where rownum <= 10; Mike On 1/12/2006, "Mike Franks" <[EMAIL PROTECTED]> wrote: > > > > >Bob - An Oracle CLOB (Character Large Object) column can contain up to >4GB. Long Raw can also contain large text data, but is deprecated in >Oracle 9 and has other problems that may cause DBAs to hate you. > >To emulate LIMIT 10, try: where rownum <= 10 > >hth, >Mike > >On 1/12/2006, "Bob Sawyer" <[EMAIL PROTECTED]> wrote: > >> >> >> >> >>For those of you who work with PHP and Oracle, have any of you figured >>out a way to get around Oracle's 4000-character text field limit? Our >>corporate IT folks refuse to even entertain the idea of using MySQL - >>I've asked and asked - so I'm stuck with Oracle and it's limitations. >>Amazing that something as powerful as the Big O doesn't have a LIMIT >>statement! (although I've worked that one out with a nested SELECT... >>stupid Oracle....) >> >>Anyway ... tips and thoughts greatly appreciated. >> >>Cheers, >>-Bob >> >>__________________________________________________ >>Do You Yahoo!? >>Tired of spam? Yahoo! Mail has the best spam protection around >>http://mail.yahoo.com >> >> >> >> >> >> >> >>Community email addresses: >> Post message: [email protected] >> Subscribe: [EMAIL PROTECTED] >> Unsubscribe: [EMAIL PROTECTED] >> List owner: [EMAIL PROTECTED] >> >>Shortcut URL to this page: >> http://groups.yahoo.com/group/php-list >> >> >> >> >> >> >> >> >> >> >> SPONSORED LINKS >> >> >> >> >> Php mysql >> >> >> Job postings >> >> >> >> >> >> >> >> >> >> >> >> >> >> YAHOO! GROUPS LINKS >> >> >> >> Visit your group "php-list" on the web. >> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] >> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. >> >> >> >> >> >> >> >> >> >> >> >> >> > > > > > > > >Community email addresses: > Post message: [email protected] > Subscribe: [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > List owner: [EMAIL PROTECTED] > >Shortcut URL to this page: > http://groups.yahoo.com/group/php-list > > > > > > > > > > > > > YAHOO! GROUPS LINKS > > > > Visit your group "php-list" on the web. > To unsubscribe from this group, send an email to: [EMAIL PROTECTED] > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > > > > > > > > > > Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
