sql - How to pipeline a function with a dynamic name of columns? -



sql - How to pipeline a function with a dynamic name of columns? -

i need create study retrieve expenses lastly 12 months. depends on day execute study name of columns of study alter (for illustration if execute study in jul, should retrieve twelve columns expenses in jun, may, apr, march. name of columns lastly 12 months).

the next pl/sql code creates view dinamic name columns depending on sysdate.

declare vsql varchar2(4000); begin vsql := 'create or replace view ifsapp.rldatetest select ip.part_no, ifsapp.rd_purch_demand_qty_issue_api.get_avr_usage_per_month(ip.contract,ip.part_no ,to_char(sysdate, ''mm'')-1) ' || **substr(add_months(sysdate, -1),4,3)** || ', ifsapp.rd_purch_demand_qty_issue_api.get_avr_usage_per_month(ip.contract,ip.part_no ,to_char(sysdate, ''mm'')-2) ' || **substr(add_months(sysdate, -2),4,3)** || ' ifsapp.inventory_part ip ip.contract = ''s03'' '; execute immediate vsql; end;

(|| substr(add_months(sysdate, -1),4,3) || alias of each colum)

the point 1 time execute report, should create view , show rows. had thought of using pipelined (to create type table consisting of result of view , allow me select * table(getview())) in report.

my problem name of columns of view not same can't create type table using pipelined.

any thought how or other solution allow me utilize view in select statment?

many thanks.

either have misunderstood requirements or design nonsense. it's rare situation have dynamically ddl. have create dynamically view suspicious.

however didn't name columns in select part implicit names , may makes tham "dynamic". when create look in select statements, name them:

create or replace view v1 select + b a_plus_b table t;

have no thought pipelining has @ all.

sql oracle plsql

Comments

Post a Comment

Popular posts from this blog

iphone - Dismissing a UIAlertView -

iphone - Dismissing a UIAlertView - i set in app purchase app, , when user taps button, purchase started. basically, tap button, , depending on speed on net connection, waiting 10 seconds until new alert view comes asking if purchase product. user tap button multiple times since nil came up, , multiple purchase alert views come up. additionally, maybe seen user app bug. in end, problem. i want alert view come spinning wheel says "loading..." when users taps purchase button. problem is, how dismiss when new alert view comes asking user if want purchase product? if ([uialertview alloc] says: @"whatever apple's alert view says") { //dismiss "loading..." alert view here } i uncertainty work, input appreciated. thanks! you need have access alertview. can this. create alertview instance var in app delegate , when want show loading initialize instance var assign property , when want dismiss phone call [alertviewinstance d...
Read more

c# - Can ProtoBuf-Net deserialize to a flat class? -

c# - Can ProtoBuf-Net deserialize to a flat class? - protobuf-net uses nested protobuf constructs back upwards inheritance. however, can made force properties flat target class has same properties inherited "serialized" version? see test illustration below. needless result of flat namespace null both properties. possible solution: re-create info flat.b first on property property basis. note: not prefered option. using system; namespace hierarchy { using protobuf; [protocontract] public class { [protomember(1)] public string prop1 { get; set; } } [protocontract] public class b : { public b() { } [protomember(1)] public string prop2 { get; set; } public override string tostring() { homecoming "prop1=" + prop1 + ", prop2=" + prop2; } } } namespace flat { using protobuf; [protocontract] p...
Read more

javascript - Change element in each JQuery tab to dynamically generated colors -

javascript - Change element in each JQuery tab to dynamically generated colors - i'm using jquery ui tabs widget , have button add together additional tabs. i'm tying each tab markers on map coordinating randomly generated color using function gen_color() { homecoming '#'+(math.random()*0xffffff<<0).tostring(16); } so each tab has color corresponds number of markers of same color on map. i'm trying add together 15x15 block of color within tab's tab left of it's label. right i'm using tabtemplate alternative , trying alter when new tab added: $tabs = $("#tabs").tabs({ tabtemplate: "<li><span class='ui-icon-color' style='background-color:#000000;'></span><a href='#{href}'>#{label}</a> <span class='ui-icon ui-icon-close'>remove tab</span></li>", selected: 0, add: funct...
Read more