Recent content by ScottMattes

PLSD v10 I would like PLSD to store the complete statement in the Recall list. By this I mean that if the statement just executed ends in a semi-colon, then when I do a Ctl-E and select that statement then the semi-colon will be there. Now I have to select the desired statement, add a...

From the help file: "If you want to import the text into a new table, press the Create table button. This will invoke the Table Definition Editor with a column definition that matches the configuration."

Have you looked at the Text Importer under the Tools menu?

PLSD v10 I think that the Beautifier should work in R/O windows. If I am viewing someone else's code (or my own from last week) and I want to be able to read it the Beautifier should just work regardless of whether the file is writable or not. Please, just beautify the code and don't set the...

PLSD 10 Win 7 When the HTML window displays I think that the right hand area should have focus so that the user can immediately start scrolling through it with Up/Down keys. I would also like an option so that I could tell Generate to order the columns/program units/type/etc in the display.

We have some tables with lots and lots of columns and they aren't defined in alphabetic order. I thought about asking for an enhancement, but then tried the following first: - run the query - change the result grid to single record view - sort by column name - find and click on the column -...

Just loving the flexibility of input variables (now that I found that chapter 12 applies to the SQL Window as well as reports)! I would like to be able to restrict an input to a range of values for the variable type. Where this came up was &<name="priority" type="integer" default="99">, the...

I have an update. if I right click in the Obj Navigator and select Generate I am told: plsqldev could not generate documentation for DEPT ORA-01012: not logged on Process ID: xxxx Session ID: xxx Serial Number: xxx (Generate Table) So I thought it might just be possible that I was inactive...

The documentation says that from a Command window we can use the command plugin plsqldoc generate to create a batch script to create/refersh our documentation. this only seems to work if the object is a package. on a table I got the following (I took out my schema name): SQL> plugin plsqldoc...

I just started using the PLSQLDoc View Documentation as a replacement for Describe (after the first use of PLSQLDOC on an object, when it is generating the document, it is much faster). Anyway, I see it - if I generate doc on a package, I think PLSQLDoc should just go ahead and generated for...

PLSD version 10 Windows 7 My coding buddy keeps telling me to not get distracted by the squirrels, so... Is there a way to have PLSD open a file, or files, when it is started? Right now I want the PL/SQL Doc index.html file to be opened when I start PLSD. I tried Save Layout with that file...

A Very Good Point IvanZ! Until you asked, I thought that clicking the 'button' for a window in the Window list gave focus to the Window List and now I see that it does not. I guess that i'll have to live with shift-click to delete from the Window List. Good Catch!

because "Corporate policy says that users cannot install compiled code (dlls, exe, etc)" - the last time I tried installing compiled code the IT folks were over in less than an hour, took my PC and re-imaged it (it took them a week to complete the scans and such, then it took me almost as long...

Corporate policy says that users cannot install compiled code (dlls, exe, etc). If LUA (or something like it) were part of PLSD then 'plug-ins' could be written and used as plain text scripts.

PLSD 10.0.5 Win 7 This might affect other windows. When lines are deleted from an editor window, such that all of the text will now fit in that window, the vertical scroll bar disappears. I like that, but if some rows are off the top of the screen it looks like the head has been chopped off. I...