Re: v$sqltext

From: Colin Polykett <polyketc_at_bibip1.spam.wgw.bt.co.uk>
Date: 1997/02/12
Message-ID: <330183BD.1E0A@bibip1.spam.wgw.bt.co.uk>#1/1

Colin Polykett wrote:
>
>
> From SYS try doing :
>
> create or replace view v_$instance as select * from v$instance;
> create public synonym v$instance for v_$instance;
>

I did, of course, mean for you to use 'sqltext' instead of 'instance' in my last message. I'm sure you got the idea though.....

---

The opinions expressed above have probably been pinched from somewhere else as I have none of my own.

Colin Polykett polyketc_at_bibip1.wgw.bt.co.uk CSO Open Systems ORACLE DBA Received on Wed Feb 12 1997 - 00:00:00 CST