I would like to make an enhancement request that would apply to both the code assistant and describe feature. That is, it would great if you could filter results once displayed using a wildcard or like statement.
Right now the code assistant will filter based on the first few characters you...
Can PL/SQL developer be made aware of the current_schema setting (as an option) when using the code assistant. Right now one needs to include the schema name before the code assistant can provide a valid pick list to select from.
Try this ... open a package body and in the code content window right click and select comment. Then go into the editor and place your cursor in the newly commented code and select uncomment; nothing will happen unless you are on the very first line of the comment block ... I'm pretty sure it...
Prior to 7.1, if I placed my cursor anywhere inside a comment block "/* ... */" and executed "Selection uncomment" it used to find and remove the comment delimiters. Now this only works if you highlight the entire comment block first.
I've been using version 7 for a few weeks now and noticed the following issues:
1) Code Content window is not populated properly (or at all) when I used CASE statements in the variable bind of a procedure call within a package. When I replaced the CASE from the bind the content window...
I have a new install of PL\SQL developer and Windows Office 2003 (Outlook 2003) and now when I select File->E-mail... I just get a message "Error sending mail (2).". This did not happen when I was using Windows Office XP (Outlook 2002).
I'm not sure what the error is or if there is a log file...
Just found another request for the same issue and saw that you can set these keys in the key preferences, however I never unset them - so either the defaults were cleared by an upgrade to PL/SQL developer or the settings were newly added to preferences screen. Resetting the default keys...
I'm pretty sure that holding the CTRL key and pressing the left and right arrows while in an editor window used to move to the beginning and end of the current word. Holding SHILT+CTRL used to do the same movement and highlight the word. This functionality no longer seems to work.
I'm using...
Code Assistant does not recognize Materialized View columns.
For example,
SELECT *
FROM m_view_1 t
WHERE t. -- Code assistant will not give any columns to pick from.
There is a missing feature in the use of Project and that is the ability to promote a Project from one environment to another, e.g. from a development database to a testing or production database.
Thanks,
Two requests...
1) For export User object it would be nice to have options for defining how the file name should be generated, in particular the case for the file name and the extension. We have a source code control tool that is case-sensitive with regards to file names and all the existing...
There are DBA views that should have this information - you may have to analyze your tables for this first ... the following query can be run as system to generate a script that will give you the results you are after:
SELECT 'SELECT ''' | | owner | | ''' owner' | | CHR(10) | |
'...
One additional problem... when I have the Editor option "allow cursor at end of line" checked and I select text in the SQL or Program window such that the cursor is beyond the end of the last line selected and I press the nothing happens. However when I press the text is deleted as expected...
Try turning the Code Assistant off (if you have it automatically activated). Then use F6 it invoke it when needed. You can do this in your preferences.
1) It would be nice to have an option on the right-click menu in the Program Window (of a package specification or body) to open up the corresponding package body for the current package spec and vice versa (this will open a new Program Window tab if the spec/body is not already open or just...