Recent content by Philippe Malera

On this page :https://www.allroundautomations.com/products/pl-sql-developer/features/new-features-pl-sql-13-0/ In chapter : PROGRAM WINDOW ENHANCEMENTS It says : DBMS_Output is now retrieved when executing a PL/SQL Block. But I cannot find the "Output tab" in my Program window (used for testing...

Today, in our package bodies, we are creating fake private procedures, just to split group of them by context. This image will help you understand : In this example, procedure "o_____debugging_and_performances_____" is a fake one and is here only to help navigation visibility, it separate a...

The plugin "TortoiseSVN-wrapper" cannot be downloaded any more from plugin list :https://www.allroundautomations.com/products/pl-sql-developer/plug-ins/ Underlying site is decommissioned.

Our views are in a file, which is opened in an SQL window (or a command window), and thus Beautifier has no effect. We can't edit views in a program window.

I agree with you, personally, I beautify the underlying query manually by selecting it and Ctrl-B. But I would appreciate to beautify a file with views without this trick.

Thanks, but in fact it is very difficult to explain to all developers to do such operation (duplicate brackets in the response). As we are using suffix "[O]" for many of our applicative objects which have to be input in these template. Hope we will get a fix.

Thanks

It seems that we could only create such view with SQL*Plus, but not with PLSQL Developer. CREATE OR REPLACE VIEW test$v AS WITH FUNCTION with_function(p_id IN VARCHAR2) RETURN VARCHAR2 IS BEGIN RETURN p_id; END; SELECT with_function(dummy) AS dummy FROM...

I've tried to modify my template as you said : test := '&&<name="Object">'; But now it doesn't substitute anything. Could you give me a syntax example ? I didn't found anything in the doc.

Create a template "test.tpl" with this content : test := '&<name="Object">'; Execute this template in an SQL window and, in the "Object", enter the text : "Hello[X]" This will consider [X] as a new input control and remove it. How to tell the system, to consider result as is, without asking...

And how can we modify it ourself ?

Thanks, but where did you find this configuration ? I didnt found it in the "Preferences"

It seems that problem still not fixed in Version 12.0.7.1837 Expected : BEGIN -- NoFormat Start FORALL idx IN 1 .. l_bal.count EXECUTE IMMEDIATE(l_sql) USING IN l_bal(idx).balance, l_bal(idx).rowid1; -- NoFormat End END; Got: BEGIN FORALL idx IN 1 .. l_bal.count EXECUTE...

When I want to see triggers on a table, i put my cursor on the table name, I press F1 (view) and I can see the triggers in the triggers tab. How can I do the same on views ? How can I see "Instead of triggers" on a view without searching for it in the object browser ?

Thanks