---
title: "在pl/sql   中改变列长度 "
author: "java_frog"
date: "2008-09-19T11:31:59Z"
tags: []
slug: "pl-sql"
draft: false
lastmod: "2008-09-19T11:31:59Z"
id: 244059
url: "https://java-frog.iteye.com/blog/244059"
---

在pl/sql   中改变列长度   
    
  

NO.1   
alter   table   pdt   modify("PDTNAME",varchar2(100))

NO.2   
字段不用“”   
  alter   table   pdt   modify(PDTNAME,varchar2(100))   
  

NO.3   作者： chanet
字段操作   
  添加:   
  alter   table   tablename   add(addcol   varchar2(10));   
  修改:   
  alter   table   tablename   modify(col1   varchar2(20));   
  删除:   
  alter   table   tablename   drop(col1);   
  改名:   
  ALTER   TABLE   tablename   RENAME   COLUMN   col1   TO   col2

NO.4  
alter   ,create,drop,replace一般用于表，视图等对象 

参考链接：http://www.10we.cn/show/arti_11766.html