New returning user of PLSQL Developer - some quick questions

[olona]

I am a long time returning user of PLSQL developer. Having mostly used Toad the last couple of years for database and Eclipse/IntelliJ for Java Development I have some questions for all you experts out there.

In SQL Editor:
Is there function for Duplicate a Line or a section?
Is is possible to move lines up and down?
Is there a shortcut for "view object" similar to F4 in Toad.

Configuration
Is it possible to search / filter the Key Configuration so that I can quickly find the Item I am after, similar to Toad and IntelliJ.

 

[olona]

Is it possible to create (automated) test scripts based on the Test procedure, and perhaps assert results? Examples?

 

[olona]

I just realised that lower/upper case shortcut will convert the entire string, including text within a ''. In Toad normally this text would be ignored. Any way of doing that in PLSQL Developer as well?

 

[mike]

Editor functions: As far as I know, none of these editor functions are there. For some editor functions that are missing, I create macros for and assign hot-keys. Others I do without. If you want them, it doesn't hurt to ask for them.

Upper/Lower Case: The lower/upper case will convert strings as you noticed. I personally like PL/SQL Developers way - what if I want to convert what's in a string to upper case? I use the beautifier and it takes care of keywords being the case I want and all that. If you don't want to format, you can highlight the whole document and do edit/selection/apply keyword case which is defaulted to F4 if I remember.

View Object: Press CTL and hover your mouse on objects and they will have hyperlinks. Ctl-Clicking on tables/views is similar (but not exactly the same) to F4 in Toad. Also, you can right click on an object name to choose things like edit, query data and stuff. You can ctl-click or ctl-right click on package names to view the package spec or body.

Key Configurations: I don't know of a way to filter or sort the key configurations. I notice they are in order though, so it doesn't take me long to find what I want.

Testing: You can right click any public function or procedure in the code contents or object browser and choose the test option and it will create a blank test script. You can save these and there is also a test manager tool that you can run a group of test scripts and check the output of. It's a lot to explain, so you need to read the manual to understand.

Personally, I think the test tool is nice and I use it, but it is kind of basic. For example, it would be nice if there was a way to create test scripts for a whole package with one button click. Stuff like that.

 

[olona]

Thanks Mike!

It seems that I need to change my mind set a bit, instead of trying to make PLSQL Developer work like Toad I have to accept the new ways.