iteye_18556的博客

删除表的字段alter table 表名  drop column 字段名 修改一个表字段的长度alter table 表名 modify 字段名 varchar2(40) 删除整个表的所有数据TRUNCATE TABLE 表名  要比delete快很多。 查询数据库有没有被锁住select t2.username,  t2.sid,t2.serial#,t...

例子1：select dense_rank() over(order by d.auditingdate) num, d.auditingdate, d.quesuser, d.quescontent, decode(d.questype, 1, '系统Bug', 2, '新增', 3, '修改', 4, '咨询', 5, '其它') typefrom debugrecord dwhere t...

……--当传入学习中心编号时  IF vSpotCode is not null THEN     vWhere:=vWhere || ' AND ass.SpotCode=' || vSpotCode;  END IF;  --当传入学生层次编号时  IF vLevelCode is not null THEN     vWhere:=vWhere || ' AND ass.LevelCod...

Tomcat 连接 Oracle 找不到 Driver 的问题后台报错：cannot oracle.jdbc.driver.OracleDriver要在tomcat目录下的lib里面添加classes12.jar才可以

update spot s set s.name = (select ss.outername from spotregister ss where s.spotcode = ss.spotcode and ss.outername is not null), s.outername =  (select ss.outername from spotregister ss where s.spot...

select replace(m.feedback,to_char(chr(13)),'<br />') feedback from MeetInfo m

创建一个jobdeclarejobnum number :=0;begin  sys.dbms_job.submit(job => jobnum,                      what => 'DEL_COLUMN_EXPIRE_INFO;',    --要执行的存储过程                      next_date => to_date('28...