Re: It's so difficulty in developing on Developer

This is not a deficiency, it is a feature of the Codd's relational model. Instead of using an array use two tables; one for the common information such as an invoice header, and one for the unique information such as the lines on an invoice.

When I first encountered a true RDBMS I was taken aback by the lack of arrays, but in talking to a former co-worker who knows Dr. Codd I was told that the lack of arrays was to avoid the need to redesign everything when the array repeat count was blown by an exception. Using as an example an electronic health insurance application form how many dependents do you allow for? 6, 12, 18? In a heavily industrialized nation where family sizes average somewhere around 4.5 (I always wanted to meet the half person -- but I digress) you might think that 12 is a safe limit and then design for 18 just to be certain. If you do I guarantee that just after you get to a million insured and are running 7X24 the gentleman in Florida who has adopted nearly 24 children will apply for your insurance.

    If you used an array you will be forced to either redesign and reimplement your system or develop a series of kludge style fixes that will haunt your system for the remainder of its life.

regards

Jerry Gitomer

kynam24_at_my-dejanews.com wrote:

> We are now using Oracle Developer to develop big application,
> in which we have to produce a lot of forms,reports and many
> functions to serve our management purposers .But we can't find
> any features of PL/SQL that support array .Having not array functions
> and supports cause many thing so strange over many popular programming
> language .So ,is there anyone who can show me how to solve this
> problem ?.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
Jerry Gitomer
Computers were made for selling, not for using. They don't give you any grief until you try to use them. Received on Thu Mar 11 1999 - 22:24:21 CST