SQL Developer

Hi,

OS Win 7, JDK 1.6_11 shipped with SQL Dev, againts Oracle 9iR2.

I find lots of improvement on the new code completion feature.
However I also find lots of defects on it, here are they :
1. Code completion often offers long exhaustive list of possibility that cause the list to scroll pass the bottom part of SQL Dev instead of giving us a small window with vertical scroll bar in it.
2. Code completion does not offer field list on the following :

   select *
   from   mytable1 t
   inner join mytable2 x on x.  -- does not show field list
   

   select *
   from   mytable1 t
   inner join mytable2 x on x.fi  -- does not show field list starting with 'fi'
   

   select *
	 from   tmp_bow_data_aloy1 x
	 inner join
	 (
	   select *
	   from   tmp_bow_data_aloy2 y
	   where  y. <Ctrl + Space>  -- does not show field list
	 )
   

   select *
	 from   tmp_bow_data_aloy1 x
	 inner join
	 (
	   select *
	   from   tmp_bow_data_aloy2 y
	   where  y.acct_card_no = x.   -- does not show field list
	 )
   

   update mytable1 t
   set    t.  -- does not show field list
   

   delete from mytable1 t
   where  t. -- does not show field list
   

3. Code completion mix between statement although has been delimited with ';'

   select *
   from   mytable1 x;
   
   select *
   from   mytable2 y
   where  <Ctrl + Space>  -- shows all mytable1's fields as well as mytable2's fields
   

Hope these would be fixed on next EA.

Regards,

Buntoro

Edited by: Buntoro on Nov 18, 2011 3:52 AM
Add EA2 to title