Thursday, November 27, 2003, 8:44:25 AM, Stephane Paquette ([EMAIL PROTECTED]) wrote: SP> I'm looking for a solution that is using only one table not multiple tables. SP> In fact a dynamic column redefinition feature (cobol redefines) is what I need in Oracle SQL.
Much as I like REDEFINES in COBOL, I'm not convinced that it's conducive to relational data. What language are your programmers using to process the data? If you need to issue SELECTs against your data, I'd look at putting together a set of views, perhaps involving CASE statements, to sort things out. Given your table with its 50-character field, you could create one view to return records of one type, another view to return records of another type, etc. However, I'd really think hard about taking a different approach. It makes more sense to me to create separate tables for each of those record types. SQL is not COBOL. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word "subscribe" in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
