Wish list for Dev 6.0

Wojtek

Wojtek

Member²
I think that would be nice to have (it additionaly increase PLSQL Dev functionality):

1. Couter of each object type in main browser (how many tables, packages, indexes..)
2. Print selected text of package/sql
3. Save settings (profile) of preferences
4. Left Alt + key arrows (jump to previous) position in code - similar as in IE (browsing history)
5. Lack of materialized views (snapshots) in browser window.

I know U can do it ;)
Regards
Wojtek
 
I have added this to the list of enhancement requests. Note however that:

2. Print selected text of package/sql

This is already implemented. If you select a piece of code and invoke the Print function, it will be printed.

5. Lack of materialized views (snapshots) in browser window.

Materialized views are listed in the Object Browser. If they are missing for you, go to Tools > Browser Folders to make it visible.

.. and one more thing - highliting BEGIN - END text.

This is already the case. Only the zero level begin/end pair of a function or procedure is not highlighted.
 
Thanks Marco,
hmm... I've to say that PL/SQL Developer amaze me all the time.
1.lack of MV's - you're right! It wasn't set in browser folders.
2. BEGIN/END - you're right as well.
3. Prining selected text isn't obvious - user don't know what exactly is printed.

Regards
Wojtek
 
Another question.
I tried to define folder "Indexes". Add object_type like 'INDEX%' at where clause tab, but folder is empty.
There is a lot of indexes for current session, so why I can't see them, what I do wrong?

Regards
Wojtek
 
Indexes are not elementary object types for the Object Browser, so you cannot get a folder with indexes. Only the object types from the system folders of the Object Browser can be used.
 
One more thing.
Query data from table generates "select * from
". COuld you please change it to select from
. It would be very helfull.

regards
Wojtek
 
I like the *, because it's simple.

If I want all column names, I can easily copy them from the browser (copy comma separated). Otherwise, the SQL window will be cluttered with column names.

Even worse, (as in SQL Navigator), each column might be printed on one line, such that I have to start scrolling while modyfiying the SQL.

So if you do all column names, please make it optional.

What would be nice: If I could drag column names from the result pane to the SQL text pane (or a right mouse function "Copy header").

Wojtek wrote:
> Query data from table generates "select * from
>
". COuld you please change it to select
> from
.
 
Yes, please leave the * !

Another means to get the list of all columns: drag and drop a table from the Object Browser into the SQL text pane and in the popup menu which then appears select option "Select".

Regards
 
Additional (I think?) related request.

In my query result window, if I select a column from the result and right-click, I can Copy or Copy with Header. I'd also like to be able to select Copy Comma Separated. Furthermore, if the column is a string type, I'd like it to put single-quotes around the values!

Handy feature, eh? :cool:

I often do a query to get a list of key values, then build a subsequent query to find other data for that list of key values. So this feature would let me quickly build an IN clause.

Thanks for the thought,

Stew
 
You must log in or register to reply here.

Similar threads

Wojtek
  • Discussion Discussion
Wish list 2
Replies
10
Views
4K
Anthony Harper
A
Back
Top