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 -> select * from dual in MOUNTED database returns 4 columns (one row)

select * from dual in MOUNTED database returns 4 columns (one row)

From: Vsevolod Afanassiev <vafanassiev_at_aapt.com.au>
Date: 8 Jul 2002 23:14:49 -0700
Message-ID: <4f7d504c.0207082214.506816ea@posting.google.com> 





If a database is mounted (not opened), then 



select * from dual



returns 4 columns (one row).


However, when the database is opened, 



select * from dual



returns one column only.



I checked DBA_OBJECTS - there are only two objects with name DUAL,
both in SYS schema, table and synonym.



Thanks,


Sev
Received on Tue Jul 09 2002 - 01:14:49 CDT












Original text of this message













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