?? user_app_v.sql
字號:
CREATE OR REPLACE VIEW USER_APP_V AS
SELECT usr.user_id,usr.user_code,app.app_id, app.app_code, app.appdesc, '' as page_code, '' as pagePath,
'' as patch_code
FROM SYS_USER usr,
SYS_APP app,
(SELECT DISTINCT a.appGroup_ID, b.app_Code
FROM SYS_APPGROUP_FEATURE a,
SYS_APPFEATURE b
WHERE a.AppFeature_Code = b.AppFeature_Code
AND a.IsValid = 'Y'
AND b.IsValid = 'Y') apc
WHERE usr.AppGroup_ID = apc.AppGroup_ID
AND app.App_Code = apc.App_Code
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -