insert、start with

 

insert into一个例子:

insert into GN_D_USER_PROP_FAVORITE_T
  (user_id, prop_id, prop_name)
  select 'zhugc' user_id, pro_id prop_id, pro_name prop_name
     from GN_D_USER_PROP_TREE_T
    where pro_id in
          (010022, 010125, 040121, 040135, 040147, 100154, 100155)

start with一个例子：

  SELECT distinct
   T.PRO_ID id,
   T.PRO_NAME label,
   T.PRO_PID parent
  FROM
   GN_D_USER_PROP_TREE_T T
     start with T.pro_id in (select prop_id from GN_D_USER_PROP_FAVORITE_T where user_id=$value$)
       connect by  T.pro_id = prior T.pro_pid