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 <*> 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/
