When I’m doing demonstrations of Oracle SQL Developer, I’m frequently asked about our support for datatypes like XML, BLOBS, Timestamp, etc. When I’m put on the spot like that, I have a tendency to forget that I already have tables setup for this. So I end up writing a query (more...)
The Oracle SQL Developer family currently has two ‘SQL Developer’ branded products:
- Oracle SQL Developer
- Oracle SQL Developer Data Modeler
Oracle SQL Developer is the database IDE and Oracle SQL Developer Data Modeler is our dedicated data modeling solution. Where it gets interesting is that the entire Data Modeler product (more...)
An interesting question came up on the ORACLE-L mailing list this morning regarding table comments:
Just wanted to get a general opinion on using comments in the database. For example COMMENT ON COLUMN table.column “No comment”.
Does anyone do this as a regular best practice? I would prefer to (more...)
Because you don’t have any tables.
I hate to be the bearer of bad news, but you don’t actually ‘OWN’ any tables. What you mostly likely DO have are SYNONYMS that point to tables in a application schema. When you log on to Oracle, you are seeing this:
The solution is simple!
Enable Synonym Support in the Tables Filter Dialog
Mouse-right click on your tables tree node, and select ‘Apply Filter…’
With this checked, bam!
Note: This is also (more...)