select "LEVEL_ID" as level_value 
       , "CODE_DESC" as label_value 
       , 'f?p=&APP_ID.:'||"URL"||':&SESSION.' as target_value
       , null as is_current 
       , null as image_value 
       , null as image_attr_value 
       , null as image_alt_value
       , "USER_DEFINED_ATTRIBUTE" as USER_DEFINED_ATTRIBUTE
       , "FLAG_PRIV" AS FLAG_PRIV
from "MAIN_MENU_PROB"
start with "PARENT_MENU_ID" is null
connect by prior "MENU_ID" = "PARENT_MENU_ID"