lovebeauty

摘要： 在Oracle中，只有DML才会开启一个事务。也就是说Insert，Update，Delete这些都会开启一个事务，并且该事务在commit/rollback/ddl命令时会自动结束。1.获取特定数据的前几位select substr(recordid,1,2) from syscode where rownum < 5;2.获取指定条数的数据select recordid from syscode where rownum < 5;3.获取指定格式的ID function getsmssendid return varchar2 is v_getsmssendid smssend 阅读全文

摘要： case whenView Code 1 select (case userid2 when 'CUS0000003017804' then3 '张三'4 when 'CUS0000003017805' then5 '李四'6 else7 '王五'8 end) userid from users a where loginname = 'xxx';View Code 1 select case 2 when userid ='CUS0000003017804' then 3 ' 阅读全文