Recent content by guttormvik

Interesting, but tested that on one of my queries. Didn't help much: when lc_end.location_type = LOCATION_TYPE.HELIPORT then ... when lc_end.location_type = LOCATION_TYPE.HELIPORT then ... -> when lc_end.location_type = :Var10 then ... when lc_end.location_type = :Var12 then ... Each instance...

Use-case: In my pl/sql packages I have selects that use package constants instead of literals. When I want to test these, I copy them to a SQL window, and then I have to manually replace the package constants with the literals. I'd like to automate this search/replace somehow. Original, and...

I have a db trigger that changes current schema to X. I added a connection to pl/Sql developer, logged on with user Y, and got the expected schema X. In the connection list, the connection showed with postfix "[X]" So far so good. After logging off, the connection still showed with postfix...

You can't load a file and selectively execute statements in Command Window. I would have to copy-paste. In some cases it would be interesting to @-run the complete script in a Command Window, but there are at least two issues that makes this awkward: * You have to go into config to change...

Say I have a SQL*Plus scripts that I want to run step by step in PL/SQL Developer's SQL window: insert into table ....; @package/body/some_package.sql /* some long comment ... */ insert into table ....; First insert is fine. I can't run the @-statement itself, which is slightly annoying...

Both screens had the "recommended" scaling, which was 125% for the laptop. Assume that was default as well. Changing my laptop to 100% solves the problem! Now I can drag between the screens, or switch between "External Only" and "Duplicate" with no apparent lag. Nice! For me this solves the...

Done

I work on a laptop with an external screen attached. When I switch between Duplicate and Second Screen Only, it takes 10s+ for PlSql to finish resizing itself! While this is ongoing, the elements of the window keep jumping around and redrawing. This is painful; I do this regularly when I need...

I have a file open with unsaved changed. Then the file changes in the background. When I get back to pl/sql developer, it asks if I want to discard or see differences. The difference viewer shows the current file on the left-hand side, and there the content shows exactly as in the editor. The...

That's a shame. I doubt my employer will want to pay two licenses, and Plyxon is not yet a replacement for PL/SQL Developer. It's been fun to follow along in the beta period, but now I'll delete it and go back to clunky old PL/SQL Developer

I didn't even see that :grin: Physical order is great, since the PK is normally at the top, so I don't think I want to always have the list sorted. I seems weird that you sort the list when I start typing. The logical thing would be to keep whatever order the list had, and just filter it.

I write "[TABLE]." and get a list of all the columns, with user_id first. I write "[TABLE].u" and now user_comment is first with user_id second. I'm guessing you're using column order first, and then sort order? Also: When I've maximized the window and write at the bottom, the list of...

Now that we can navigate with incremental search in the object browsers, it would be great if we could also "open" with keyboard: Database connections: Connect Database Objects: Perform "default" action, like in PL/SQL Developer? Same with doubleclick btw Files: Open

I notice that you automatically retrieve any dbms_output, and there is no option to either disable, or to set any sort of limit. I'm uneasy about this.. I just killed a long-running block, and a while after that I was presented with 1.8M rows of output.. Moving cursor away from that statement...

When I run a statement that takes a long time, all Plyxon shows is "Executing..." It would be better if it showed how long it has been running. Also, for those long-running statements, it would be better if Plyxon plinged when it was done, so that I don't have to periodically check (and forget)