When using Toad to create a view in Oracle, how can I store the formatted script also? -

-

this question may toad specific. have no idea how oracle stores views, i'll explain happens when use toad. if answer oracle specific, better.

i have created rather complex view. make clearer, have formatted code nicely, , entered comments needed. when need make changes view, use toad's "describe objects" window, can find script recreate view. problem formatting gone. comments before select keyword (but after "create view xxx as") disappear.

if enter script create view:

create or replace view testviewformatting -- here have long comment explaining role of  -- view , things aware of if changing it.  -- unfortunately comment disappear... select    name,          --this comment kept   accountnumber  --this   debtable   name 's%';

toad display when describe later:

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 )    select name,                                    --this comment kept                accountnumber                                       --this      debtable     name 's%';

note first comment has disappeared, , format totally different.

i suspect oracle doesn't store code of view, parsed version, , when toad brings script, reverses parsed version , generates script on fly.

what have make toad/oracle keep original formatting?

(ps: know can change settings toad's code formatter, not want do. due questionable choices in past, particular view has several levels of inline views, , need specific formatting make clear happens)

select text user_views view_name = 'your_view_name';

i've tested with:

create view z_v_test  select -- te  --st *  dual;

and keeps blank line.


Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c# - Copy ObservableCollection to another ObservableCollection -

-
how copy observablecollection item observablecollection without reference of first collection? here observablecollection item value changes affecting both collections. code private observablecollection<ratemodel> _allmetalrate = new observablecollection<ratemodel>(); private observablecollection<ratemodel> _metalrateondate = new observablecollection<ratemodel>(); public observablecollection<ratemodel> allmetalrate { { return this._allmetalrate; } set { this._allmetalrate = value; notifypropertychanged("metalrate"); } } public observablecollection<ratemodel> metalrateondate { { return this._metalrateondate; } set { this._metalrateondate = value; notifypropertychanged("metalrateondate"); } } foreach (var item in metalrateondate) allmetalrate.add(item); what causing , how can solve it? you need clone object referenced item before it's a...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more