- 活动总数 20
- 关注 0 名用户
- 关注者数 0 名用户
- 投票数 4
- 订阅数 7
I often receive 'locked by transaction' when only running select queries and refreshing result panesVery 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...
Autocomplete function parametersWhen 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...
Quick join of lines (numbers) with commaMany 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...