--常見問題參考：http://mooc1.chaoxing.com/course/227191441.html?edit=false&knowledgeId=undefined&module=10&v=1662175692085#content

--創(chuàng)建表

crate table spj ( sno char(5), pno char(5), jno char(5), qty int, PRIMARY KEY (sno,pno,jno), FOREIGN KEY (sno) REFERENCES s(sno), FOREIGN KEY (pno) REFERENCES p(pno), FOREIGN KEY (jno) REFERENCES j(jno) );

--插入記錄

insert into Student values('200215228','陳冬','男',18,'IS');

--查詢記錄

sele Num from Salary where Salary>3000;

select sno,sname from Student where not(sage>19) and ssex='女';

--更新記錄

update Student set Sage=Sage+1;

--刪除記錄

delect * from Sc where Sno='200215122';

--創(chuàng)建函數：關鍵字為function

create function get_student_count() return INTEGER AS declare ret INTEGER; BEGIN EXECUTE IMMEDIATE 'select count(*) from student' USING out ret; RETURN ret; end;