Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Substitution of column names

Re: Substitution of column names

From: Ansgar Seiter <seiter_at_phya5.physik.uni-freiburg.de>
Date: 1997/02/17
Message-ID: <33088C57.41C6@phya5.physik.uni-freiburg.de>#1/1

Dear Maureen,

I know, people who post a question want an answer to it rather than being fed some pedagogical input. So let me put it as a question : Is there a strong reason for using this peculiar table structure ? Life could be perhaps easier if your table would look like this :

        FUND
        ORGN
        ACCT
        TOTAL
        MONTH

with Month ranging from 1-12.
Now your select would look like :
        SELECT FUND, ORGN, ACCT, TOTAL
         FROM MYTABLE
        WHERE MONTH = nn;

Sorry,

-- 
 Ansgar Seiter          	 Group Prof. Ch. Schlier      
 Department of Physics  	                             
 University of Freiburg 	 Phone:  +49 761 203-5730      
 Hermann-Herder-Str. 3  	 FAX:    +49 761 203-5873            
 D-79104 Freiburg i.Br  	 E-Mail: seiter_at_phya3.physik.uni-freiburg.de 
 Germany
Received on Mon Feb 17 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US