30 SQL Developer Tips in 30 Days, Day 19: Quick and Clean Table Copies

thatjeffsmith SQL Developer 1 Comment

Quick and clean, what’s that? Consider the following: CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1=2; I call that ‘quick and dirty,’ and I imagine you have used this technique many, many times. But, I wish it would have grabbed column comments, indexes, maybe even the partitions. Partitioning a table after the fact is pretty much a no-go. …

SQL Developer Data Modeler: On Notes, Comments, and Comments in RDBMS

thatjeffsmith SQL Developer 5 Comments

Ah the beautiful data model. They say a picture is worth a 1,000 words. And then we have our diagrams, how many words are they worth? So our models describe how the data ‘works’ – whether that be at a logical-business level, or a technical-physical level. Developers like to say that their code is self-documenting. These would be very lazy …

Managing Table and Column Comments in Oracle SQL Developer

thatjeffsmith SQL Developer 12 Comments

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 see this abstraction in a data model, maybe not pushed to …