ThatJeffSmith

Tag: clone

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

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 […]

Similar Posts by Subject Areas: , , , ,

Floating Editors in Oracle SQL Developer v4

Working on a table? Maybe you need to investigate the stats while you also browse some data. But this is a BIG table. You know how to do the ‘split document trick,’ but that’s not quite cutting it. You need more screen real estate. Wouldn’t it be nice if you could drag that table viewer […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,