Greetings all,

I have an upcoming project where the customer requires an ORACLE 10g backend. Coming from an Ms-SQL backgorund, I thought if you could have any pointers or advice that I should consider. Also, if anyone could recommend a good ORACLE book that will show how to build the database, tables, relations, views, stored-procs... (handle typical SQL tasks in ORACLE)

OMAR

omar wrote:

Also, if anyone could recommend a good ORACLE book that will show how to build the database, tables, relations, views, stored-procs... (handle typical SQL tasks in ORACLE)

You'll need a whole book on each

Get yourself a good enterprise manager type tool, [urldescriptionm="TOAD"]http://www.toadsoft.com/[/url] is pretty good (and free).

Step one, get TOAD from Quest Software.

http://www.quest.com/toad/

Using the native Oracle tools are like fighting a sumo wrestler. TOAD is very complete and not unattractive. There are versions for mysql and MS-SQL also, but I've not used those.

From the website:

"Toad for Oracle is a powerful, low-overhead tool that makes database and application development faster and easier and simplifies day-to-day administration tasks. Whether you are a PL/SQL developer, application developer, DBA or business analyst, Toad for Oracle offers specific features to make you more productive than ever before. Plus, Toad for Oracle now supports more SQL commands than any third-party tool in the industry."

It's true.

There's a freeware version available:

http://www.toadsoft.com/index.htm

Freaky. Same recommendation within moments of each other...

Ha ha ha ha ha.

Boy, I used to criticize MS for the quality of their front-end tools. They've gotten a lot better over the years.

Recently I had to work on a project with an Oracle back-end. For the first time in oh so many years, I had to install Oracle on a server in my office and work with it.

God help us.

It's huge. There is an installer that wants to install 70 different "components". But you have no guidance on which ones you can safely not install. So on they all go.

The native tools are written in Java! Oh they are so user-friendly! And so fast!

Yeah, get some 3rd party tool, that's my advice. Make sure you have plenty of disk space.

Ugh.

Jim, indeed, once you've worked with the tools for Oracle and DB2 (which are even worse than Oracle) you know how great query analyzer is and how easy enterprise manager works.

Ooooo, don't get me started on Oracle tools...!

The Oracle migraton workbench is also good for getting a ms sql db into oracle....might hepl you