Labels

.net (1) *nix (1) administration (1) Android (2) Axis2 (2) best practice (5) big-data (1) business-analysis (1) code re-use (1) continuous-integration (1) Cordova-PhoneGap (1) database (2) defect (1) design (3) Eclipse (7) education (1) groovy (2) https (2) Hudson (4) Java (1) JAX-RS (2) Jersey (3) Jetty (1) localization (1) m2eclipse (2) MapForce (1) Maven (12) MySQL (1) Nexus (4) notes (4) OO (1) Oracle (4) performance (1) Perl (1) PL/SQL (1) podcast (1) PostgreSQL (1) requirement (1) scripting (1) serialization (1) shell (1) SoapUI (1) SQL (1) SSH (2) stored procedure (1) STS (2) Subclipse (1) Subversion (3) TOAD (3) Tomcat (4) UML (2) unit-testing (2) WAMP (1) WAS (3) Windows (3) WP8 (2) WTP (2) XML (4) XSLT (1)

Friday, June 18, 2010

Free TOAD versus SQuirreL SQL Client

One of the things that require me to use Windows is the lack of availability of TOAD on Linux.  I am evaluating the Java tool Squirrel SQL Client to see how it stacks up for Oracle development:



Free TOAD SQuirreL SQL Client
DDL The Script tab shows referential integrity constraints, comments on columns, in addition to the usual CREATE TABLE DDL Evaluating ...
Auto-completion of SQL Doesn't work with usual Ctrl+space keyboard short-cut Works well
"Bookmark favorite" tables Evaluating ... Evaluating ...
DDL The Script tab shows referential integrity constraints, comments on columns, in addition to the usual CREATE TABLE DDL Evaluating ...
<placeholder> <placeholder> <placeholder>

Thursday, June 17, 2010

Getting comments on Oracle tables

If your Oracle tool doesn't support pulling the comments for tables you are accessing, try this SQL:

select COLUMN_NAME, COMMENTS
from ALL_COL_COMMENTS
where TABLE_NAME =