Recent content by amaury

What about the Command Window? the display is in fixed-width format, and you can spool the results in a file. Amaury

Couldn't PLSQLdev do that for us? Create a stored procedure with a random name and run it. The implementaion would not be so different from the "safe compilation" option. Amaury

I often add this at the end of my test scripts: open :cur for select ....; And I bind the "cur" variable with the "Cursor" type. After running the test, click on the "..." to see the results. Note: Don't forget to fetch all data before you "rollback" the test window. You can perform...

Did you try using "Native Dynamic SQL" (EXECUTE IMMEDIATE...) instead of DBMS_SQL? Since this is a built-in instruction and not a function call, the time spent executing the query appears on the correct line. Maybe the time to rewrite your code... Amaury.

There are some hints at the WINE site: http://appdb.winehq.org/appview.php?appId=935&versionId=1229 Amaury

user_views contains the text of the view, but without the list of columns. So the "edit view" command has to "describe" the view to get this list. I guess that "select * from myview where 1=0" makes you wait as long... Amaury

Here are my settings: Caption: Cursors Query: select * from v$open_cursor where sid=:sid Hope this helps, Amaury.

Yes, I also noticed that multi-line 'string literals' are not correctly coloured. Note that this does not happen with "double quoted identifiers" which are correct even if they span several lines. Amaury.

I have a kind of solution that works with Oracle 9i: select Field1,Field2,sum(Field2) from Table1 group by rollup(Field1,Field2) having grouping(Field1)=grouping(Field2); ROLLUP, used in GROUP BY clauses, makes Oracle compute and return additional rows with the sum at different levels...