Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: want to know the reason for varchar2(4000) limit

Re: want to know the reason for varchar2(4000) limit

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 3 Oct 2003 13:46:13 -0700
Message-ID: <1a75df45.0310031246.695e4a82@posting.google.com>


"Richard Foote" <richard.foote_at_bigpond.com> wrote

> Although some may argue a larger varchar2 field would give more options and
> flexibility, I disagree and suggest learning to "love" LOBs ;)

Okay. I will try to love my LOBs. Er.. do I need some kind of protection or what.. does having a large tablespace make you score better..? ;-)

You get weird people. And nah, I'm not refering to myself in particular.

Many years ago I knew this guy who.. well, cannot call him a computer nerd as that was before the days of nerd and pocket protectors. He kind of reminded me of those IBM engineers they that were never allowed the customer to see.

Once he demo'ed a new system he wrote to me. He deleted a beacon (a legal surveying point) from the database. The live database. He did though took great care in writing down the beacon's details and coordinates on stickme note and stuck it to the terminal.. could not recall if he did add it back into the database.

Anyway, he often worked late. In the morning you will find him curled up against the FEP with a blanket. (for you young guys, FEP is a Front End Processor for a mainframe :-)

Yeah... there's all kinds and levels of "loving" when it comes to computers, FEPs and LOBs.. ;-)

--
Billy
Received on Fri Oct 03 2003 - 15:46:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US