Home » Other » General » How to learn oracle dev
How to learn oracle dev [message #574415] Thu, 10 January 2013 03:42 Go to next message
radiator91
Messages: 6
Registered: January 2013
Junior Member
Hi All,

I am looking to work as a oracle developer but the positions generally need forms, reports and pl/sql. I have pl/sql but not the rest. Could someone advise what I need (free versions of required components) to install on a 64bit windows 7 machine to get started coding? I guess I should ask first if it is possible to dev on win 7?

Thanks for reading - any help appreciated.
Re: How to learn oracle dev [message #574419 is a reply to message #574415] Thu, 10 January 2013 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can download all Oracle products at OTN Downloads.

Regards
Michel
Re: How to learn oracle dev [message #574424 is a reply to message #574419] Thu, 10 January 2013 04:08 Go to previous messageGo to next message
radiator91
Messages: 6
Registered: January 2013
Junior Member

Thanks for the prompt response - appreciated.

I'm stuck as to what components I need. I've googled the requirements but it is not clear. Is there a guide as to what is needed and how to install?

Thanks again.



[Edit MC: remove complete quote of previous post]

[Updated on: Thu, 10 January 2013 05:21] by Moderator

Report message to a moderator

Re: How to learn oracle dev [message #574425 is a reply to message #574424] Thu, 10 January 2013 04:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Developer suite 10g (DS) contains Forms and Reports.

I suppose you already have a database; if not, Express Edition would be just fine. So, install a database, then install Developer Suite.

I don't run DS on Windows 7, but on a virtual machine which runs under Windows XP so I can't tell much from my own experience. If you search the forum (and use Google) (keywords: forms 10g windows 7), you'll see what people do and say about it.
Re: How to learn oracle dev [message #574427 is a reply to message #574425] Thu, 10 January 2013 04:38 Go to previous messageGo to next message
radiator91
Messages: 6
Registered: January 2013
Junior Member
Littlefoot wrote on Thu, 10 January 2013 10:13

I suppose you already have a database; if not, Express Edition would be just fine. So, install a database, then install Developer Suite.


Thanks for this.

I don't have a DB but Michel Cadot directed me to VM based packages. One is Database App Development VM which includes 11g R2 enterprise edition. Would it be OK to install this VM package then the version of DS you suggested?

There's lots of components out there which leave me overwhelmed and it doesn't help that I haven't seen forms or reports (not sure if they are even called this anymore).

I enjoyed pl/sql and would like another job in it. But I have to learn forms and reports so just need the most basic environment that will allow me to follow tutorials.

Thanks again

[EDITED by LF: fixed quote tags]

[Updated on: Thu, 10 January 2013 04:52] by Moderator

Report message to a moderator

Re: How to learn oracle dev [message #574428 is a reply to message #574427] Thu, 10 January 2013 04:51 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
These pre-built virtual machines run under Linux which I don't know so any kind of maintenance would cause quite a lot of pain for me. But, if you do know Linux, go on. I suppose it would be OK (I mean, to install one of pre-built virtual machines), especially the one you mentioned (Database App Development VM).

That VM contains some components you aren't interested in (at the moment, that is), such as JDeveloper and Application Express. Developer Suite I suggested contains Forms & Reports ver. 10g. The newest version (11g) is not any more a standalone product, but is part of Fusion Middleware. I never used that either, so ... I can't assist with that piece of software.

[Updated on: Thu, 10 January 2013 04:52]

Report message to a moderator

Re: How to learn oracle dev [message #574430 is a reply to message #574428] Thu, 10 January 2013 05:02 Go to previous messageGo to next message
radiator91
Messages: 6
Registered: January 2013
Junior Member

Appreciated thanks.

OK, I'm going to go with your suggestion (express DB and DS). Which express version should I go with?

I have virtualbox installed, which OS should I install for this?

Thanks again - feel nearer to resolving this now.



[Edit MC: remove complete quote of previous post]

[Updated on: Thu, 10 January 2013 05:20] by Moderator

Report message to a moderator

Re: How to learn oracle dev [message #574431 is a reply to message #574430] Thu, 10 January 2013 05:14 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's only one XE - 11g R2.

As of VM's operating system: I use MS Windows XP SP 3.
Re: How to learn oracle dev [message #574433 is a reply to message #574431] Thu, 10 January 2013 05:18 Go to previous messageGo to next message
radiator91
Messages: 6
Registered: January 2013
Junior Member

That's great - cheers.

One last question. Would I be able to program pl/sql with this solution? If so, what editor is used? (i have used toad before)



[Edit MC: remove complete quote of previous post]

[Updated on: Thu, 10 January 2013 05:20] by Moderator

Report message to a moderator

Re: How to learn oracle dev [message #574434 is a reply to message #574433] Thu, 10 January 2013 05:21 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use any tool you want; TOAD if you have it. SQL*Plus, Oracle SQL Developer ...
Re: How to learn oracle dev [message #574435 is a reply to message #574433] Thu, 10 January 2013 05:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do not completely quote the post your answer.
If there is some part you want to emphasize, please do it, otherwise it just increases the size of the topic for nothing.

Regards
Michel
Re: How to learn oracle dev [message #574438 is a reply to message #574435] Thu, 10 January 2013 05:46 Go to previous messageGo to next message
radiator91
Messages: 6
Registered: January 2013
Junior Member
Thanks for the help.

I'm looking for training resources now and come across - Oracle Forms Developer The Complete Video Course. It looks a little out dated and wonder if anyone can suggest better?
Re: How to learn oracle dev [message #574445 is a reply to message #574438] Thu, 10 January 2013 07:19 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What does "outdated" mean? I guess that - for beginning - that should be good enough to teach you basics.
Previous Topic: Accounting Information System
Next Topic: Database SE1
Goto Forum:
  


Current Time: Thu Mar 28 11:25:04 CDT 2024