前臺使用者自定義效能檢視
CREATE OR REPLACE VIEW USER_CONSTRAINTS AS
SELECT owner,
constraint_name,
constraint_type,
table_name,
search_condition,
r_owner,
r_constraint_name,
delete_rule,
status,
deferrable,
deferred,
validated,
generated,
bad,
rely,
last_change,
index_owner,
index_name,
invalid,
view_related
FROM all_constraints
WHERE owner = 'TMS_TEST_DATA';
CREATE OR REPLACE VIEW USER_CONS_COLUMNS AS
SELECT owner, constraint_name, table_name, column_name, position
FROM all_cons_columns
WHERE owner = 'TMS_TEST_DATA';
create or replace view user_tab_columns as
select "OWNER","TABLE_NAME","COLUMN_NAME","DATA_TYPE","DATA_TYPE_MOD","DATA_TYPE_OWNER","DATA_LENGTH","DATA_PRECISION","DATA_SCALE","NULLABLE","COLUMN_ID","DEFAULT_LENGTH","DATA_DEFAULT","NUM_DISTINCT","LOW_VALUE","HIGH_VALUE","DENSITY","NUM_NULLS","NUM_BUCKETS","LAST_ANALYZED","SAMPLE_SIZE","CHARACTER_SET_NAME","CHAR_COL_DECL_LENGTH","GLOBAL_STATS","USER_STATS","AVG_COL_LEN","CHAR_LENGTH","CHAR_USED","V80_FMT_IMAGE","DATA_UPGRADED","HISTOGRAM"
from all_tab_columns
where 1=1 and owner='TMS_TEST_DATA';
SELECT owner,
constraint_name,
constraint_type,
table_name,
search_condition,
r_owner,
r_constraint_name,
delete_rule,
status,
deferrable,
deferred,
validated,
generated,
bad,
rely,
last_change,
index_owner,
index_name,
invalid,
view_related
FROM all_constraints
WHERE owner = 'TMS_TEST_DATA';
CREATE OR REPLACE VIEW USER_CONS_COLUMNS AS
SELECT owner, constraint_name, table_name, column_name, position
FROM all_cons_columns
WHERE owner = 'TMS_TEST_DATA';
create or replace view user_tab_columns as
select "OWNER","TABLE_NAME","COLUMN_NAME","DATA_TYPE","DATA_TYPE_MOD","DATA_TYPE_OWNER","DATA_LENGTH","DATA_PRECISION","DATA_SCALE","NULLABLE","COLUMN_ID","DEFAULT_LENGTH","DATA_DEFAULT","NUM_DISTINCT","LOW_VALUE","HIGH_VALUE","DENSITY","NUM_NULLS","NUM_BUCKETS","LAST_ANALYZED","SAMPLE_SIZE","CHARACTER_SET_NAME","CHAR_COL_DECL_LENGTH","GLOBAL_STATS","USER_STATS","AVG_COL_LEN","CHAR_LENGTH","CHAR_USED","V80_FMT_IMAGE","DATA_UPGRADED","HISTOGRAM"
from all_tab_columns
where 1=1 and owner='TMS_TEST_DATA';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29439655/viewspace-1372410/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 自定義檢視指令
- Laravel 自定義檢視元件Laravel元件
- 自定義例外 + 建立檢視
- MVC自定義檢視規則MVC
- Xamarin iOS教程之自定義檢視iOS
- PbootCMS自定義前臺404錯誤頁面boot
- 自定義MVC檢視引擎ViewEngine 建立Model的專屬檢視MVCView
- 自定義 Command 檢視 Laravel 日誌Laravel
- 自定義檢視---圓角柱狀圖(一)
- 檢視當前使用者正在等待事件事件
- AlertDialog 自定義對話方塊檢視
- 如何使用Android自定義複合檢視Android
- iOS實現自定義的彈出檢視(popView)iOSView
- Flutter - Drawer 抽屜檢視與自定義headerFlutterHeader
- 自定義提醒檢視Alert-動態繪製
- Flutter日曆2.0,支援月檢視和周檢視,可以支援自定義風格Flutter
- Xamarin XAML語言教程ContentView檢視作為自定義檢視的父類View
- 【轉】檢視Oracle當前使用者下的資訊Oracle
- Flutter自定義實現神奇的卡片切換檢視Flutter
- 使用檢視格式化來自定義SharePoint
- Oracle自定義函式檢視2個字串是否匹配Oracle函式字串
- Linux檢視和剔除當前登入使用者Linux
- 檢視當前使用者執行語句等資訊
- 檢視當前登入的使用者及其IP地址
- Android 最簡單的自定義檢視管理之一Android
- 如何將自定義XML檢視注入SAP Fiori Elements應用XML
- Android中水波紋使用之自定義檢視實現Android
- 一.CI(Codeigniter)框架自定義檢視檔案位置框架
- 關於自定義檢視容器(Container View Controller)AIViewController
- thinkphp6 使用自定義命令,生成資料庫檢視PHP資料庫
- oracle效能檢視Oracle
- MySQL資料庫檢視:檢視定義、建立檢視、修改檢視MySql資料庫
- Oracle檢視:常用動態效能檢視Oracle
- 檢視linux系統當前登陸的使用者Linux
- JXPopupView:一個輕量級的自定義檢視彈出框架View框架
- Dynamics CRM 向檢視列新增自定義圖示和提示資訊
- 檢視oracle當前sessionOracleSession
- 使用者自定義異常