Recent content by roselan

Heyhey, it would be nice that Pivot keyword got it's own new line in the beautifier instead of select * from (select thing from stuff join more_stuff where some_random_things = are_realy_long_meaninless_names) pivot count(*) for stuff in (bunch_of_things); would be...

my 2 cents as i'm passing by. We had bad surprises with plan_table synonym in 11g/12c SPM. In some cases baselines were not shown in the notes, causing many headscratches. here is the queries template I use now: note: generally i remove the "allstats last" format, and if you don't want to...

6 months later I dig out this topic. It would be *lovely* to inspect a collection tree from the debugger watched variables. It's by far the feature I miss the most in plsqldev (And not only me).

same here: I don't want to overwhelm you ;) Plus i have another pro app that prevent me to get rid of winstuff yet (as well as some old 3d games). A bit like anyone of us I guess, I'll try to work on linux from next week. And definitively get rid of the windows partition next year...

wohooo! thanks a lot!!! I'm not dba here so it might take some time before the patch is applied. update: Murphy strikes again! There is no release for sun sparc-64 10.2.0.2 :'( I will do some lobbying on my dba company so that we can get it compiled for our server. but thank you again for...

when I run a sql/xml query, and retrieve xmltype data, it works fine the one the first time. The second xmltype select will make plsqldev hang, and generate an file in the udump dir. the result happens if I query xml from a comand line window or a sql window. It does not matter if the xmltype...

I often run several queries in parallel. They usually last between 1 minute and 1 hour. Thanks to Explain Plan I know more or less how much time they will last, but I nearly always forget when I started them. So I would love to see a "running since" or a "chronometer" in the status bar of each...

I was a big fan of the session switch of Toad... despise the few (herm) problems it could cause (more due to me than the program. Actually, it is the only function I really miss. I work in a mutli-user/instance/database/location environment (no it is not a mess!), so I did think a bit to this...

go on, give them another finger (no, i'm only thinking to the thumb, why?). Can you guyz please tell me what you want to do with the print screens?

not my ibm laptop :p

Hey, some months ago I asked for shift+f10 (corresponding to right click menu) to be added. As you aggreed but never implemented it, i ask for it again...

I often use the "export by right-clicking on a table" feature. It opens the export window on the correct table, however the default file name is the last used one. I would love to see something like "last_directory\export_of_TABLE_NAME.SQL" Moreover, It will be nice to have a multiline edit...

Nahhh, actually q.u.e.s.t only give away t-shirts to clean up their mess (down there under...) :( There was a time, long, loooooong ago, when we were young and in the internet (seems like centuries hmmm?) where the ugly animal was the coolest thing on earth, if not in the universe. Gee, I...

hello, In a sql window, I did use the help by pushing "F1" while the cursor was on an oracle funciton. When I got the information i needed from it, I pushed "ctrl+w" to close help window. However, it was my sql window which closed, and not the help one. It is quite... surprising :/ cya

yummy ! this is so great !