Recent content by dcurley

Gotcha. We're so very, very far from having anything like that allowed here it didn't even occur to me.... Dave

You can't use roles to assign rights on objects to be used in compiled code. See this Ask Tom article for more info: http://tinyurl.com/akvjn. This should get you a script (the first column) you can use to duplicate the grants already made to a role or user to any other role or number of...

You can also use autocomplete by adding a query in Syntax Highlighting configuration (tools>syntax highlighting) to select table names from user_tables or all_tables. Something like select table_name from all_tables where owner in () union select view_name from all_views where owner in ()...

Sorry for butting in, but what are you talking about? Is this about some way of distributing PL/SQL Dev to users in an organization without each of them needing the license code (which would be cool), or is this just an Oracle select/insert/etc. grant question? Dave

Hitting on an indented line places the cursor on the next line at the same indented column. Is there a way I can just go to the first column of the new line instead - something like -? Dave

Is it necessary to disable File>Reopen when a project is open? It'd be nice if I could open a file without having to add it to the project or remember the full path. (And since I can use File>Open to open it, removing File>Reopen doesn't really prevent anything.) Thanks, Dave

Hi, You know the minimize window option on the right-click menu in the window list? Would it be possible to make that the default behavior when the active window button is clicked? (So the windows list buttons would work like the XP taskbar and toggle windows between minimized and open with...

I was wondering if Marco or anybody else here had any thoughts on Raptor both as a tool in itself and for what it might mean for third-party Oracle IDEs, especially PL/SQL Dev? I played around with it a little bit, and have to say that it's a start, but even allowing for the fact that it's...

We've been using it for three or four years now (first 5 users, then 10, then 20, and now site-licensed) and have never needed training. I've found that more or less anything I know the Oracle for is either obvious or easy to figure out. And we've never had problems with support. I've asked...

I've been playing around and I think my earlier problems were my getting confused around the effect of a period in the comment before a program element and having a mix of /** and -- comments. I've created a new package that I've been testing with and think I have it worked out. Sorry to have...

Hi, I'm having trouble getting strict comments to work in a package. Between the spec and the body, the only place they seem to be recognized is immediately preceding a program unit. /** comments are ignored after the create package & create package body statements. Also, I can't seem to use...

Any progess on this? Both are still a problems in 6.0.5.931. Thanks, Dave

I think the DDL generated by the compare user objects isn't quite correct for partitioned objects. 1) It includes storage info for the partitions, but not at the object level. I think this means that new table partitions will be created in the user's default tablespace, which may not be what's...

Hi, Would it be possible to add a comma-separated copy option in the SQL window results frame? I often copy a single field from multiple records to use as an IN clause in a second query, and being able to choose comma-separated would be quite convenient. Thanks, Dave Curley

I like the new speed of export to Excel but: 1) Applying Excel's currency, percent or comma number formats from the toolbar to any cell on the worksheet (not just the imported cells) also makes the cell bold. (Using the format|cells... window does not.) 2) Empty cells from text fields are...