No wonder people are flocking to SQL Server. Granted, I haven't use Oracle since 8i, when I did everything with SQL Plus, but I don't even know what to make of this convoluted mess. It would be nice to get to the point I could make a table. I also barely touched SQL Server in years after 15 years of Excel Access development, but found it easy to pick up the management studio.
Oracle Express seems to lack SQL Plus, the database configuration manager I read about DBCA. I have to hit something to start the db and use a dos command like to enter SQL, after which it said I wasn't connected to a DB. And where did clusters go? Like dot net itself, Oracle just took program bloat to an obscene level.
With 15 years of SQL and data mining or modeling, I can't imagine what it would be like for a new student unfamiliar with relational concepts.
And the aps seem to want to point to web pages which are possibly a bigger mess. The way I learned relational databases was in Oracle, using SQL Plus where an SQL window could do anything. Create, drop, delete, constrain, select, insert, add keys and build relationships. Now there are 12,000 tools, 9,0000 menu options, terms that don't seem common to any other RDBMS and I have to wonder if Oracle is a enterprise system or a cult.
What, exactly do I use in express to do basic modeling? The machine I have at the job I just started doesn't have Oracle installed, so I figured I would refresh myself on it, only to find some hokey online tool? Is there an intro to SQL Express that is under 7,000 pages long?
I just want to create a few tables so I can try to ADO into it and build data mining tools from Excel. I used to be able to pull Oracle into Word tables with OO4O (Oracle Objects for OLE). Now it's become too much of a task to build a few tables in Oracle to even attempt data mining.
----------- Moderator action------------
Moved this thread to the General Database Discussion forum
Message was edited by: Timo Hahn
-----------------------------------------