建表
SQL> create table student
2 (3 student_id number not null,
4 student_name varchar2(20),
5 student_age number
6 )
7 tablespace users
8 /
Table created.
插入数据
SQL> insert into student values (1,'jimmy',18);
1 row created.
SQL> commit;
Commit complete.
查询
SQL> select * from student;
STUDENT_ID STUDENT_NAME STUDENT_AGE
---------- -------------------- -----------
1 jimmy 18
插入空值
比如有4列,最后一列不想填数据
SQL> insert into student values (2,'jerry',18,null); //想留空的一栏输入null
1 row created.
SQL> commit;
Commit complete.
SQL> select * from student;
STUDENT_ID STUDENT_NAME STUDENT_AGE GENDER
---------- -------------------- ----------- --------------------
2 jerry 18
1 jimmy 20