oracle的字段类型number,number(),number(,0)

71 阅读 0 评论 47 点赞

我是靠谱客的博主傲娇戒指，最近开发中收集的这篇文章主要介绍oracle的字段类型number,number(*),number(*,0)，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

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.