Recent content by Vinny

Ditto the request! (I also asked for this ~2 years ago)

One problem with converting them to strings vi to_char() is that they do not sort properly in the SQL window. i.e. 11 comes before 2.

Version 7.1.5.1396 It seems that I am being prompted to save the java source when no change has been made. Even if I only open a java source and immediately close it, I get prompted to save. Is there a setting controlling this? I do not observe this behavior with other programming units...

Is it even possible to see such constraints on a view? ALTER VIEW pack_cont ADD CONSTRAINT pack_cont_pk PRIMARY KEY (pack_cont_id) DIABLE NOVALIDATE. I cannot find this information even under the view's node in the browser.

PL/SQL Developer does a great job of creating the DDL scripts for creating (and modifying) tables. Is there a way to extend this feature to non-table objects too? What I am looking for are permission tabs on all object types and some others, such as key constraints on views (I know this sounds...

I figured it was easy. Thanks.

Is there any way to see permissions/grants on a table that is not owned by the user logged in, including SYS? Even if I log in as SYS and look at a table's permissions, nothing shows up. This is in the object browser or in the table editor. Seems like SYS should have this ability.

Can you also add to the enhancement list an option to include the owner of a program unit upon file save? If I open a package for edit from the browser and save, it will not include the owner if I am logged in as that user. Only if I edit another user's code does the user get appended (i.e...

Have you tried using the package element emplates to do this? You can easily modify the templates to include line when you insert new program units within your packages.

Marco, I believe this extends beyond the hyperlinks. I think the whole of the code assistant needs to be enhanced. In my example, if I type "pk1." and wait for the code assistant nothing happens. Thanks, Vince

Okay, not a perfect example, my function does not return a value, but hopefully, you get what I mean.

Holding the control key and placing the mouse pointer over a variable turns it into a hyperlink to the variable's declaration. I love this feature. However, I have found that when I am logged in as a user that is not the owner of the programming object (in my case, a package), these links do not...

Is it possible to enhance the package (specification) editor to include a tab that displays permissions? And then upon save have those grants included in the resulting file? Maybe this functionality exists already? Also, upon load of that file, would it be possible to convert that grant...

Is there a preference/configuration setting for controlling what displays in the Window list? I like fixing the window list and browser and templates as a tabbed section to the left of the editor. My only issue is that the window list displays "Program Window - Edit source of package...

Is it possible to enhance the functionality behind the "Show dictionary info in result grid" option to not attempt to include BLOBS? I have a table with only an id/pk column and a blob column. This table is used as the storage area for images and other "attahchments" within our application...