Re: Large number of columns causing - Unknown Error
Hey I transpose the first table. I have
DATE_FIELD | SOMEOBJECTNAME | VALUE_A | VALUE_B | etc..
And I convert it to
DATE_FIELD | SOMEOBJECTNAME_VALUE_A | SOMEOBJECTNAME_VALUE_B | etc...
Thats why I get such a hilarious number of columns.
I use this in order to provide data to a web page containing a grid (ExtJS). I know I shouldnt actually use a database for this but rather a flat file + some coding on the server side but database gives me all the data configurability I need. I have tried diffrent approaches like having a ID | OBJECT NAME | VALUE | DATE_FIELD but this died with a zilion JOIN's thats why I decided having a lame flat table is the way to go.
Subject
Views
Written By
Posted
5644
February 26, 2010 08:29AM
2566
February 28, 2010 01:01PM
Re: Large number of columns causing - Unknown Error
2200
March 01, 2010 06:58AM
2316
March 01, 2010 10:49AM
2186
March 02, 2010 01:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.