本文共 4158 字，大约阅读时间需要 13 分钟。

09:00:12 SQL> create table JYC_A

(sno number,

sno1 number(*), --加*和什么都不加效果一样 sno2 number(*,0) );

Table created.

09:05:04 SQL> col column_name for a10

09:05:13 SQL> select column_name,data_precision,data_scale from user_tab_columns where table_name = 'JYC_A';

COLUMN_NAM DATA_PRECISION DATA_SCALE

---------- -------------- ---------- SNO SNO1 SNO2                   0

09:05:13 SQL> insert into JYC_A values (123.123123,123123.21344,123123.213445);

1 row created.

09:05:59 SQL> commit;

Commit complete.

09:06:01 SQL> select * from JYC_A;

       SNO     SNO1        SNO2

---------- ---------- ---------- 123.123123 123123.213      123123

09:06:10 SQL> insert into JYC_A values (123.123123123,123123.123123,123123.123123);

1 row created.

09:06:56 SQL> commit;

Commit complete.

Elapsed: 00:00:00.00

09:06:58 SQL> select * from JYC_A;    

       SNO     SNO1        SNO2

---------- ---------- ---------- 123.123123 123123.213      123123 123.123123 123123.123      123123

09:07:08 SQL> DESC JYC_A    Name                                      Null?    Type  ------------------------------------------------------------------------ -------- -------------------------------------------------  SNO                                           NUMBER  SNO1                                           NUMBER  SNO2                                           NUMBER(38)

09:07:25 SQL> select column_name,data_precision,data_scale from user_tab_columns where table_name = 'JYC_A';

COLUMN_NAM DATA_PRECISION DATA_SCALE

---------- -------------- ---------- SNO SNO1 SNO2                   0

09:20:15 SQL> insert into JYC_A values (123456789.123456789,123456789.123456789,123456789.123456789);

1 row created.

Elapsed: 00:00:00.02

09:21:00 SQL> commit;

Commit complete.

Elapsed: 00:00:00.00

09:21:04 SQL> select * from JYC_A; 

       SNO     SNO1        SNO2

---------- ---------- ----------  123456789  123456789  123456789

Elapsed: 00:00:00.02

09:21:10 SQL> insert into JYC_A values (1234567890123456789.123456789,1234567890123456789.123456789,1234567890123456789.123456789);

1 row created.

Elapsed: 00:00:00.00

09:22:03 SQL> commit;

Commit complete.

Elapsed: 00:00:00.00

09:22:15 SQL> select * from jyc_a;

       SNO     SNO1        SNO2

---------- ---------- ----------  123456789  123456789  123456789 1.2346E+18 1.2346E+18 1.2346E+18

Elapsed: 00:00:00.00

09:22:22 SQL> col sno for 9999999999999999999999999 09:22:39 SQL> col sno1 for 99999999999999999999999999 09:22:48 SQL> col son2 for 999999999999999999999999999 09:22:54 SQL> r   1* select * from jyc_a

               SNO              SNO1         SNO2

-------------------------- --------------------------- ----------          123456789             123456789    123456789        1234567890123456789       1234567890123456789 1.2346E+18

Elapsed: 00:00:00.00

09:22:56 SQL> col sno1 for 999999999999999999999999999 09:23:16 SQL> r   1* select * from jyc_a

               SNO               SNO1       SNO2

-------------------------- ---------------------------- ----------          123456789              123456789  123456789        1234567890123456789        1234567890123456789 1.2346E+18

Elapsed: 00:00:00.00

09:23:18 SQL> set line 160 09:23:24 SQL> set wrap on 09:23:27 SQL> r   1* select * from jyc_a

               SNO               SNO1       SNO2

-------------------------- ---------------------------- ----------          123456789              123456789  123456789        1234567890123456789        1234567890123456789 1.2346E+18

Elapsed: 00:00:00.00

09:36:10 SQL> insert into JYC_A values (1234567890123456789123456789.123456789,1234567890123456789123456789.123456789,1234567890123456789123456789.123456789);

1 row created.

Elapsed: 00:00:00.03

09:36:41 SQL> commit;

Commit complete.

Elapsed: 00:00:00.01

09:36:44 SQL> select * from jyc_a;

               SNO               SNO1       SNO2

-------------------------- ---------------------------- ---------- ########################## ############################ 1.2346E+27

Elapsed: 00:00:00.02

09:36:48 SQL> col sno for 9999999999999999999999999999999999999 09:36:59 SQL> r   1* select * from jyc_a

                   SNO                   SNO1      SNO2

-------------------------------------- ---------------------------- ----------       1234567890123456789123456789 ############################ 1.2346E+27

Elapsed: 00:00:00.00

09:36:59 SQL> col sno1 for 9999999999999999999999999999999999999 09:37:14 SQL> r   1* select * from jyc_a

                   SNO                     SNO1        SNO2

-------------------------------------- -------------------------------------- ----------       1234567890123456789123456789         1234567890123456789123456789 1.2346E+27

Elapsed: 00:00:00.00

09:38:41 SQL> insert into JYC_A values (123.1234567,123.1234567,123.1234567);

1 row created.

Elapsed: 00:00:00.00

09:39:43 SQL> commit;

Commit complete.

 

 

转载地址：http://dnsof.baihongyu.com/