Beginning Oracle, PL/SQL Programming?
I have spent a few years doing more functional programming (and concurrent programming) than Object oriented. I  have so been glued to <code><b><a href="http://en.wikipedia.org/wiki/Mnesia">Mnesia DBMS</a></b></code> which comes bundled in the <b><a href="http://erlang.org/">Erlang/OTP System from Ericsson</a></b>.<br><br> Also, we have used <b><a href="http://www.mysql.com/cluster/">MySQL Cluster Storage</a></b> for handling Large Data sets behind Mnesia Nodes which handle temporary, live information. The architectures we have in place are so far stable. However, in a recent project, suggestions of kicking in Oracle were common place because of its stability and massive support. Oracles product, Times Ten In-Memory Database is being used too, in building Telecom systems. Erlang/OTP works very well with MySQL and MySQL Cluster Products because it provides ODBC libraries and numerous sql drivers.<br>
Mnesia does create In Memory Databases that are efficient. Recently, i downloaded and installed <code>Oracle Times Ten In-Memory Database</code>. Now basing on that simple introduction, here the main body comes...<br><br>In the recent project we have worked on, we used mnesia for holding distributed session data in Main Memory. Mnesia's performance is good so far, but our users are increasing in number. In the future, we may need to have several options for in-Memory Storage. We may also need to compare the performance of our existing solution with the one that Oracle Times Ten may give to us. I would like to see and experiment with the performance of Oracle Times Ten, so that in a future project i can make informed decisions based on an experience of the two DBMS. <br><br>I have it running and i would like to get started with <code>PL/SQL</code>, its Query Language. Where would an Oracle newbie start from, especially concerning the selection of database (11g, 10g, 9i, e.t.c.) and PL/SQL in particular? Any sites, pdfs, tutorials for a PL/SQL beginner will be very helpful. Also, provide some highlights on the several options of accessing data (writing, reading, updating and deleting) with Oracle databases from different application memory space (Database Connections, Pipes e.t.c), in general (basing on my Mnesia and MySQL background)<br><br> thanks in advance
Beginning Oracle, PL/SQL Programming?
===

I have spent a few years doing more functional programming (and concurrent programming) than Object oriented. I  have so been glued to <code><b><a href="http://en.wikipedia.org/wiki/Mnesia">Mnesia DBMS</a></b></code> which comes bundled in the <b><a href="http://erlang.org/">Erlang/OTP System from Ericsson</a></b>.<br><br> Also, we have used <b><a href="http://www.mysql.com/cluster/">MySQL Cluster Storage</a></b> for handling Large Data sets behind Mnesia Nodes which handle temporary, live information. The architectures we have in place are so far stable. However, in a recent project, suggestions of kicking in Oracle were common place because of its stability and massive support. Oracles product, Times Ten In-Memory Database is being used too, in building Telecom systems. Erlang/OTP works very well with MySQL and MySQL Cluster Products because it provides ODBC libraries and numerous sql drivers.<br>
Mnesia does create In Memory Databases that are efficient. Recently, i downloaded and installed <code>Oracle Times Ten In-Memory Database</code>. Now basing on that simple introduction, here the main body comes...<br><br>In the recent project we have worked on, we used mnesia for holding distributed session data in Main Memory. Mnesia's performance is good so far, but our users are increasing in number. In the future, we may need to have several options for in-Memory Storage. We may also need to compare the performance of our existing solution with the one that Oracle Times Ten may give to us. I would like to see and experiment with the performance of Oracle Times Ten, so that in a future project i can make informed decisions based on an experience of the two DBMS. <br><br>I have it running and i would like to get started with <code>PL/SQL</code>, its Query Language. Where would an Oracle newbie start from, especially concerning the selection of database (11g, 10g, 9i, e.t.c.) and PL/SQL in particular? Any sites, pdfs, tutorials for a PL/SQL beginner will be very helpful. Also, provide some highlights on the several options of accessing data (writing, reading, updating and deleting) with Oracle databases from different application memory space (Database Connections, Pipes e.t.c), in general (basing on my Mnesia and MySQL background)<br><br> thanks in advance