OracleµÝ¹éº¯Êý

CREATE OR REPLACE VIEW ADMIN.TYPETREEVIEW
(ID, ITEMNO, ITEMNOSUB, GROUPID, MEMO,
TREE)
AS
/* 2007/01/23 16:51 XieShaoHua µÝ¹é²éѯ */
SELECT     typetree.ID, typetree.itemno, typetree.itemnosub, typetree.groupid,
           typetree.memo,
           RPAD ('¡¡', LEVEL * 3 - 2, '¡¡') || '©À' || typetree.memo AS tree
      from typetree
START WITH itemnosub = '0'
CONNECT BY PRIOR typetree.itemno = typetree.itemnosub;