IN 1..100 LOOP INSERT INTO Loans (LoanID, CustomerID, BranchID, LoanType, Amount, InterestRate, StartDate, EndDate) VALUES (i, i, MOD(i, 10) + 1, CASE MOD(i, 2) WHEN 0 THEN 'Home' ELSE 'Car' END, DBMS_RANDOM.VALUE(5000, 50000), DBMS_RANDOM.VALUE(3, 15), SY...
While querying against a database link, got below error. select sysdate from dual@DB5 * ERROR at line 1: ORA-02020: too many database links in use CAUSE & SOLUTION: open_linksparameter control, the number of database links each session can use without closing it. If you access a datab...
There is a mismatch between used space in the disk directory and the actual used space. This is a known issue in pre 11.2 asm-compatible diskgroups (where Used Space Directory does not exist). This is possible because we batch the update to used space in disk directory. So, if we perfor...
delete noprompt obsolete; delete noprompt backup of database completed before 'sysdate - 31'; release channel ch1; } exit EOF 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 测试备份成功! --- 生产系统需要导出数据到一个NFS目录下...
In this mode all input parameters are checked for validity, new ones are added if necessary, and redundant parameters are deleted. Thus you do not have to take care about quantity of items in OracleCommand.Parameters collection, you can specify only the ones you really need. The ...
Oracle Database Cloud Exadata Service - Version N/A and later Information in this document applies to any platform. ***Checked for relevance on 24-Aug-2017*** PURPOSE The Purpose of this document is to have a checklist for troubleshooting ORA-01552 error when using Manual Undo Management . ...
The decode function can be used in SQL for and IF-THEN-ELSE construction. It's an alternative for the CASE statement which was introduced in Oracle 8. Syntax: decode( expression , compare_value, return_value, [,compare, return_value] ... [,default_return_value] ) ...
Identify workload dependency with system time– If the source workload has a large number of SQLs referring to SYSDATE, thereby having dependency on the system time, it’s important to reset the system clock back to the point in time of the start of the capture. The decision of...
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options sh@orcl>select sysdate from dual; SYSDATE --- 25-JUN-09 sh@orcl>ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY/MM/DD'; Session alte...
INSERT INTO employee_audit VALUES (:old.id, SYSDATE, :old.name, :new.name); COMMIT; END; CREATE OR REPLACE TRIGGER trig_rollback AFTER UPDATE OF name ON employees FOR EACH ROW BEGIN INSERT INTO employee_audit VALUES (:old.id, SYSDATE, :old.name, :new.name); ...