Re: Fooling an Oracle application

From: Roger Snowden <rsnowden_at_supergeek.com>
Date: 1997/10/08
Message-ID: <01bcd420$a87345a0$096fc589@RSNOWDEN.labinterlink.com>#1/1

If I understand you, you want to fill in some 'dummy' columns with the view? Just use dummy constants in your select statement...

SQLWKS> create table sometable (

	alpha varchar2(1), 
	beta varchar2(1)
	);

Statement processed.
SQLWKS> insert into sometable values ('a', 'b'); 1 row processed.
SQLWKS> insert into sometable values ('a', 'b'); 1 row processed.
SQLWKS> insert into sometable values ('a', 'b'); 1 row processed.
SQLWKS> insert into sometable values ('a', 'b'); 1 row processed.
SQLWKS> insert into sometable values ('a', 'b'); 1 row processed.
SQLWKS> insert into sometable values ('a', 'b'); 1 row processed.
SQLWKS> select * from sometable;
A B
- -
a b
a b
a b
a b
a b
a b
6 rows selected.

SQLWKS> select alpha, beta, 'dummy' from sometable; A B 'DUMM
- - -----
a b dummy
a b dummy
a b dummy
a b dummy
a b dummy
a b dummy
6 rows selected.

And then, to this...

SQLWKS> select 'dummy' || alpha || beta from sometable; 'DUMMY'

---

dummyab
dummyab
dummyab
dummyab
dummyab
dummyab
6 rows selected.

This works pretty well

Roger Snowden

> 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.
Received on Wed Oct 08 1997 - 00:00:00 CDT