Recent content by Michael Maramzin

And what key shortcut fold/unfold one block (where cursor blinked)? (Main menu: "Edit \ Code Folding" accepted to entire text)

Can I fold any block of text in PL/SQL Developer 7.1? For example MS Visual Studio allow mark folding range with keywords "#region" and "#endregion": #region Folding description ... code ... #endregion Result: [+] Folding description

It maybe Oracle bug. It's a database event trigger "after servererror" on database or schema. If there's a trigger on schema (even empty) it's impossible to debug code in this schema (the session hangs) but in other schemas there's no problems. A trigger on database schema (even empty too)...

It would be nice if it was possible to select several SQL statements in the "Recall Statement" window and insert all them into the "SQL window".

create or replace procedure compiler_wrong_hint /* Compilation errors for PROCEDURE NSMEP.COMPILER_WRONG_HINT Error: Hint: Value assigned to 'l_hint_var' never used in 'compiler_wrong_hint' Line: 12 Text: l_hint_var:= 'xxx'; */ is l_hint_var varchar2(100); begin l_hint_var:= 'xxx'; --...

What version RDBMS? Are you have system event trigger [after] servererror on database in your DB?

It would be very convenient if it would be possible to select objects to compare using a mask (with wildcards or/and regular expressions) like file [de]selection in file managers (Norton Commander, Far, etc). For instance like in NC by pressing "+" and "-" in numeric pad. Best regards, Michael...

PL/SQL Developer Version 6.0.1.848 Compare two tables, details see in: http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=3;t=001300 Comparation result script does not contain "alter table rename ...", but "comments" still present. If I press "Apply" button and then again...

PL/SQL Developer Version 6.0.0.840 -- SQL*Plus -- SQL> conn dryer@m Enter password: ********* Connected. SQL> desc fmmg_owners Name Null? Type ------------------------- -------- ------------ OWNER_ID NOT NULL NUMBER(38) OKPO...

9.2 Standard Edition?

Hi, I can't create User/Role/"DB Link" in PL/SQL Developer wizard, with non alphanumeric chars in password. I need press "View SQL" button, and manually add double quote around password. Please, fix it. e.g.: create database link some_name connect to some_user identified by kl;' using...

It seems that there's no information about grants on columns in PL/SQL Developer's GUI. e.g.: grant update (col1,col2,col3,col4) on a_table to a_user; select * from all_col_privs t where t.grantee='A_USER'; Then in GUI (Browser->Users->View) information about column privs is absent :( It's...

I've downloaded the next version beta (from http://www.allroundautomations.com/registered/plsqldevbeta.html) but the product code I have doesn't work. How do I get a suitable code? What will it cost to migrate? Our license: Product: PL/SQL Developer - Serial number: 11.16698 - Licenses: 10 -...

Hi, When I type in SQL window view content create or replace view SOME_VIEW as select .... and click "Save" button i need enter file name SOME_VIEW manually. Can you parse SQL window text, and if it contain only view body then propose view name as file name by default? With best regards...

Hi, Where I can in PL/SQL Developer GUI (5.1.6.747) rename column in table (RDBMS 9.2.0.4)? By analogy with statement "alter table table_name rename column old_col_name to new_col_name;" in Command Window.