its quite usual the way the alias for the view/table works. If i use sql : select t.col1 from my_view t; and when i place "t" and press dot it drops and shows all columns which is very useful and i use all the time.
However when i use a database link, it doesn't seem to work.
example sql : select t.col1 from my_view@dblink1 t;
The SQL executes fine with alias only that the visual part , pressing dot , doesn't popup a list of columns. Or perhaps is there a different way to do it please?
Thanks in advance
SaKa
PLSQLD Version 16.0.2.2154 (32 bit)
However when i use a database link, it doesn't seem to work.
example sql : select t.col1 from my_view@dblink1 t;
The SQL executes fine with alias only that the visual part , pressing dot , doesn't popup a list of columns. Or perhaps is there a different way to do it please?
Thanks in advance
SaKa
PLSQLD Version 16.0.2.2154 (32 bit)
Last edited: