Recent content by YellowShark

While working on the formatting of the MERGE statement. I have an additional wish: I would like see (or have the option to control that) the multiple Join-Conditions inside the ON ( ...) Clause in separate lines. For select-Statements, you can either include the join-conditions inside brackets...

Hello, When a query uses optimzer hints, the Beautifier cannot align the (selected-) columns properly, like it would do without the hints (applies to both PL/SQL Dev 12 and 13): --beautifier without optimizer hints SELECT t.a ,t.b ,t.c FROM myTable t WHERE 1 = 1; --beautifier...

I would like to see this in v13. Advanced compression is now around for quite a while, and the SQLs/DDLs "generated" by PL/SQL developer should reflect the reality, one has to rely on it. (This DDLs are much cleaner and well formated compared to DBMS_METADATA.GET_DDL) Thanks

me too!

Thanks for bringing this up! This is a long time nuisance (easy to be solved by TABbing the select-columns).

Thanks for adding it into Version 13!

For multiple JOIN conditions I have basically two options: 1. Put them in parenthesis => will end up as single line SELECT * FROM destination_table t USING source_table s ON (t.id1 = s.id1 AND t.id2 = s.id2) WHERE (t.key = 123 AND t.key2 = 456); 2. Don't put them in parenthesis => will end...

Yes, I can confirm, that is is much slower than the older one. It is actually too slow, if you are used to the old one. And there is an serious issue with the focus. Usually I paste(from clipboard) the path/filename (derived/copied from a source control system) either into the Open or SaveAs...

Hello, Whenever you execute a statement (SQL/Test/Command/Report Windows) or compile something in Program Window, you have little status line in the bottom saying something like - 1 rows selected in 0,15s - Done in 0.7s - Successfully compiled - ... Can you please add here a timestamp of...

Hello Marco, I have prepared and emailed a script to demonstrate the effects/behaviour of the terminator. The file contains a NULL-terminator(made with an editor, saved as UTF-8) between two statements. You can observe: - Autoselect Statement will always execute the first statement regardless...

The Oracle Documentation is for 11.2.04 (E11882_01.zip). Screenshots have been emailed to support@allroundautomations.com Thanks.

I had a similar issue, but I found out that my problem was caused by an "invisible" terminator character (introduced by some copy&paste operations). It appears to be like a space, but it must be something else. Also if you press CTRL-A (select all) and CTRL-C, the text got only copied until...

The font size and/or scaling of the internal HTML viewer (for viewing HTML manuals) has been reduced from PL/SQL Dev v11 to v12. In v12 it is too small to read. Is there a way to zoom (e.g. CTRL+ and CTRL-) or change it by any other means (config/registry)?

Hello, Also in Version 12 (and 11), we have an issue with the q-string (containing brackets) and syntax-highlighting: PL/SQL: ------- begin l_sql := q'[ UPDATE mytable SET col1 = {col1}, col4 = '{col4}' col5 = '{col5}' WHERE myId = {{myId}} ]'; end; SQL: ----- select q'[ UPDATE...

I'm able to see the objects/packages and see/open their source with "Use DBA views if available" enabled. But what is not working is: - Jump into another package's code with CTRL+MouseClick UNLESS the package is already opened in another program window. - See the procedure definition/parameters...