OraFAQ Forum: General » Best version of Oracle to use

Home » Other » General » Best version of Oracle to use

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Best version of Oracle to use [message #584630]

Thu, 16 May 2013 07:47

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Hello guys,

I want to design an oracle application that can use a database in a server.

My OS is windows vista so what is the most suitable and easy to use:

1- database?
2- database designer?
3- oracle forms developer?
4- oracle reports developer?

and where can I download them from?

Thank you for your help in advance.

Report message to a moderator

Re: Best version of Oracle to use [message #584635 is a reply to message #584630]

Thu, 16 May 2013 08:08

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

The answer is always "the latest version that is certified with your configuration." I am sorry, for some reason I cannot find the link to the certification matrix.

http://download.oracle.com for software. It is for personal use. If you really want to have an application, you will need to pay for the software.

Report message to a moderator

Re: Best version of Oracle to use [message #584646 is a reply to message #584635]

Thu, 16 May 2013 09:15

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Thank you joy for your reply. Can anyone please give me the link to downlaod the 4 software above? Or at least thier exact name?
Thank you.

Report message to a moderator

Re: Best version of Oracle to use [message #584647 is a reply to message #584646]

Thu, 16 May 2013 09:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.oracle.com/technetwork/indexes/downloads/index.html

Report message to a moderator

Re: Best version of Oracle to use [message #584651 is a reply to message #584647]

Thu, 16 May 2013 09:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What kind of an application do you plan to develop?

Report message to a moderator

Re: Best version of Oracle to use [message #584653 is a reply to message #584647]

Thu, 16 May 2013 09:56

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Thank you for your reply, BlackSawn.

Report message to a moderator

Re: Best version of Oracle to use [message #584655 is a reply to message #584651]

Thu, 16 May 2013 09:58

TwoWays
Messages: 14
Registered: May 2013

Junior Member

I want to develop a database application using oracle forms and reports.

Report message to a moderator

Re: Best version of Oracle to use [message #584658 is a reply to message #584655]

Thu, 16 May 2013 09:59

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Is my question not clear enough to understand?

Report message to a moderator

Re: Best version of Oracle to use [message #584659 is a reply to message #584658]

Thu, 16 May 2013 09:59

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Guys, is this what I want as described in my original post? Someone please help.

1- Oracle Database 11g Express Edition
http://www.oracle.com/technetwork/products/express-edition/downloads/index.html

2- Oracle SQL Developer 3.2.2 (3.2.20.09.87)
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

3,4-Oracle Forms and Reports 11g Release 2
http://www.oracle.com/technetwork/developer-tools/forms/downloads/index.html

Report message to a moderator

Re: Best version of Oracle to use [message #584660 is a reply to message #584659]

Thu, 16 May 2013 10:01

TwoWays
Messages: 14
Registered: May 2013

Junior Member

If there are other better and easy options to use then please someone let me know.

Thanks to all who try to help.

Report message to a moderator

Re: Best version of Oracle to use [message #584665 is a reply to message #584660]

Thu, 16 May 2013 12:13

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Software you specified 2 messages above seem to be OK (at least, database & SQL Developer are. I don't use Forms 11g so I can't tell for sure, but yes - they are part of Fusion Middleware now).

As of "better and easy options to use", you failed to answer my previous question, so I'll repeat it: what kind of an application do you plan to develop? What will it do? What kind of information will it deal with? Because, it is like the following dialogue:
- you: I want to travel
- me: what kind of a travel is it going to be?
- you: such that I'll move from here to there
- me: OK, take a bike
- you: right, but it is too far to go there by bike
- me: take a car, then
- you: no, you didn't understand, I want to go to the Moon
- me: so you'll need a rocket

Got the idea? Depending on WHAT you want to do, we could suggest a TOOL to do that. Just like BlackSwan uses to say: While a hammer is a fine tool, it is a suboptimal choice when the task is to make 2 pieces of lumber from 1 board.

Report message to a moderator

Re: Best version of Oracle to use [message #584668 is a reply to message #584665]

Thu, 16 May 2013 12:32

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Ok, littlefoot

The idea is to learn by myself but I want it to be similar to reality. I want to develop a storage database that can be used by 5-10 users at the same time. I plan to create a main form with menu then move to another forms which save the details of the store including getting its site on the map in the same form by intering its GPS details. something like a form and subforms, search the stores data ...etc. Also, I want to be able to save attachements in the database through the forms. Baisically, like any database application.

I hope you got me now Smile

Smile

Report message to a moderator

Re: Best version of Oracle to use [message #584672 is a reply to message #584668]

Thu, 16 May 2013 12:58

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

As mentioned previously, you will have to purchase the software to do this since you plan on making it a multi-user system.

Installing all those products is a rather large undertaking. Database, probably straightforward. Application server (aka. Fusion Middleware), not. I wish you luck, because I had a heck of a time with 10g application server configuration.

Report message to a moderator

Re: Best version of Oracle to use [message #584683 is a reply to message #584672]

Thu, 16 May 2013 14:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Forms, along with the Web Logic server, might be an overkill for such an application (besides, it costs money. A lot of money).

Have a look at Application Express; it is already pre-installed with 11g Express Edition database (so you don't even have to install anything but the database itself). Moreover, it is free (costs NO money).

Report message to a moderator

Re: Best version of Oracle to use [message #584689 is a reply to message #584683]

Thu, 16 May 2013 16:47

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Thank you both Joy and Littlefoot for your insights. Litllfoot, can I develop a multi-user system with the application Express?
Thanks agian.

Report message to a moderator

Re: Best version of Oracle to use [message #584711 is a reply to message #584689]

Fri, 17 May 2013 01:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Yes, no problem.

Report message to a moderator

Re: Best version of Oracle to use [message #584751 is a reply to message #584683]

Fri, 17 May 2013 07:17

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Littlefoot, You said the Application Express is already pre-istalled with 11g Express Edition database but when I installed the database I couldn't find the Application Express in the menu!!

What should I do?

Report message to a moderator

Re: Best version of Oracle to use [message #584754 is a reply to message #584751]

Fri, 17 May 2013 07:37

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Littlefoot, just another question, can I create forms and reports with the Application Express?

Thanks,

Report message to a moderator

Re: Best version of Oracle to use [message #584755 is a reply to message #584754]

Fri, 17 May 2013 07:43

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

TwoWays

What should I do?

Read the documentation? (Accessing Oracle Application Express from the Database Home Page)

TwoWays

can I create forms and reports with the Application Express?

Yes; though, reports (if you want to print them) aren't pretty. There are (free) reporting tools that work fine with Apex, such as iReport. Dietmar Aust wrote guidelines so that you'd easily integrate Apex with Jasper Reports (i.e. iReport).

[Updated on: Fri, 17 May 2013 07:44]

Report message to a moderator

Re: Best version of Oracle to use [message #584766 is a reply to message #584755]

Fri, 17 May 2013 08:55

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Thanks for your reply, Littlefoot. Do I still need the "SQL Developer" or can I create tables, views and relations with APEX?

Report message to a moderator

Re: Best version of Oracle to use [message #584767 is a reply to message #584766]

Fri, 17 May 2013 09:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Both can do that job, but SQL Developer is much more powerful.

Report message to a moderator

Re: Best version of Oracle to use [message #584844 is a reply to message #584672]

Sun, 19 May 2013 13:33

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Hello Joy, Littlefoot,

Can I use Oracle Developer Suite 10g (10.1.2.0.2) to create forms and reports bearing in mind that I have already downloded the Oracle Database 11g Express Edition?

Is it free? And does this link http://www.youtube.com/watch?v=hs8jpRklez4 explain the way to do it?

Thanks a lot.

Report message to a moderator

Re: Best version of Oracle to use [message #584845 is a reply to message #584844]

Sun, 19 May 2013 13:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, Forms 10g will work OK with 11g XE database.

It is free ONLY for your personal use. As you explained earlier, you'd want to create an application which will be used by several people. In that case, you have to pay for the the licence. How much? No idea, contact Oracle.

Youtube: yes, it explains some aspects. Regarding its length (7 minutes), these are only basics (but might get you started).

Report message to a moderator

Re: Best version of Oracle to use [message #584848 is a reply to message #584845]

Sun, 19 May 2013 13:53

TwoWays
Messages: 14
Registered: May 2013

Junior Member

Thanks for your quick reply. I like forms 10g because it looks similar to to orcle developer 8i which I used to use. Can I create reports with Oracle Developer Suite 10g?

Report message to a moderator

Re: Best version of Oracle to use [message #584849 is a reply to message #584848]

Sun, 19 May 2013 13:54

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There's no "developer 8i", never was.

Developer suite contains both Forms & Reports, so - yes, you can create reports.

Report message to a moderator

Previous Topic:	Tools suggestion needed for static code analysis
Next Topic:	General

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 05:31:46 CST 2024