<body oncontextmenu="return false;">
//获取客户端IP,格式:"217.199.184.144";
String userIp=request.getRemoteAddr();
ORACLE按照拼音,部首,笔画排序 http://uiiang.iteye.com/blog/312324,比如:
select distinct product as item_id, t.item_name
from sup_kc_doc_unite_info
left join sup_dict_item t on product = t.item_id
and t.nls_lang = #nlsLang#
where product_family = #itemId#
and web_site_lang = #nlsLang#
and product is not null
order by nlssort(t.item_name, 'NLS_SORT=SCHINESE_PINYIN_M') asc
oracle触发器写法:
create or replace trigger t_sup_kc_doc_basic_info_del
before delete
on SUP_KC_DOC_BASIC_INFO
for each row
begin
IF DELETING THEN
--关联删除--
delete from sup_kc_doc_unite_info t
where t.web_doc_id = :OLD.web_doc_id;
END IF;
end t_sup_kc_doc_basic_info_del;
//获取客户端IP,格式:"217.199.184.144";
String userIp=request.getRemoteAddr();
ORACLE按照拼音,部首,笔画排序 http://uiiang.iteye.com/blog/312324,比如:
select distinct product as item_id, t.item_name
from sup_kc_doc_unite_info
left join sup_dict_item t on product = t.item_id
and t.nls_lang = #nlsLang#
where product_family = #itemId#
and web_site_lang = #nlsLang#
and product is not null
order by nlssort(t.item_name, 'NLS_SORT=SCHINESE_PINYIN_M') asc
oracle触发器写法:
create or replace trigger t_sup_kc_doc_basic_info_del
before delete
on SUP_KC_DOC_BASIC_INFO
for each row
begin
IF DELETING THEN
--关联删除--
delete from sup_kc_doc_unite_info t
where t.web_doc_id = :OLD.web_doc_id;
END IF;
end t_sup_kc_doc_basic_info_del;