?? app_list_v.sql
字號:
CREATE OR REPLACE VIEW APP_LIST_V AS
SELECT app.APP_ID,
app.APP_CODE,
app.APPDESC,
app.VERSION,
app.VERSIONDATE,
app.APPTYPE_CODE,
app.APPSTATUS_CODE,
page.PAGE_CODE,
page.PAGEDESC,
NVL(appf.MENUNAME,'NOT DEFINE') AS APPNAME
FROM SYS_APP app,
SYS_PAGE page,
SYS_APPFEATURE appf
WHERE appf.PAGE_ID=page.PAGE_ID
AND app.APP_CODE = appf.APP_CODE(+)
AND appf.Appfeature_Code= appf.Parentappfeature_Code
AND appf.APPFEATURE_CODE != 'WB_PORTAL_HOME'
AND app.APPSTATUS_CODE = 'ACTIVE'
AND app.APPTYPE_CODE = 'ASP.NET'
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -