Print Thread
Page 1 of 2 1 2
Feature request - Connection dialog and concurrent database connections on same plsqldev instance
#34225 06/18/09 02:44 PM
Joined: Jun 2009
Posts: 5
Belgium, Brussels
A
Alp Offline OP
Member
OP Offline
Member
A
Joined: Jun 2009
Posts: 5
Belgium, Brussels
Hi,

First, I currently try plsqldev, i'm currently a toad user wink
plsqldev seems require most of my requested features with a more reasonable price.


  • 1 One usefull feature for me is a rich dialog connection
    it's very usefull when you have a lot of database schema to manage frown
  • 2
    And on a same way, it's not possible to open more than one database connection on the same plsqldev instance, can be this evolve in the future ?


Regards,

Re: Feature request - Connection dialog and concurrent database connections on same plsqldev instance
Alp #34230 06/19/09 08:42 AM
Joined: Aug 1999
Posts: 22,224
Member
Offline
Member
Joined: Aug 1999
Posts: 22,224
What exactly do you mean by "a rich dialog connection"?


Marco Kalter
Allround Automations
Re: Feature request - Connection dialog and concurrent database connections on same plsqldev instance
Marco Kalter #34233 06/19/09 12:38 PM
Joined: Jun 2009
Posts: 5
Belgium, Brussels
A
Alp Offline OP
Member
OP Offline
Member
A
Joined: Jun 2009
Posts: 5
Belgium, Brussels
A dialog like the next (it can be found on some concurrent product smile

User - Database - Last connect - Connect mode - Auto connect - User column1 - User column2 - Oracle Home
scott - mytns - - NORMAL - NO - PROD
systel - mytns - - SYSDBA - NO - PROD

BUTTON CONNECT BUTTON EDIT TNS BUTTON CANCEL

Re: Feature request - Connection dialog and concurrent database connections on same plsqldev instance
Alp #34237 06/21/09 08:55 PM
Joined: Dec 2002
Posts: 491
Wellington, NZ
Member
Offline
Member
Joined: Dec 2002
Posts: 491
Wellington, NZ
toad has a good one, so does "sql tools"


... suck in your lips and frown like a werewolf ...
Re: Feature request - Connection dialog and concurrent database connections on same plsqldev instance
rbrooker #34241 06/22/09 09:35 AM
Joined: Aug 1999
Posts: 22,224
Member
Offline
Member
Joined: Aug 1999
Posts: 22,224
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations
Re: Feature request - Connection dialog and concurrent database connections on same plsqldev instance
Marco Kalter #34242 06/22/09 10:37 AM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
That requested feature can be dangerous too.
It should always be made clear in which connection you are in your current window. Otherwise it can be risky when you assume you're in development environment while forgetting that you've just switched into production environment for a quick check.
I'm sure all of us have had moments of shocks like that.
Would be great if there could be some color coding of i.e. the windows title bar for that, something like prod=red, test=blue, dev=green, unknown=yellow. It should in any case be something that draws attention to it automatically and intuitively.


Regards,
Berny
Re: Feature request - Connection dialog and concurrent database connections on same plsqldev instanc
Bernhard S #34244 06/22/09 01:29 PM
Joined: Sep 2008
Posts: 10
Melbourne, Australia
Member
Offline
Member
Joined: Sep 2008
Posts: 10
Melbourne, Australia
The 'Color Coding' feature is already present. Look under Preferences/User Interface/Appearance/Connection Indicators. I use Red for my Prod databases, Green for my Dev databases.

Cheers,
Pete.

Re: Feature request - Connection dialog and concurrent database connections on same plsqldev instanc
petesmith #34254 06/23/09 12:52 PM
Joined: Aug 2008
Posts: 60
Belgium
W
Wim Offline
Member
Offline
Member
W
Joined: Aug 2008
Posts: 60
Belgium
Indeed it exists (though I wasn't using it; thanks Pete for reminding me about it).

Is it possible to use wildcards in the 'match' (user@database)? %@PROD% for example. If not I hope Marco puts it in the requests list smile


Regards,
Wim
Re: Feature request - Connection dialog and concurrent database connections on same plsqldev instanc
Wim #34255 06/23/09 01:14 PM
Joined: Jan 2009
Posts: 47
Montreal, Qc, Canada
Member
Offline
Member
Joined: Jan 2009
Posts: 47
Montreal, Qc, Canada
Try using something like this, it seem to work

ex:
bc*@*

This will display my color code for any user starting with BC on any database

Re: Feature request - Connection dialog and concurrent database connections on same plsqldev instanc
MartinF #34259 06/24/09 07:11 AM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
Thank you guys for the tip. Is just a bit counter-intuitive for us Oracle users to have to use '*' as wildcard. I'd prefer the standard sql-query LIKE syntax with '%' and '_' as wildcards. cool


Regards,
Berny
Page 1 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.041s Queries: 15 (0.006s) Memory: 2.5630 MB (Peak: 3.0424 MB) Data Comp: Off Server Time: 2024-05-23 11:41:49 UTC
Valid HTML 5 and Valid CSS