Following is simple example syntax for renaming a column to an Oracle table using “alter table” SQL:
1 2 | ALTER TABLE [my_table_name] RENAME COLUMN [current_column_name] TO [new_column_name]; |
A simple example would be:
1 2 | ALTER TABLE employee RENAME COLUMN f_name TO first_name; |
Like renaming an Oracle table, you should be aware of any dependencies in code, etc. that reference a table column by name.
These words are being used more and more. Of course, it was just a matter of time before the popularity and creativity of “Web 2.0” as a buzzword was reused, extended, and blatantly copied for other innovations in the technology space.
In early 2008, Oracle allowed you to enable WebCenter 11g and SOA 11g Tech Previews through the Oracle JDeveloper 11g Technology Preview. At this point, mid-2009, this is somewhat outdated. The actual WebCenter 11g release (not available for download by Oracle) has quite an enhanced environment, features, etc. I don’t know the timing details exactly, but I imagine that the tech preview was put together before the BEA acquisition decisions were finalized and certainly before they were fully integrated. WebCenter 11g should be a fantastic product taking the best of many Enterprise 2.0 products and services that Oracle has either … Read More
