Categories
Adv. programming for DB apps.

FIT5059 – Adv. Prog. for DB Applications Week 2

Week 2 continue with the basics, however this week some of the power of Oracle forms was revealed. It seems that web based DB apps can be developed very quickly with Oracle form builder. I am very interested to see how the performance of this apps it. I assume that they will automatically leverage Oracle’s middleware and end up being faster than a well written program. However, some further reading shows that Oracle have some fairly detailed documents on improving performance. This suggests that it is not all just click and go when high volumes of users and performance becomes an issue (see: http://download.oracle.com/otn_hosted_doc/forms/forms/A73073_01.pdf and http://www.oracle.com/technetwork/developer-tools/forms/overview/technical-overview-130127.pdf).

The lecture and tutorial focussed on Data Block Forms (although the tutorial was wasted populating a DB from non-sql formatted word doc).

Note **OC4J Instance Program must be running to test forms.

The structure of forms can be defined as:

<Layout>
<Window>
<Canvas>
<block>
</block>
</Canvas>
</Window>
</Layout>

Everything except layout can be in multiples.

The lecture continued with very detailed tutorial on the use of datablocks.

The best way to learn that material will be to install Oracle Developer at home and tinker..

 



Leave a Reply

Your email address will not be published. Required fields are marked *