Feature request: SQL Window

[Robertas]

it would be nice to have such a features:
1) paste column name when you drag a column(name) from query result window to query window. For example: you do select * from table1 and get result: col1, col2, col3 and you want to write a where clause so you simply drag a column name from result to the query text and get the column name pasted
2) make a possibility to select cells in result grid as in excel
for example, we have result set:
col1|col2|col3|col4
-------------------
A | B | C | D
E | F | G | H
I | J | K | L

and we need to copy values of cell F G J K or B and K or something similar
3) edit data
is there a posibility to edit query data without adding rowid manualy? if we have table with thousands of record and for example 20 columns, is there a possibility to edit data returned by provided query:
select col1, col2 from some_table where ...
if not - then its a request

thank you

 

[Marco Kalter]

1) paste column name when you drag a column(name) from query result window to query window. For example: you do select * from table1 and get result: col1, col2, col3 and you want to write a where clause so you simply drag a column name from result to the query text and get the column name pasted

I have added this to the list of enhancement requests. Note that you can already use Query By Example mode in this specific case.

2) make a possibility to select cells in result grid as in excel

This is already possible. See chapter 6.2, paragraph "Selecting columns, rows and cells" for a detailed description.

3) edit data
is there a posibility to edit query data without adding rowid manualy? if we have table with thousands of record and for example 20 columns, is there a possibility to edit data returned by provided query:
select col1, col2 from some_table where ...

You can add the for update clause, but this will implicitly lock all fetched records.

 

[Robertas]

2) Thanks for the note, i just did not find this before, but
i could not find a way to select cells separately (as you do in excel with Ctrl pressed). I think that functionality of data grid is implemented in all application grids so one of the examples where it could be used:
right click on table name->describe you get a grid describing table columns, now i can select needed columns and drag them to sql window. It is possible to do this now, but you can not select just column names that you really need (Ctrl)
3) maybe it would be better to add such functionality:
if you select query text, then right click -> edit data and selected query text is passed to the new window.
For example, you select such query text:
select t1_col1, t2_col2 from t1 join t2.. where
right click->edit data and you get the same query with rowid added to it