不行呀,而且这方法只针对这一个表,我所有的表输出都这个样子,愁死我了 就算我set heading off 输出变成了: 7369 SMITH CLERK 7499 ALLEN SALESMAN 7521 WARD SALESMAN 即原数据表里面的一行数据都按一列输出了。555555555
谢谢jdsnhan(柳荫凉),用你的方法解决了(具体sql语句如下),有没有简单点的方法能把一个表格的所有列长都设置成一个数字,不用像下面那样把所有列都设置一遍,如果表很多真的好麻烦。 SET PAGESIZE 100; SET LINESIZE 230; CLEAR COL; COL ID_CONTACT FOR A15; --COL ID_PRINCIPAL COL FIRST_NAME FOR A15; COL LAST_NAME FOR A15; COL PHONE_NUMBER FOR A15; COL MOBILE FOR A15; COL EMAIL FOR A15; COL ADDRESS FOR A15; COL CITY FOR A15; COL ZIP FOR A15; COL STATE FOR A15; COL UPDATE_DATE FOR A35; SELECT * FROM SCOTT.contact;
就算我set heading off
输出变成了:
7369
SMITH
CLERK
7499
ALLEN
SALESMAN
7521
WARD
SALESMAN
即原数据表里面的一行数据都按一列输出了。555555555
SET PAGESIZE 100;
SET LINESIZE 230;
CLEAR COL;
COL ID_CONTACT FOR A15;
--COL ID_PRINCIPAL
COL FIRST_NAME FOR A15;
COL LAST_NAME FOR A15;
COL PHONE_NUMBER FOR A15;
COL MOBILE FOR A15;
COL EMAIL FOR A15;
COL ADDRESS FOR A15;
COL CITY FOR A15;
COL ZIP FOR A15;
COL STATE FOR A15;
COL UPDATE_DATE FOR A35;
SELECT * FROM SCOTT.contact;