Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Fooling an Oracle application
Hi,
if I understand you correctly you could create a view as follows once you have created the new table. Note that the new able will have to be called somethig different and the view named the same as th original table ( if that makes sense!)
create view original_table_name
as
select '0000'||COLUMN-B||COLUMN-C||COLUMN-D COMPANY-INFO
from new_table_name
/
I hope this helps.
Stuart
Bruce Bristol wrote:
>
> Is there a way I can fool an application with a view in such a way that
> it receives more data than a column contains?
>
> I need to do this, if possible, because I'm removing columns and
> replacing them with new columns on several large tables and I don't want
> to have to modify the
> application after I make changes to each table. I'd rather do it after
> all the tables have been changed.
>
> Example:
>
> COMPANY-INFO CHAR(7)
>
> is really comprised of
>
> COLUMN-A CHAR(3)
> COLUMN-B CHAR(1)
> COLUMN-C CHAR(1)
> COLUMN-D CHAR(1)
> COLUMN-E CHAR(1)
>
> I'm dropping COMPANY-INFO and what would be COLUMN-E, but adding
> COLUMN-B, C and D, so now my 7 bytes of info is replaced by 3 bytes of
> info.
>
> I want the application to see, however,
> "0000"+COLUMN-B+COLUMN-C+COLUMN-D.
>
> Thank you!
>
> -Bruce
Received on Thu Oct 09 1997 - 00:00:00 CDT