Problem with a view

From: Ben-oui <aslamette_at_free.fr>
Date: Mon, 10 Sep 2001 09:30:40 GMT
Message-ID: <4L%m7.1697$tP.2105373@nnrp5.proxad.net>

I create a view by :

CREATE OR REPLACE VIEW VIEWCOLONNES
  (nomtable,
   nomcolonne,
   typedonnees,
   nullable,
   taille,
   precisionchamp,
   scale,
   commentaire)

AS SELECT

  b.table_name,
  b.column_name,
  b.data_type,
  b.nullable,
  b.data_length,
  b.data_precision,
  b.data_scale,
  c.comments

  FROM
    sys.all_tab_columns b,
    sys.all_col_comments c

  WHERE
       (b.table_name like 'PREFIXE%'
    AND b.column_name = c.column_name)

ORDER BY b.table_name

When I execute the view, Oracle returns a column is displayed several time and I don't understand why ?

And, it returns the VIEWCOLONNES columns in this query ! Why ? Received on Mon Sep 10 2001 - 04:30:40 CDT