Re: displaying a view correctly.
From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 01 Oct 2003 10:43:09 +0200
Message-ID: <hp4lnvg7fi9pqbaojjdcohoptms73fqa1k_at_4ax.com>
Date: Wed, 01 Oct 2003 10:43:09 +0200
Message-ID: <hp4lnvg7fi9pqbaojjdcohoptms73fqa1k_at_4ax.com>
On 1 Oct 2003 01:03:13 -0700, rmoleveld_at_hotmail.com (Ronald) wrote:
>Hi there,
>
>Is there any way to display a view on a proper way ?
>If you do a select text from ???_view you get the select statement is
>one line and need to cut it in pieces (in word or notepad) if you want
>to have it 'readable'.
>SQL Navigator and Toad are displaying Views on the same way.
>
>Is there any way I don't need to do this ?
>
>Thanks,
>
>Ronald.
In sql*plus, as the view text is in a long column
set long <any arbritary high number>
prior to selecting.
Other than that if you have 9i, use the dbms_metadata.get_dll
procedure
I'm not aware Toad is having problems formatting views
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Oct 01 2003 - 10:43:09 CEST