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: 
			
		
	
								
								
									
	
								
							
							 
 
		