| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is it possible to create Matrix FORMs
Mladen,
Can you expand on your response a little more?
I am just now starting to dig into and trying to learn more about collections and how to apply them in the real world. Prior to 7.3, it was a simple PL/SQL table composed of one column indexed by that good old binary_integer. With 7.3 we finally got the PL/SQL table of records, as well as new commands and such, that made things much easier. With 8, we have PL/SQL tables, nested tables, and varrays, and, we can define nested tables and varrays within a table. I am clear (I think) on the concept of using nested tables and varrays within a table -- very similar to something ADABAS did with it's multi-value fields and repeating groups when I worked with it years ago. For example, we didn't have a separate Salary History table. Salary history was implemented as a repeating group on the Employee "table".
I am not so clear, though, in how you propose using varrays in your response. It's real easy to do a "matrix" when we know, for example, that with SCOTT there are only 4 departments. When the values on both axis are unknown up front, though, we had to end up using DBMS_SQL, SQL to create SQL, etc. I know how to work the problem through those means. So, assuming the values of each axis are unknown up front, how would you do this utilizing the varray?
The other thing that threw me off for a little bit is that the original question was how to represent this data in forms. With Forms 6i, nested tables and varrays within tables are not supported. Something such as an "address" type is; but, collections are not (though we could base the block on a stored procedure using a PL/SQL table).
Anyway, if much of that didn't seem to make sense it is because I am still trying to get my hands around the various object features of Oracle. Much of it seems pretty straightforward; but, until I use such features on a day in day out basis, I will probably continue to have some questions about how to apply such features. Oh well, I will continue to RTM as well as 3rd party books, and, play with the concepts on my test machine.
Regards,
L. Elkins
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Gogala,
Mladen
Sent: Friday, September 15, 2000 3:11 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Is it possible to create Matrix FORMs
Matrix is all around you, just be careful with those pills. Oracle has the "varray" structure which can accomplish what you are trying to do. Create a new type containing the varray structure, name it row_type for example and create a varray with the elements of the row_type type.
-----Original Message-----
Sent: Thursday, September 14, 2000 3:11 PM
To: Multiple recipients of list ORACLE-L
Hi Elkins,
Thanks for your interest.
I'll briefly tell about the application for which I'm looking for such a solution.
This is a Demand allocation application where there is demand for certain products from various regions. This demand is in form of Orders placed on manufacturing unit. Allocation is to be done manually keeping in mind the proper distribution of products to various regions.
Table structures are like this :
region_codes
part_master
oeorder_release
The screen layout which I have in mind is :
region1
region2 region3
region4
Order1 demand allocation Order4 demand
allocation Order7 demand allocation .......
Part_no1 Order2 demand allocation Order5 demand
allocation Order8 demand allocation .......
Order3 demand allocation Order6 demand
allocation Order9 demand allocation .......
Order11 demand allocation Order14 demand
allocation Order17 demand allocation .......
Part_no2 Order12 demand allocation Order15 demand
allocation Order18 demand allocation .......
Order13 demand allocation Order16 demand
allocation Order19 demand allocation .......
Order21 demand allocation Order24 demand
allocation Order27 demand allocation .......
Part_no3 Order22 demand allocation Order25 demand
allocation Order28 demand allocation .......
Order23 demand allocation Order26 demand
allocation Order29 demand allocation .......
and so on...
Then there are totals as well which have to be shown at various levels.
It is as if we are trying to get Excel spreadsheet kind of functionality out of
forms.
Any ideas will be greatly appreciated. I've tried checking metalink but it
did
not help. Looking for ideas from you guys...
TIA, LGE wrote:
> Can you give a little more info on what you mean? Maybe a high level
> description of the tables, some sample data, and a rough diagram of how
you
> expect the data to be presented. I have a couple of ideas of what you
might
> mean; but, I don't want to waste time working up an answer that isn't
> relevant to what you need.
>
> Regards,
>
> L. Elkins
>
> Author: LGE
> INET: elkinsl_at_flash.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Author: prashasta gujrati INET: gujrati_at_tubes.tatasteel.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Author: Gogala, Mladen INET: MGogala_at_oxhp.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Sun Sep 17 2000 - 18:18:41 CDT
 |
 |