Hello, I am an Oracle SQL developer, but am interested in developing complete solutions. I know, that means a lot of work/learning/research, but I was hoping I could get a little advice from the pro's!
Ideally I would like to start off with hosting a web site which can access my Oracle XE database in a user friendly interface. Eventually getting more complex as I learn the basics. I have tried APEX, and that works fine, but asking a user to access the web page by entering a port # and application ID seems a bit far fetched. I have also read a bit about LAMP, but if possible, I would like to try OracleXE instead of MySQL (I have to learn all the front end, adding research on MySQL will take that much longer!). I'm thinking of taking my spare desktop, formatting it and installing Ubuntu 9.10 + Oracle XE. Any advice on what else I may need? Apache? PHP software?
Sorry, I'm pretty naive about this stuff, so any advice would be greatly appreciated. I'm basically looking for hints as to where my research as there seem to be so many different options out there. And if possible, low cost solutions, as I don't want to spend a lot of money on licensing software which may never see a lot of public use.