During the last week or so I’ve been going through the process of setting up an Oracle 10g database on CentOS 4.5. Rather than relying on the toads at OTN or the raving throngs of confusion at the oracle.com forums for advice. I learned everything I needed to know at Dizwell Informatics. It’s the site […]
For some reason in the latest 10g oracle download for linux they fubared the perms for the $ORACLE_HOME directory, not allowing non-oracle users to run any oracle client tools like sqlplus. Causing awesome errors like:
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
Also this completely broke oci8 […]
I was doing some work this afternoon, and I needed some sample id's from a database query, however all the data ended up being related to the same person because of the ordering of the results. There must be a better way, i want random results in my resultset.
Here's how (in oracle), order by a [...]
I am stupid, I never fully understood Oracle Subqueries. Let me give you an example, I had a really big view where I wanted to access stats of child tables based on a parent table.
For example, let's call that table checks, I wanted to know how many responses were linked to each check. We have [...]
When dealing with large numbers in oracle sometimes it can be hard to read the results from a query with no formatting in the results. I know I have misread numbers from a query many times. Well, I finally got around to looking up how to format numbers in oracle. And who knew -- TO_CHAR [...]
