Category 9 posts
Writing about Oracle.
Sometimes you might need to commit a single INSERT, UPDATE or DELETE statement and not the whole main transaction. In such a case you can use an AUTONOMOUS TRANSACTION, a feature that has…
Read articleIn Oracle you can execute hierarchical queries using some cool operators—namely CONNECT BY PRIOR and START WITH—and the pseudocolumn SYSCONNECTBYPATH. With a little imagination, you can use…
Read articleWhen you create a table, by default, the number of bytes used to represent a character in a VARCHAR2 type is 1, irrespective of the character set of the DB. This may be fine if the…
Read articleSometimes you need to execute dynamic SQL statements. Starting with Oracle8i, you can accomplish this task using the EXECUTE IMMEDIATE statement. Here are three examples of how you can take…
Read article