Re: FULL JOIN oracle bug!

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 08 Nov 2005 05:41:02 -0800
Message-ID: <1131457266.237720@yasure>

Stoyan wrote:
> Hello all,
> Here is an example of a SQL query that doesn't work under ORACLE and
> it should work. The ORACLE version may be is 10g (I should ask our DB
> administrator)
>
> First create that view:
> --it is OK, it works fine
> CREATE OR REPLACE VIEW simple_view AS
> (
> SELECT
> 'frist_column' as first_column,
> 'second_column' as second_column
> FROM
> (
> SELECT
> dual.*
> FROM
> dual
> )
> )

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 8 05:38:04 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Oracle Label Security, OLAP and Data Mining options

SQL> CREATE OR REPLACE VIEW simple_view AS

   2 (
   3 SELECT

   4      'frist_column' as first_column,
   5      'second_column' as second_column

   6 FROM
   7 (

   8      SELECT
   9       dual.*
  10      FROM
  11       dual

  12 )
  13 );

View created.

SQL> select * from simple_view;

FIRST_COLUMN SECOND_COLUMN
------------ -------------
frist_column second_column

SQL> It does seem you should have asked!

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Nov 08 2005 - 07:41:02 CST