第一问答网»论坛 › 中问网 › 问答 › 执行sql遇到一点小问题,那位大侠指点一下; ...

执行sql遇到一点小问题,那位大侠指点一下;

11 |

0 | 2006-9-6 14:53:00 | 显示全部楼层 |阅读模式

执行 sqlplus **/**@** alter_table.sql >alter_table_exe.sql
得到alter_table_exe.sql如下:
SQL*Plus: Release 9.2.0.5.0 - Production on Tue Sep 5 13:08:45 2006
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

'ALTERTABLE'||TABLE_NAME||'MODIFY('||COLUMN_NAME||''||A.DATA_TYPE||'('||A.DATA_L
--------------------------------------------------------------------------------
ALTER TABLE ACCOUNT MODIFY ( ACCOUNTNAME VARCHAR2(24));
ALTER TABLE ACCOUNT MODIFY ( BILLINGMONTH VARCHAR2(16));
ALTER TABLE ACCOUNT MODIFY ( CONTACTPERSON VARCHAR2(128));
ALTER TABLE ACCOUNT MODIFY ( RELATEDPHONE VARCHAR2(32));
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

我只想得到:
ALTER TABLE ACCOUNT MODIFY ( ACCOUNTNAME VARCHAR2(24));
ALTER TABLE ACCOUNT MODIFY ( BILLINGMONTH VARCHAR2(16));
ALTER TABLE ACCOUNT MODIFY ( CONTACTPERSON VARCHAR2(128));
ALTER TABLE ACCOUNT MODIFY ( RELATEDPHONE VARCHAR2(32));
那位大侠有好的办法,我想过用第三方语言,比如java来做;

使用道具举报

返回列表发新帖

千问

主题	0 回帖	4882万积分

论坛元老

Rank: 8 Rank: 8

积分: 48824836

回复楼主返回列表

问答

热门排行