Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feature for all table column autocomlite #29928

Open
detkliff opened this issue May 7, 2024 · 3 comments
Open

feature for all table column autocomlite #29928

detkliff opened this issue May 7, 2024 · 3 comments
Labels
feature request xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc.

Comments

@detkliff
Copy link

detkliff commented May 7, 2024

A very convenient tool is available in Oracle PLSQLDeveloper. In addition to the drop-down list of table fields, autocompletion offers an synthetic element ALL.

When you select such an element, all table fields are displayed separated by commas.

This is a very common task during development, replacing one or two fields in the output. Listing fields manually is very difficult. The number of fields can be 20 or 30 or more

example implementation

image

@E1izabeth
Copy link
Member

You can do it this way:

  1. Type * in this place
    image
  2. Press Ctrl+Space to call autocompletion and * will be automatically replaced with all columns separated by comma
    image

@E1izabeth E1izabeth added wait for response question xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc. and removed feature request wait for review labels May 7, 2024
@detkliff
Copy link
Author

detkliff commented May 7, 2024

thanks, very good. But it would be very convenient to duplicate this action in a visual interface

@E1izabeth
Copy link
Member

Thank you for idea

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request xf:sql editor SQL Editor and Editor Services like autocompletion, highlighting, folding, formatting, etc.
Projects
None yet
Development

No branches or pull requests

2 participants