Recent content by Kent

We are having an interesting problem with the DBMS_JOBS folder on version 8.0.1514. When I am logged in and look in that folder I see all the jobs on our server. But when three other staff members login to the same server with the same username and have the same and My Objects items selected...

Note this code: startDate date := trunc(sysdate) - 30; begin select count(*) from tableexample t where t.startdate >= startDate; end; This is intended to count all entries in the table where the startdate column is greater than the value of the startDate variable. But Oracle will use the...

I am using browser extender version 2.0 with the new version 8 of PL/SQL developer. I have a simple Action defined as "truncate #otype #object" which used to work fine for truncating tables. Now it says "invalid character". It seems to be generating "truncate

Is there a way to automatically invoke the text importer, by specifying the import definition and data file on the command line or in a script, etc.?

I have a text file that I want to import, but it has #NULL! in some of the data fields, which I want to replace. I am putting an entry in the SQL function field to do this, but of course the # is being replaced by the data when the import runs. Is there a way to specify the # as a literal in...

I am using the text importer to parse and insert web server log files into a table. However, the log files have comment lines at random locations within the file that begin with '#'. Is there a way to tell the text importer to ignore lines in the input file that begin with a certain character...

You can use the browser extender plug-in to create a right-button menu item that will show all triggers on a table or view. The plug-in comes with an item to show all indexes; just pattern a new item after that and use this as the action: Select...

The text importer is excellent - especially the ability to save import definitions and reuse them. One enhancement that would be very useful is to give the option to skip [n1] lines at the top of the data input file, and to skip [n2] lines at the bottom of the data input file, as many times our...

It would be helpful if the beautifier could match the case of a variable when it is used in procedures to the case in its declaration. For example, the declaration "modifiedMessage varchar2(40);" would cause the beautifier to change all occurences of "MODIFIEDMESSAGE" or "modifiedmessage" or...

It would be useful to have an item in the tablespace context menu to take the tablespace offline or bring it online.

I am trying to create a template that will populate a list box from a query, and then populate a second list box from a query based on the user's choice in the first box. Is this possible? Or do all the $QUERY statements just run at the beginning of the template execution? Here is what I am...

Yes, I am referring to folders that I populate by right-clicking on a table, package, etc. and selecting "Add to Folder". I did find where to manually sort them, but this can get tedious, having to move each item manually as you add it. A menu item to sort them on command or a preference...

Here are a few wishlist items: 1) make large data editor available for condition field when adding checks to a table 2) graphic interface for administering privileges for packages, procedures, sequences 3) ability to alphabetically sort contents of a user defined folder 4) include comparison...

When performing a search and replace, I generally highlight the text to look for and press the search button on the toolbar. When I enter replacement text and press the replace all button, the highlighted instance does not get replaced.

On the context menu for packages, please change "View" and "Edit" to apply to both the package and the body. Then remove the "View package and body" and "Edit package and body" menu items. I always choose "View" or "Edit" for every other db object type, but when by habit I choose one of these...