初學oracle，sql，DML向表中插入某個值

標籤：show   color   漢字   指定   查詢   column   隊列   acl   插入   

SQL> conn scott/tiger
Connected.
SQL> show user;
USER is "SCOTT"
SQL> create table qq(name varchar2(10),salary number(8,2)); 建立一個表qq,兩個段，名字和工資
Table created.
SQL> select * from qq;  查詢表qq的資訊
no rows selected
SQL> insert into qq(name) values(‘zhangsan‘); 指定某個隊列插入資料，未設定NULL
1 row created.
SQL> select * from qq;
NAME           SALARY
---------- ----------
zhangsan
                        插入資料，嘗試發現，NUMBER數值8,2表示，小數點保持兩位，六位的整數位
           values2為字元型，漢子一個字代表兩個位元組，英文及特殊字元一個，我這漢子顯示不出來，字元漢字括弧內加引號
SQL> insert into qq(salary) values(123456.78);
1 row created.
SQL> select * from qq;
NAME           SALARY
---------- ----------
zhangsan
            123456.78
SQL> insert into qq values(‘lisi‘,12345678);
insert into qq values(‘lisi‘,12345678)
                             *ERROR at line 1:
ORA-01438: value larger than specified precision allowed for this column
SQL> insert into qq values(‘lisi‘,5000);
1 row created.
SQL> select * from qq;
NAME           SALARY
---------- ----------
zhangsan
            123456.78
lisi             5000
SQL> insert into qq values(1);
insert into qq values(1)
            *ERROR at line 1:
ORA-00947: not enough values
SQL> insert into qq(salary) values(11);
1 row created.
SQL> select * from qq;
NAME           SALARY
---------- ----------
zhangsan
            123456.78
lisi             5000
                   1

SQL> roll                              復原操作
Rollback complete.
SQL> select * from qq;

no rows selected

1

 

初學oracle，sql，DML向表中插入某個值