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> |
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:
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 =
select COLUMN_NAME, COMMENTS
from ALL_COL_COMMENTS
where TABLE_NAME =
Subscribe to:
Posts (Atom)