--- Mike Franks <[EMAIL PROTECTED]> wrote:
> select * from ( > select last_name, first_name > from emp_table > order by last_name, first_name) > where rownum <= 10; Hi Mike, thanks for the info re: CLOB. I'm a little surprised our DB admin didn't suggest that when I asked him about a workaround. But the joke's on him: now he has to go back and convert a few text fields to CLOBs.... Muhahahaa! As for the SELECT example above, that's pretty much exactly what I'm using in cases where I need to limit the results. 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 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/
