Other workarounds: 1. SQL> update t1 set column_to_drop = NULL;
SQL> rename t1 to t1_base;
SQL> create view t1 as select
2. SQL> create table t2 as select
SQL> drop table t1;
SQL> rename t2 to t1;
===========
rem -----------------------------------------------------------------------
rem Filename: dropcol.sql
rem Purpose: Demonstrate Oracle8i drop column functionality
rem Date: 28-Aug-1998
rem Author: Frank Naude, Oracle FAQ
rem -----------------------------------------------------------------------
-- drop table x
-- /
create table x(a date, b date, c date)
/
-- Drop column B:
alter table x set unused column b -- Mark col as UNUSED
/
select * from sys.dba_unused_col_tabs
/
alter table x drop unused columns
/
-- Drop column C (different method):
alter table x drop column c cascade constraints
/
=================
-t
---
Tyson Chen
tysonchen () gmail
1 則留言:
We have enabled email notifications—you will now receive an email should you receive a reply to your remark, could be} an update to a remark thread you comply with or if a person you comply with feedback. Visit our Community Guidelines for more data and particulars on method to|tips on how to} adjust your email settings. Ocado enters South Korea with Lotte Shopping deal LONDON — Ocado Group, the British online grocery store and technology group, has entered the South Korean market through a partnership take care of Lotte Shopping, the businesses mentioned on Tuesday. LONDON — Ocado, the British online grocery store and technology group, has entered the South Korean market through a partnership take care of Lotte Shopping , the businesses mentioned on Tuesday. Local time Sunday (4 a.m. ET), the number of folks injured had risen to 133, of whom 37 had been critically injured, the ministry mentioned. MGM China's Cotai casino in Macau was locked down on Sunday after a dealer examined positive for COVID-19, city authorities 1xbet in the world's largest playing hub mentioned, ordering everybody inside to remain put until Nov 1.
張貼留言