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

On Jul 5, 2:29 pm, Norbert Winkler <Norbert.Winkl..._at_gmx.de> wrote:
> 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

Views are compiled objects. The * is resolved at runtime, except for view creation where it has always been resolved at compile time. This why Oracle recommends against using * in creating a view. As it has been working in this fashion since Oracle7, the only magical wand probably it
changing the compatible parameter to something 6.0. Obviously you don't want this, as you will loose locally managed tablespaces, enforced constraints etc etc etc.

--
Sybrand Bakker
Senior Oracle DBA