Aaron
- Total activity 20
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 4
- Subscriptions 7
-
-
Aaron created a post, I often receive 'locked by transaction' when only running select queries and refreshing result panes
Very often when I start work in the morning I try to refresh a resultset from yesterday afternoon to get current data. Frequently it shows an error that it cannot refresh because it is locked by a... -
-
Aaron commented, -
-
Aaron created a post, Autocomplete function parameters
When typing an Oracle function name it would make a lot of sense to autocomplete the parameters with the long-hand parameter names. e.g. With this function created and introspected. CREATE OR REPLA... -
-
Aaron commented, -
Aaron created a post, Quick join of lines (numbers) with comma
Many times I execute query A and end up with a list of 10 or 20 numbers in the results. I copy/paste this list into a WHERE IN () clause of query B. When I do this, each time I must add a comma a...