Re: Rename table

Its easy, just create an ON_MARRIAGE trigger and have it scan the announcements sections of your on-line newspaper...match any names it finds, and change to the new name...

Of Course, you will also need an ON_DIVORCE trigger as well...This probably needs to scan the court records...

;-)

Joe Kazimierczyk <joseph.kazimierczyk_at_bms.com> wrote:

>
>> The following is quoted from 9i_new_features.pdf at technet.oracle.com:
>>
>> "Additionally, many logical attributes can be changed . Column names, types, and
>> sizes can be changed. Columns can be added, deleted, or merged. The primary
>> restriction is that the primary key of the table cannot be modified."
>>
>> So it is coming in just another month.
>>
>
>
>Will 'rename user' be in 9i? That's one command I've
>sorely missed. We've asked people to postpone their
>marriages and divorces until Oracle gives us a 'rename
>user'. ;-)
Received on Fri May 18 2001 - 09:32:56 CDT