Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Oracle8 multiple nested JOINS
Yeah I figured it out. It turns out that you do not need to nest the joins like SQL Server does. You can just throw in all of your joining parameters and Oracle figures it out. So the original code from SQL Server (in the original post) ends up in Oracle being:<br> <br> select... -
Oracle8 multiple nested JOINS
Ok, I am migrating a database from SQL Server 7.0 to Oracle8.0.5.1 Enterprise Edition on Linux. I have all the tables moved over, and now I am working on the various views that were part of the SQL Server schema.<br> <br> I have come across a massive view built from about 8 JOINS (inner, outer... -
Imp errors on 8.0.5.1 on HPUX 10.20?
I would tend to agree with Mike on the lack of swap space. I know that in Linux you can use the 'top' command to see the stats on how much swap space is being used....but I don't know if Top comes with HPUX by default, though you can certainly find it on a GNU ftp site.<br> <br> Good luck,<br>...- Pontiphex
- Post #4
- Forum: Oracle: All versions
-
Best datatype?
I need to create a table that has multiple columns that store large amounts of text. Oracle8 only handles one 'LONG' datatype per table. What is the best datatype to use in this situation?- Pontiphex
- Thread
- Replies: 3
- Forum: Oracle: All versions
