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

Home -> Community -> Usenet -> c.d.o.server -> hardcoded columns

hardcoded columns

From: Nick G. Anagnos <anagnon_at_westat.com>
Date: 2000/05/12
Message-ID: <391C6FFE.895B82D0@westat.com>#1/1

I have a table with different date columns, ex: c2000_02, c2000_03, ... I have a program that has the columns hardcoded depending on which column to update, ex: update table set c2000_02 = "xoxoxo" Instead of hardcoding the column in the update statement, I'd like to have the c2000_02 as a variable so the statement would look like:

     update table set variable = "xoxoxo"

Nick Received on Fri May 12 2000 - 00:00:00 CDT

Original text of this message

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