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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: column name can't include character '-'

Re: column name can't include character '-'

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 19 Feb 2004 07:57:37 -0500
Message-ID: <dKSdnSQ2pZpgL6ndRVn-sw@comcast.com>

your question is not clear, but it looks like you need to do research on expressions -- take some time reading the Oracle SQL Reference manual, and running some tests

you will find that oracle does not support derived columns in table definitions, but it does in views

;-{ mcs

"x" <x_at_x.hr> wrote in message news:c11pqa$u56$1_at_ls219.htnet.hr...
| IF you had a tale with columns
|
| a number
| b number
| a-b number
|
| what would return
|
| select a-b from x
|
| ?
|
|
Received on Thu Feb 19 2004 - 06:57:37 CST

Original text of this message

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