| Title: | SQL notes |
| Moderator: | NOVA::SMITHI |
| Created: | Wed Aug 27 1986 |
| Last Modified: | Thu Jun 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 3895 |
| Total number of notes: | 17726 |
Over the next few weeks, I am going to need to "change a column" name in
our database which affects the "computed by" clause of another column.
"Changing" the first column is fine, but I have a question about
modifying the "Computed" column...
How do I do it? It is based on a long CASE statement that needs to
have a new case added. It sounds simple enough but I haven't found
anything yet that describes how.
Thanks,
michele
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 3861.1 | drop column/add column | caotv1.ca.oracle.com::BZINN | [email protected] | Wed Feb 12 1997 14:38 | 4 |
I'd bet you're going to have to delete the computed by column then add
the whole thing back in.
Brenda
| |||||
| 3861.2 | NOVA::SMITHI | Don't understate or underestimate Rdb! | Wed Feb 12 1997 14:54 | 6 | |
alter table T drop column C add column C computed by ...etc... ; Ian | |||||
| 3861.3 | ORAREP::SHOGUN::PAGLIARULO | Wed Feb 12 1997 15:51 | 7 | ||
I guess I really knew that all along and was in denial...hoping for
an easier way - like simply editting the compute statement.
Thanks for your help!
michele
| |||||