Oracle: url
1. http://www.adp-gmbh.ch/
2. http://www.psoug.org/library.html
Date: January 2nd, 2007
exp and imp in Oracle
ref: http://www.adp-gmbh.ch/ora/admin/imp_exp.html
exp and imp in Oracle
exp and imp are the executables that allow to make exports and imports of data objects (such as tables). Therefore, logical backups can be made with exp.
exp/imp allow to transfer the data accross databases that reside on different hardware plattforms and/or on different Oracle versions. If the [...]
Oracle: 如何在 SQL 敘述中使用包含 & 字元的字串常數
ref: http://www.cine.idv.tw/Learning/ComputerScience/Database/oracle/AppNotes/appnote-59824f555728-sql-65588ff04e2d4f7f75285305542b-5b57514376845b574e325e386578/
shortie 發現 TOAD 的 SQL Editor ，會把 ‘&’ 字元後的字串，當成變數名稱，造成無法直接將欄位之值，更新為包含 ‘&’ 字元的字串…
問題描述
INSERT INTO DTBDRG (
DRG_CODE, DRG_NHI_CODE, DRG_NAME, DRG_JD_FLAG,
DRG_SPEC, DRG_UNIT, DRG_CHARACTER, DRG_TEST_FLAG, DRG_BRAND)
VALUES (
‘1CL100′, ‘A042448100′, ‘CLOPINE 100mg (Clozapine) ‘, ‘ ‘,
‘100mg ‘, ‘Tab ‘, ‘ ‘, ‘ ‘, ‘瑞士[1.2.2.1&~2]‘);
在 TOAD 中無法執行。
解決方案
這嚴格說起來並不能算是 PL/SQL 問題，而是 TOAD 的 SQL [...]