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: Reserved names as column names

Re: Reserved names as column names

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 3 Jan 2005 05:36:20 -0800
Message-ID: <1104759379.973918.161600@f14g2000cwb.googlegroups.com> 





Place double quote marks around the column name.  Be sure to use upper
case unless the column name shows as lower case in the view
dba_tab_columns.


select col1, "RESERVED", col3 from ....



HTH -- Mark D Powell --
Received on Mon Jan 03 2005 - 07:36:20 CST












Original text of this message













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