Recent content by gad

Hello, Is there a way to change the name that appears on the title bar of a plsql dev window? Usually what appears is the connection name followed by PL/SQL Developer and some of the first row of an sql statement that run in a sql window or the file name if the script or sql are saved to file...

I tried it yesterday before I posted but it did not help. However I tried it just now again and it's OK now. In any case I think the default for new windows should not be any "open" workset. If I need to open a workset I can always open it when needed. I hope it does not happen again because it...

Hello, When I'm opening new plsqldev instance: 1. I cannot access any field in the login dialog (like user name) . All fields except password are greyed and contain whatever was there in the previous login. 2. After I enter the password the instance window opens with a title of one of my...

Hello, Is there any real change from plsql developer? Judging based on the features page the two products seem very similar. Plyxon is new so it's likely underdeveloped and buggy compared to plsql developer. I'm on Windows. should I switch? TIA gad

On the same subject, If possible add check marks to the items in the list so several fields can be selected. The (all) item should mark/unmark all fields instead of being an action item. TIA gad

However, a similar problem is occurring on an XP machine: When NLS_LANG is set to "AMERICAN_AMERICA.AL32UTF8" - the query result shows up to 18 characters just like befure, but when applying the solution (changing to "AMERICAN_AMERICA.IW8ISO8859P8") - the result seems to show the entire string...

Actually, it turns out that I've been checking the wrong registry keys because it's a 32bit client on a 64bit machine in which case the keys are found under "Wow6432Node", So changing NLS_LANG from "AMERICAN_AMERICA.AL32UTF8" to "AMERICAN_AMERICA.IW8ISO8859P8" was the solution. Thank you

I've tried changing the registry NLS_LANG value to "AMERICAN_AMERICA.AL32UTF8" or to "HEBREW_ISRAEL.AL32UTF8" but the query result still shows up to 18 characters from the field. furthermore, the Support Info output (the Character Set section) remains the same no matter what I put in the...

PL/SQL Developer Version 14.0.2.1969 (32 bit) 01.137135 - 1 user license Service Contract: Windows 7 (64-bit) Build 7601 (Service Pack 1) Physical memory : 25,049,648 kB (16,594,552 available) Paging file : 50,097,396 kB (40,966,984 available) Virtual memory : 2,097,024 kB...

The field's length is set to varchar2(30 char), but the query result is only 17 to 18 characters in length. I thought it might've had something to do with the character set: the database NLS_CHARACTERSET is IW8ISO8859P8 NLS_LANGUAGE is AMERICAN NLS_TERITORY is AMERICA (The field itself contains...

Thank you, I tried your suggestion and indeed received no errors. I got confirmation in the status line below the editor, that the query was executed and 528 rows selected, but no results page was created. Where should the results page show? gad

Hello, The manual states in section 5.7 that "In a Test Script you are not limited to PL/SQL blocks. You can also execute single SQL statements, including select statements. Executing a select statement will display an additional Results tab page, which displays all selected rows." When I tried...

Hello, How can I make the reports menu appear as a main menu item and not as item in the Edit menu? I use the classic menu view. It was possible in the pre-ribbon versions. TIA gad

Thank you, Marco. Works perfectly. gad

Hello, When I run plsql developer I get the connection list. Only after choosing a connection I get the logon form where I enter the password. I want to get the logon form immediately without going through the connection list. Could not find the option for this. TIA, gad