ORACLE merchant ERP

1. When you assign values to NAME pinyin codes in batches, the names containing single quotation marks will be shelled.
Update the NAME and copy it again.
UPDATE BFBHDD8.SPSB set name = concat (SBID, 'duoge invincible ') where name like' %'
2. The BFv8.0 printing template cannot be added and can only be inserted manually into the database.
3. query snapshot execution
Select job, log_user, last_date, next_date, broken, interval, failures, what from dba_jobs
4. It is easy to truncate numeric values in another EXCEL file. Refresh and resize the file before saving it.
5. dbf uses bde standard as the data source, while Oracle in OraHome92 of ODBC is used as the data destination for data import. No exception is found,
However, if the data target is replaced with ORACLE, it is found that some columns whose source values are NULL have inexplicable values. Misaligned NULL items are passed in.
6. Use DATAPUMP to import data. The Chinese characters are normal. use PowerBuilder Data Pipeline to import data. Chinese characters are garbled.
--------
-- Create a snapshot on the source server
Create table DUQL_KZ
AS
SELECT * FROM BM
Alter table DUQL_KZ
Add constraint PK_ZJ primary key (DEPTID );
1. Create a snapshot log for the table DUQL_KZ under the BFBHDD8 user on the source server;
You can perform a quick refresh in a snapshot only when you create a snapshot log for the table DUQL_KZ.
Create snapshot log on DUQL_KZ;
2. Create a database chain link_sf for the target user under the target server;
After a database chain is established to the source system, data can be obtained from the table DUQL_KZ under the source user.
Create database link DUQL_LINK
Connect to BFBHDD8 identified by DHHZDHHZ using 'jxc80'; -- JXC80 is the name of the source data service registered on the target server.
3. Create a snapshot DUQL_KZ_2 under the target user;
Create snapshot DUQL_KZ_2
Select DEPTID, BMDM, DEPT_NAME, BMQC, 'new From DUQL_KZ @ DUQL_link ORDER BY BMDM
IV,
Alter snapshot DUQL_KZ_2 refresh fast Start with sysdate + 1/1440 next sysdate + 1/144;
-- SELECT 60*24 FROM DUAL
-- 1440 incremental transfer per minute
Verify OK
Select job, log_user, last_date, next_date, broken, interval, failures, what from dba_jobs
The number of failures cannot exceed 16. The next time is not in January 1, January 1, 4000. No.