Oracle GUI Clients
If you search for Oracle GUI Clients in Google, you turn up with nothing. After some more hunting, I found TOAD. I have been using the Free version of TOAD
Gripe 3, 4 with Oracle – concat + magic quotes
Concat: Most of the database queries I run at some point are used to generate HTML and rather than go through the results of the query and add HTML to
Continue readingGripe 3, 4 with Oracle – concat + magic quotes
Gripe 2 with Oracle – Additional Columns in Group By
In the MySQL world, I can do this: select a, b, c, max(d) from e group by a In the oracle world that results in: ORA-00979: not a GROUP BY
Continue readingGripe 2 with Oracle – Additional Columns in Group By
Gripe 1 with Oracle – Pagination with queries.
Two months ago I moved to the Department of Procurement Services at the University of Virginia. Now I get to use Oracle for the first time and it is an
Continue readingGripe 1 with Oracle – Pagination with queries.
FP!
Welcome, I plan to use this site to blog about stuff that doesn’t really fit on other blogs I run, that are focussed on their own topics – Personal Finance