Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Cobol redefine in SQL

Re[2]: Cobol redefine in SQL

From: Jonathan Gennick <>
Date: Thu, 27 Nov 2003 08:19:26 -0800
Message-ID: <>

Thursday, November 27, 2003, 8:44:25 AM, Stephane Paquette ( 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 * 906.387.1698 *

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit, or send email to and include the word "subscribe" in either the subject or body.


Please see the official ORACLE-L FAQ:

Author: Jonathan Gennick

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (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). Received on Thu Nov 27 2003 - 10:19:26 CST

Original text of this message