摘要:
--select * from student;--delete from student where sid>=4;--delete from "SYSTEM"."STUDENT";--SELECT * FROM "SYSTEM"."STUDENT";/**//*--插入30条记录SET SERVEROUTPUT ONDECLARE I INT:=0;beginFOR I IN 1..30 L... 阅读全文
摘要:
--select * from student;--delete from student where sid>=4;--delete from "SYSTEM"."STUDENT";--SELECT * FROM "SYSTEM"."STUDENT";/**//*--插入30条记录SET SERVEROUTPUT ONDECLARE I INT:=0;beginFOR I IN 1..30 L... 阅读全文
摘要:
Oracle 常用函数 --删除表 Drop Table "SYSTEM"."TESTTABLE"; --建表 Create Table "SYSTEM"."TESTTABLE"( SID Number(4) Primary Key, SNAME Varchar2(30) NOT NULL UNIQUE, SEX Number(1) Default (0) CHECK ... 阅读全文
|