Re: Two Oracle questions
Date: Sat, 21 Jul 2001 21:51:59 GMT
Message-ID: <tif6ljivqoec5e_at_beta-news.demon.nl>
Answers embedded
Hth,
Sybrand Bakker, Oracle DBA
"mlm" <not_at_listed.com> wrote in message news:3B278965.44030FC0_at_listed.com...
> I am using NT 4.0
>
> 1. Is there any way that I can customize the colors of SQL*Plus
> (i.e., change the background to black and the foreground to another
> color). I can do this by changing the colors through NT, but that
> changes the default colors on ALL of my windows on NT. This causes
> Outlook, for example, to have a black background, etc. I just want to
> customize the colors for SQL*Plus..
>
This is not possible.
> 2. I am trying to extract the query that was used to create a
> snapshot by running the following command from SQL*Plus:
>
> select query from dba_snapshots where name = 'SN_ORG_TIERINGS';
>
> ...and I receive the following output:
>
> QUERY
> --------------------------------------------------------------------------
>
> SELECT
> CHILD_FLEX_VALUE_LOW ORG_ID,
> substr(CHILD_FLEX_VALUE_LOW,-4) Last
>
> But that's it!!! I want to see the full text that resides in this
> column. The column is defined as 'LONG', so I believe that it should
> contain the entire SELECT statement. I don't think that SELECT
> statement is that long. I've tried using other tools that we have (SQL
> Navigator) and I still can't see the entire statement.
>
> I've played around with the Envrionment settings in SQL*Plus, but to no
> avail. Am I not checking the correct setting?
No
set long <any high number>
should do it.
>
> Thanks,
> Mike
> --
> The views expressed here are soley mine and do not represent my company
> in any way.
>
>
Received on Sat Jul 21 2001 - 23:51:59 CEST