Query Builder - modifying existing query

[stevec]

The help file says
"Modifying an existing select statement
To modify an existing select statement in your PL/SQL or SQL source code, simply right-click on the select statement and select the Query Builder item from the popup menu. The complete select statement will be marked in the editor, and the Query Builder will be displayed. Now you can change the query definition as described in the previous chapter."

I've tried this with the following, but the Builder opens with a blank pane :-(

create or replace view DC_RPT_DCBV as
select dcappl.caseno,
dcappl.refval,
dcappl.dateapval,
dcappl.datedeciss,
dcappl.dcapptyp,
dcappl.decsn,
dcappl.dectype,
dcappl.dtypnumbco,
to_number( substr(dcappl.dtypnumbco, 1, 2) )as Main_DTYPNUMBCO
from dcappl,
cncodemap dcapptyp,
cncodemap decsn
where dcappl.datedeciss is not null
and dcappl.dateapval is not null
and dcappl.dcapptyp = dcapptyp.codevalue
and dcappl.decsn = decsn.codevalue
and dcapptyp.mapname = 'DCBV'
and dcapptyp.fieldname = 'DCAPPTYP'
and decsn.mapname = 'DCBV'
and decsn.fieldname = 'DECSN'

 

[Marco Kalter]

That does indeed not work for "create view" statements. Right now you have to explicitly select the select statement.

We'll fix this.

------------------
Marco Kalter
Allround Automations

 

[stevec]

Yeap, selecting the "Select ..." and then Query Builder does work

Thanks for the pointer Marco