IT 專業技術分享

問題 :   在 Debug TRIGGER 時，若點到欄位名稱如： :OLD.COL1    或 :NEW.COL1 時，就會一直處理忙碌狀態後就 timeout    且必需關閉 TOAD 再重新連線資料庫，這是否也是有什    麼設定要調整 ? 原因 :    這主要是 oracle cursor  的行為引起的      請參考網址       http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/06_ora.htm#36656 解決方法 :      需宣告兩個變數去接 old.  和   new.  的值    declare     vOldValue table_name.column_name%type;     vNewValue table_name.column_name%type;    begin     vOldValue := :old.column_name;     vNewValue := :new.column_name;     ...    end;

Many friends are asking, if you want to migrate from Oracle to other Database, what should I do? In fact, EDB is a good solution, I hope this article helps you understand how to be compatible with Oracle database. 1.   Preinstallation Step 1. Please download and install JDk 1.7.      Step 2. Please download JDBC driver for Oracle. http://www.enterprisedb.com/downloads/third-party-jdbc-drivers      Step 3. Please put ojdbcxx.jar file to $JAVA_HOME\jre\lib\ext. 2.Begin to install EDB postgres Advanced Server      Step 1. Download and Unzip installation file.       https://www.enterprisedb.com/legal/document/terms-and-conditions?destination=node/19                                                 Important Step!!Please choose Compatible with Oracle.      Step 2. Install EDB option package. 3.   Check res