Tuesday, December 23, 2008

Useful Articles on Oracle

Useful Articles on Oracle Cast function -
http://www.psoug.org/reference/cast.html

Performing DML with Collections
1. http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28371/adobjcol.htm#sthref483
2. http://www.psoug.org/reference/collections.html

Answers to my question on whether or not its possible to perform DML on Oracle collections (in combination with Cast)
1. http://www.orafaq.com/forum/t/137485/133715/
2. http://forums.oracle.com/forums/thread.jspa?messageID=3176984

Some Notes on Joins & their syntaxes in Oracle
1. http://oreilly.com/catalog/orsqlpluspr2/chapter/ch01.html

Some articles on Oracle Explain Plan and how to generate/read/understand it
1. http://www.adp-gmbh.ch/ora/explainplan.html
2. http://www.adp-gmbh.ch/ora/sql/join/join_methods.html
3. http://download-uk.oracle.com/docs/cd/B12037_01/server.101/b10752/ex_plan.htm

Some articles on Oracle Global Temp Tables (GTT)
1. http://www.dbasupport.com/oracle/ora8/page2.shtml
2. http://www.dba-oracle.com/t_temporary_tables_sql.htm

On Oracle Memory Usage
http://www.dbasupport.com/oracle/ora11g/memory_usage.shtml

No comments:

Post a Comment