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 -> select constant.field

select constant.field

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Tue, 24 Jan 2006 12:36:50 +0200
Message-ID: <43d60342$0$10073$ba624cd0@newsread.funet.fi>


Why can I make following query

select 1.foobar from dual

Result is 1.0 (Oracle 10g1 EE, 32 bit Linux)

So why can I use number as a table name (or actually table alias) and why that "table" can have what ever field?

When I tried

select 1."foo bar" from dual

I get 1 as result.

--
Arto Viitanen, CSC Ltd
Espoo, Finland
Received on Tue Jan 24 2006 - 04:36:50 CST

Original text of this message

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