Re: Newbie Question:Best development language

Thanks Mark,

I guess I'm still a little confused about where to use pl/sql instead
of java. The messages I have read so far seem to indicate that
procedures are faster in pl/sql. Furthermore, I'm wondering if this
speed difference is also noticeable between pl/sql and .net procedures.

I realize that the choice of which development tool is highly
subjective. Its like being a kid in the candy store for the first time
- I have a nickel but which candy do I choose.

Cheers

Willem

Mark D Powell wrote:
swaxolez wrote:
I haven't seen many comparisons of late in this newsgroup between using
.Net, Java or PL/SQL or a mixture of any or all of them. I am mostly a
C programmer with a rudimentary knowledge of Java and VB.

I'm about to setup my first major Oracle database and need to do quite
a lot of record manipulation i.e. compute time difference between
records with a matching field, xml export and a user friendly
customized GUI.

I'm ashamed to admit I have come from the MS-Access world but although
Access has too many limitations to note it does have a pretty slick
interface and programming side for manipulating data.

Look forward to hearing some opinions on this matter.

Thanks

The "best" programming language for the job is highly subjective. The
correct answer probably depends on the task to be done, the time
available, and the existing knowledge level of the available tools
allowing for a context specific response as opposed to a purely
theoretical response.

Any final result is likely to be a combination of front-end tool HTML
from web development tool, Java or .net, and pl/sql (or T-SQL) in the
database depending on the backend database in use.

Oracle performs date math and timestamp math in a fairly straight
forward manner. The date plus 10.t is ten days and 12 hours into the
future, etc...

HTH - Mark D Powell -

.

Relevant Pages

  • Re: Why use Java Stored Procedures....
    ... a different database or have a PL/SQL programmer migrating PL/SQL stored ... procedures to a foreign language for a different database? ... What database, except Oracle, comes with Java as a native language? ...
    (comp.databases.oracle.server)
  • Re: Python vs. PL/SQL for Oracle work
    ... something in the database, PL/SQL is definitely the right choice. ... What about Java? ... Canada-wide Oracle training and consulting ...
    (comp.databases.oracle.server)
  • Re: Why use Java Stored Procedures....
    ... PL/SQL is 100% Oracle-centric while Java is not. ... If you did not take advantage of Oracle capabilities, ... Java in the database isn't transparent. ...
    (comp.databases.oracle.server)
  • Re: Why use Java Stored Procedures....
    ... PL/SQL is 100% Oracle-centric while Java is not. ... If you did not take advantage of Oracle capabilities, ... I want deep and specific DBMS expertise if I want a well-running ...
    (comp.databases.oracle.server)
  • Re: Why use Java Stored Procedures....
    ... PL/SQL is 100% Oracle-centric while Java is not. ... If you did not take advantage of Oracle capabilities, ... Would you rather have a Java programmer migrating Java stored procedures to ...
    (comp.databases.oracle.server)