Recent content by rider

Something like "Copy as SQL Inserts" for the results would be very appropriate...

IMHO, following lines should also be treated as equal: create or replace procedure "PROC1" as... create or replace procedure PROC1 as... create or replace procedure OWNER.PROC1 as... create or replace procedure "OWNER"."PROC1" as... Of course its true only for very same owner and name - "proc1"...

It would be nice, if Beautifier do it itself

Now beautifier can not parse "create or replace view ..." statements, although its not difficult: you need just cut off text before " as " keyword and then beautify "select" statement. Am I wrong?

Thanks. I used this plugin, but it have some restrictions: 1. Only one object can be wrapped at a time; 2. Wrapped source can not be opened in program window. It might be useful - unit (or several) can be compiled right after wrapping with one click. 3. Plugin is not accessible from popup menu...

Please, add "Wrap Source" popup menu for suitable objects (dbms_ddl.wrap).

Any chance that DOA will use compression method of UTL_COMPRESS whenever?

Hi. I have the compressed data in the oracle blob field, generated by UTL_COMPRESS.lz_compress. If I use mentioned property of TOracleDataset, I can't compress/decomress data since OracleCompress uses some magic values - first I have to convert all data in DB. But if I do so, UTL_COMPRESS will...

It will be nice, if SQL Editor supports new Oracle 10.2 quotation: select q'!asdfasdfa'asdfasdfasdf'asdfasdfasdfasdfasdf!' from dual; select q'[asdfasdfa'asdfasdfasdf'asdfasdfasdfasdfasdf]' from dual;