Databases
StackOverflow2013
Postsdbo
POWhen using Toad to create a view in Oracle, how can I store the formatted script also?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhen using Toad to create a view in Oracle, how can I store the formatted script also?
    primarykey
    data
    text
    <p>This question may be Toad specific. I have no idea how Oracle stores views, so I'll explain what happens when I use Toad. If I get an answer that is Oracle specific, so much the better. </p> <p>I have created a rather complex view. To make it clearer, I have formatted the code nicely, and entered some comments where needed. When I need to make changes to the view, I use Toad's "describe objects" window, where I can find a script to recreate the view. The only problem is that all my formatting is gone. Comments before the select keyword (but after "create view xxx as") will also disappear. </p> <p>If I enter this script to create a view:</p> <pre><code>create or replace view TestViewFormatting as -- Here I have a long comment explaining the role of the -- view and certain things to be aware of if changing it. -- Unfortunately this comment will disappear... select name, --This comment will be kept accountnumber --This also from debtable where name like 'S%'; </code></pre> <p>Toad will display this when I describe it later:</p> <pre><code>DROP VIEW XXX.TESTVIEWFORMATTING; /* Formatted on 04.07.2012 09:35:45 (QP5 v5.185.11230.41888) */ CREATE OR REPLACE FORCE VIEW XXX.TESTVIEWFORMATTING ( NAME, ACCOUNTNUMBER ) AS select name, --This comment will be kept accountnumber --This also from debtable where name like 'S%'; </code></pre> <p>Note that the first comment has disappeared, and that the format is totally different.</p> <p>I suspect that Oracle doesn't store the code of the view, just some parsed version, and when Toad brings up the script, it reverses this parsed version and generates a script on the fly. </p> <p>What will I have to do to make Toad/Oracle keep the original formatting? </p> <p>(PS: I know I can change the settings for Toad's code formatter, but this is not what I want to do. Due to some questionable choices in my past, this particular view has several levels of inline views, and I need a very specific formatting to make it clear what happens)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSvein Bringsli
    1. USSvein Bringsli
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhen using Toad to create a view in Oracle, how can I store the formatted script also?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COAs far as I can tell Oracle removes any comment before the actual select. So you won't be able to preserve that. The rest of the source is retained as sent by the SQL client. I don't know TOAD though, so I have no idea how you can configure it to display the original code
      singulars
      1. POWhen using Toad to create a view in Oracle, how can I store the formatted script also?
      1. USa_horse_with_no_name
    2. COput the comment exactly after `SELECT` keyword :).
      singulars
      1. POWhen using Toad to create a view in Oracle, how can I store the formatted script also?
      1. USFlorin Ghita
    3. CO@Florin: Yes, that's what I do now, but that's easy to fix. The real problem is the formatting.
      singulars
      1. POWhen using Toad to create a view in Oracle, how can I store the formatted script also?
      1. USSvein Bringsli
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload