Skip to Main Content

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Fahd.

Asked: December 07, 2014 - 11:07 am UTC

Last updated: December 17, 2014 - 6:30 pm UTC

Version: 10g

Viewed 1000+ times

You Asked

Hi Tom,

We are a small Software company. We are going to develop an application based on Oracle Database & Form Reports 10g. Users of application will be on 10 different physical locations. Each location will have 20-30 users.

Give us some guide line to follow,
so that Our application
run,
run correctly, efficiently
run for a log time.

We mean that we could be able to build a successful Application.

Thanks
Fahd

and Tom said...

Read the concepts guide (free on otn.oracle.com)
Read the 2day application developers guide (the same)
Read the application developers guide (same)

Understand the above three and you'll be a long way there

The most important one however will be:

Get a mentor involved, hire onto the team someone with experience building successful forms applications. Learn from them


Consider a more pure 3-tier environment - APEX (application express) if you like PLSQL as the programmming language. Less deployment issues with something like that and it comes with the database. See http://apex.oracle.com/ to give it a test drive.

Use bind variables for security reasons and definitely for all OLTP applications.

Consider not binding for a warehouse/big report query. But watch out for sql injection.

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Welcome Back

A reader, December 09, 2014 - 10:14 pm UTC

Tom,

Welcome back! Are you back to answer questions on your site.

I was wondering where you have been gone all that time.

Hope you are staying healthy.

Good to see you again. I certainly missed you.


Sam
Tom Kyte
December 10, 2014 - 11:06 am UTC

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:8738293400346218531

Not 10g

Bill C, December 11, 2014 - 12:37 pm UTC

Along with Tom's excellent advice if you are set on forms and reports do not use 10g but rather 11g.

Why not 10g

Fahd Bahoo, December 13, 2014 - 6:22 am UTC

Hi Bill C, why not 10g ? can you explain ?
Tom Kyte
December 17, 2014 - 6:30 pm UTC

because current software is supported, has more to offer, works in more situations (newer OS's and current patches) and so on.

The same reason you don't want to start your build on Windows XP in the year 2014.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.