Creating new schemas / users / whatever in Oracle XE
I installed Oracle XE on Fedora. Then I couldn’t figure out how to connect to it. Turns out it’s quite simple. First, …
How to install Oracle drivers without a repository
I had a project that used Oracle, but we didn’t yet have a local Maven repository set up and Tomcat was not …
Using Hibernate’s ability to create a user defined type to fix clunky Oracle CLOB code
Very helpful post over here explained how to use Hibernate’s UserType to create a custom type to override the behavior of Oracle’s …
Handy SQLPLUS Cheat Sheet
set pagesize 0 set linesize 132 format first_name column A20 format salary column $999,999.99 http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch6.htm
Oracle’s sqlplus “show tables” command?
Guess who can never remember how to do the equivalent of “show tables” in Oracle’s SQL*Plus? That’s right: Me. There’s no shorthand …
Of course, SQL*Plus is useless if you can’t connect…
Can’t connect to your Oracle database like I couldn’t all freakin’ morning? Grrr. I think what I really couldn’t connect to was …
SQL*Plus Installation made easy.
If you’ve every tried to install Oracle on any UNIX/Linux system, you know what pain is — especially if all you want …