- A simple example of Oracle Secure Application Role
- Example of converting physical standby database to snapshot standby databsae
- Oracle Data Guard - real time apply
- A weird problem when loading LOB file using SQL*LODER
- A weird problem when loading LOB file using SQL*LODER
- Set up physical standby db example
- Implement "read lock" using Oracle VPD
- 在通过运行脚本来安装产品数据库的时候,发现用新创建的用户在连接数据库的时候hang住了,卡了半天没有任何变化。于是手动用sqlplus来尝试下连接下,结果一样是登陆不了,session被block住了...
- Operator "OR" in SQL statement may lead to inefficient "correlated sub-query". Watch out!
- 一般来说,关联子查询的效率是比较低下的,因此在写SQL的时候尽量避免这种写法,要变成表连接的方式(有时候可能需要外连接)。一般来说关联子查询有以下两种方式....(1) 在SELECT子句中 SEL...
- Using UTL_FILE and DBMS_XSLPROCESSOR to write CLOB into files.
- Library Cache Lock could be caused by connecting to database using wrong password.
- Notes on the book -- Refactoring Database - Evolutionary Database Design
- Some issues happened when installing MySQL on windows
- Beginning with Oracle Database 11g Release 2 (11.2.0.2), you can create policies on applications tha...
- Use DBMS_SQL with caution, it can not only lead to "memory leak" issue, but also cause security issu...
- fangwen.YU 发表博客:[转载]Oracle Character set – Everything a New oracle DBA needs to know 2012-02-03 18:07Oracle Character set – Everything a New oracle DBA needs to know
- TTS is not designed to replace schema level exp/imp
- The differences between the functions that return CLOB and VARCHAR2 used in SQL statement
- Abuse of LOB in SQL is nightmare. This article gives out an example on the efficiency of LOB operati...
- using RMDIR command in windows to remove non-empty folder
- An working example that bad SQL statement causes too much CPU usage.
- Though we can set down some rules for the PL/SQL naming convention, it’s totally depending on develo...
- ORA-01795: maximum number of expressions in a list is 1000
- A simple DBMS_LOB example
- Using BAT for multi-thread/process processing
- Use Java Compiler API for arithmetic expression calculation
- Compile the Java code dynamically using JDK6
- The definition, cause, and the solution to the wait event -- buffer busy waits
- The reason causes the error ORA-12519 and the resolution










