ORACLE学习笔记-添加更新数据函数篇

/*添加数据*/
insert into STU values(‘stu0004′,’赵一’,18,1,”kc0004″);
insert into STU(STU_ID,STU_NAME,STU_AGE,STU_SET ) values(‘stu0013′,’储十一’,19,1);

/*更新数据*/
update STU SET STU_AGE=19 WHERE STU_ID=’stu0001′

/*增加列*/
ALTER TABLE STU ADD KC_NO varchar2(10)

/*平均数*/
select AVG(STU_AGE) as 平均数 from stu

/*存在值得行数*/
select COUNT(STU_ID) as 行数 from stu

select COUNT(KC_NO) as 行数 from stu

/*最大值*/
select MAX(STU_AGE) as 最大年龄 from stu

/*最小值*/
select MIN(STU_AGE) as 最小年龄 from stu

/*求和*/
select SUM(STU_AGE) as 和 from stu