사용하고 있던 table에 설정되어 있는 Dafault 옵션을 삭제 하고 싶습니다.

Modify로 변경을 가능한데.. 삭제는 안되나요.(Null로 변경해서 사용해야되는지..)

* test3 테이블에 Dafaut 옵션 조회

SCOTT>select TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_DEFAULT from user_tab_cols
  2   where table_name = 'TEST3';

TABLE_NAME                     COLUMN_NAME             DATA_TYPE  DATA_DEFAULT
------------------------------ ------------------------------ ----------  ----------------------------------------
TEST3                          TEAM5                          VARCHAR2            
TEST3                          TEAM2                          VARCHAR2            
TEST3                          TEAM3                          VARCHAR2            

* test3 테이블에 Dafaut 옵션 추가

SCOTT>alter table test3
  2  modify (team5 default 'TTT');

Table altered.

SCOTT>select TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_DEFAULT from user_tab_cols
  2   where table_name = 'TEST3';

TABLE_NAME                     COLUMN_NAME                    DATA_TYPE  DATA_DEFAULT
------------------------------ ------------------------------ ---------- ----------------------------------------
TEST3                          TEAM5                          VARCHAR2   'TTT'
TEST3                          TEAM2                          VARCHAR2
TEST3                          TEAM3                          VARCHAR2
TEST3                          TEAM4                          DATE

* 이것 저걱 명령어를 쳐봤는데 삭제가 하는 방법을 모르겠습니다(Null로 변경밖에는)

혹시 삭제하는 명령어좀 알려주세요.

SCOTT>alter table test3
  2  drop team5 default;
drop team5 default
     *
ERROR at line 2:
ORA-00905: missing keyword

SCOTT>alter table test3
  2  drop team5 default 'TTT';
drop team5 default 'TTT'
     *
ERROR at line 2:
ORA-00905: missing keyword

SCOTT>alter table test3
  2  drop column team5 default ;
drop column team5 default
                  *
ERROR at line 2:
ORA-00933: SQL command not properly ended

SCOTT>alter table test3
  2  drop column team5 default 'TTT';
drop column team5 default 'TTT'
                  *
ERROR at line 2:
ORA-00933: SQL command not properly ended