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 -> create view d.* becomes d."FIELD1", d."FIELD2"

create view d.* becomes d."FIELD1", d."FIELD2"

From: Norbert Winkler <Norbert.Winkler1_at_gmx.de>
Date: Thu, 5 Jul 2007 14:29:49 +0200
Message-ID: <1rtpyykimgnr5.1fyhdorftl2la.dlg@40tude.net>


Hi,

we've changed to 10i.

Since that time the view creation has been changed.

Assume a table
Create Table xtab (
  field1 NUMBER,
  field2 VARCHAR2(15)
)
/

and

CREATE OR REPLACE VIEW v_xtab AS
SELECT d.*
FROM DEGR.XTAB d
/

Before 10i engineering-tools give me

CREATE OR REPLACE VIEW v_xtab AS
SELECT d.*
FROM DEGR.XTAB d
/

or

CREATE OR REPLACE VIEW v_xtab (
  field1,
  field2
) AS
SELECT d.*
FROM DEGR.XTAB d
/
  

now I get

CREATE OR REPLACE VIEW v_xtab (
  field1,
  field2
) AS
SELECT d."FIELD1",d."FIELD2"
FROM DEGR.XTAB d
/

or

CREATE OR REPLACE VIEW V_XTAB AS
SELECT d."FIELD1",d."FIELD2"
FROM DEGR.XTAB d
/

Because the engineering-tools makes it easy to create DDL-scripts for future use I w'd like to have the old state without the ?."????"-items.

Is there a options setting to enforce the old state?

-- 
Thanks
Norbert
Received on Thu Jul 05 2007 - 07:29:49 CDT

Original text of this message

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