[prev in list] [next in list] [prev in thread] [next in thread] 

List:       suse-oracle
Subject:    RE: [suse-oracle] maybe a pathological problem: sort of echo function in oracle?
From:       "Reidy, Ron" <Ron.Reidy () arraybiopharma ! com>
Date:       2004-06-30 17:21:06
Message-ID: 17CAB0BF27BCFC47B0E4554A0E2F962B2B3C17 () fiji ! arraybp ! com
[Download RAW message or body]

All SQL will be found in V$SQL and V$SQL_TEXT.

--
Ron Reidy
Sr. DBA
Array BioPharma, Inc.


-----Original Message-----
From:	Richard Divis [mailto:richard@widerspruch.at]
Sent:	Wed 6/30/2004 10:56 AM
To:	suse-oracle@suse.com
Cc:	
Subject:	[suse-oracle] maybe a pathological problem: sort of echo function in oracle?
hi,

i know it sounds a bit pathological and has no relation to suse-oracle
other than working on an oracle database on suse linux but maybe someone
can help.

i need a functionality like 'echo' on the shell.

an application generates sql-statements it runs against the database.
we cannot modify these sql-statements in any way.

e.g.:
query1: select col1, col2, col3, col4, col5 from tab1 where col1='string1';
query2: select col1, col2, col3, col4, col5 from tab1 where col1='string2';

these statements should always return
for query1:
  col1     col2  col3  col4  col5
  -------  ----  ----  ----  ----
  string1    0     0     0     0
for query2:
  col1     col2  col3  col4  col5
  -------  ----  ----  ----  ----
  string2    0     0     0     0
regardless of the content of the table (i.e. the table tab1 or to be exact
its content does not exist).

has anyone any ideas?

thanks and kind regards,
richard
-- 

-- 
To unsubscribe, email: suse-oracle-unsubscribe@suse.com
For additional commands, email: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting





This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.


-- 
To unsubscribe, email: suse-oracle-unsubscribe@suse.com
For additional commands, email: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting


[prev in list] [next in list] [prev in thread] [next in thread]