In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-22 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
-- DROP SEQUENCE SEQ_P_ENTERHALLLEADFLOW_CODES
CREATE SEQUENCE SEQ_P_ENTERHALLLEADFLOW_CODES START WITH 1 CACHE 100
CREATE OR REPLACE TRIGGER tri_1 BEFORE INSERT ON P_ENTERHALLLEADFLOW_CODES FOR EACH ROW WHEN (NEW.ID IS NULL)
BEGIN
SELECT SEQ_P_ENTERHALLLEADFLOW_CODES.NEXTVAL INTO: NEW.ID FROM DUAL
END
/
Sqlldr sh20000_wx/sh20000_wx log=1.log bad=1.bad discard=dis.log control=1.ctl
LOAD DATA
INFILE '1.text'
INFILE "2.txt"
APPEND
INTO TABLE P_ENTERHALLLEADFLOW_CODES
Fields terminated by ","
TRAILING NULLCOLS
(
ID "SEQ_P_ENTERHALLLEADFLOW_CODES.NEXTVAL"
LEAD_CODE
Isvalid FILLER
)
CREATE INDEX IDX_lead_code ON P_ENTERHALLLEADFLOW_CODES (lead_code) tablespace TSH10000_WX
Sqlldr tt/tt log=1.log bad=1.bad discard=dis.log control=11.ctl
Dos2unix
= =
# crm start #
#
# interface
Rm-f de_bst_interface.txt
Cat / oradata2/share_interface/hmbst/in/97SI*.txt > de_bst_interface.txt
Mv / oradata2/share_interface/hmbst/in/97SI*.txt / oradata2/share_interface/hmbst/arch
Sqlldr userid=add114/add114 control=de_bst_interface.ctl log=log/de_bst_interface_$TIME.log errors=1000 bad=de_bst_interface_$TIME.bad
#
# details
Rm-f de_bst_details.txt
Cat / oradata2/share_interface/hmbst/in/97SD*.txt > de_bst_details.txt
Mv / oradata2/share_interface/hmbst/in/97SD*.txt / oradata2/share_interface/hmbst/arch
Sqlldr userid=add114/add114 control=de_bst_details.ctl log=log/de_bst_details_$TIME.log errors=1000 bad=de_bst_details_$TIME.bad
#
# bad
Cp de_bst_interface*.bad / oradata2/share_interface/hmbst/bad
Cp de_bst_interface*.bad / oradata2/share_interface/hmbst/arch
Rm-f de_bst_interface*.bad
Cp de_bst_details*.bad / oradata2/share_interface/hmbst/bad
Cp de_bst_details*.bad / oradata2/share_interface/hmbst/arch
Rm-f de_bst_details*.bad
#
# crm end #
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.