Recent content by Maxmix

Maybe, 'File browser' feature? Double-click on .tst files is supported.

Maybe, 'File browser' feature? Double-click on .tst files is supported.

Maybe, 'File browser' feature? Double-click on .tst files is supported.

It's funny, for I started to deal with Oracle with PL/SQL Developer from the start, and now all newer fancy apps/interfaces appear clumsy and unusable to me. This is (reordering of object browser folders) indeed is the first thing to do. Locating just few menu commands ('Log on', 'New SQL...

SaKa, It does just that : limits db objects by adding conditions to queries, searching within the metadata. We can use any columns from ALL_OBJECTS view, e.g. owner in ('BESTSCHEMA', 'OURUTILS') and object_name not like 'TMP%' Something like this.

I think, 'Browser filter' criterion does just that. You can define browser filters with an arbitrary query.

I think, 'Browser filter' criterion does just that. You can define browser filters with an arbitrary query.

Deleted duplicate

Deleted duplicate

Nice! I wish I learned it before...

But any DML prohibited within pipelined function. Serious limitation, I'd say

If you have to combine DML + Query logic in one call, then you need a function, returning CURSOR. Function can be within a package or standalone: create or replace package body MYPKG .............. procedure P (result out sys_refcursor, Param1 date, Param2 number, ...) is begin -- Prepare...

The request is on the famous list, for too long:https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=44758#Post44758 I am in wait, too.