Questions about linked query

[Duddha]

At last I have discovered linked query functionality (better late than never )

And I've got some questions about it:
1. Can I save my custom linked query so it appears in "Linked Query" button submenu anytime for the table?
2. I've renamed column in result set using cyrillic letters with spaces

select id_tab as "Таб. №" from ...

Is it possible to use such field as master field for linked query? If yes, than please tell me how to do it. What about just cyrillic symbols without spaces or latin letters with spaces?

 

[Marco Kalter]

1. No, this is currently not possible. I have added this to the list of enhancement requests.

2. Cyrillic should work. I'm not sure about spaces though.

 

[Duddha]

2. Cyrillic should work

Ok, cyrillic (without spaces) really works. I've tested column named

AS "ТабНомер"

and in linked query

WHERE ... LIKE :m_ТабНомер

This one works good.

If there are any spaces I've got:

• ORA-00933 SQL command not properly ended - if field name e.g. "tab num" and where clause in linked query is
  

  ... LIKE :m_tab num

• or, if replace spaces by "_" in linked query, ORA-01008 not all variables bound - if where clause is
  

  ... LIKE :m_tab_num

Maybe I just should remember not to use such names if I want to have linked query