
数据库
javazhou
这个作者很懒,什么都没留下…
展开
-
固定列数的行列转换
create table "student"( id number(11,0), stuname varchar2(20), subject varchar(20), grade number(4,2), primary key(id)) insert into "student" values(201001,'javazhou','语文',90);insert into "s...2010-03-09 15:04:11 · 297 阅读 · 0 评论 -
oracle判断表名是否存在
declare tableCount number; begin select count(*) into tableCount from user_all_tables where table_name = 'STUDENT'; if tableCount > 0 then execute immediate 'drop table STUDENT'...2010-04-15 23:29:02 · 931 阅读 · 0 评论