Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Copy and Paste Predicates in SQL Developer

Very practical feature in SQL Developer is the possibility to copy the column name of a table
But often you want to have not only the column name, but a whole predicate such as:
column_name = column_value
It would be very practical to simple highlight a value of some column in the query result
and to get a possibility in the right mouse button menu to copy the whole predicate
column_name = column_value
For varchar2 column the value would be enclosed in apostrophes
Copy col1 = 'B'
In case of DATE column few options could be suggested such as
Copy Col2 = DATE’2020-04-15’
Copy col2 = to_date(’15.04.2020’,’dd.mm.yyyy’)
The latter option would be driven be the NLS settings.
If values of more columns would be selected, the resulted predicates would be connected with AND.
All of this can be done in SQL Developer already now, but in several steps with additional edit - this feature I'd love to have several times each day in my work. Special features, like greater then, parentheses etc. will be edited manually as usual.
Comments
-
Thanks for contributing your idea. Enhancement requests for SQL Developer are being tracked in SQL Developer Exchange (https://sqldeveloper.oracle.com). Please file this request there.
-
Thanks for contributing your idea. Enhancement requests for SQL Developer are being tracked in SQL Developer Exchange (https://sqldeveloper.oracle.com). Please file this request there.
Done, this post will be deleted soon. Thanks for assisting!
-
Feature created in SQL Developer Exchange https://apex.oracle.com/pls/apex/f?p=43135:7::::RP,7:P7_ID:48501