心的宁静专栏

Oracle中的存储过程简单例子原文地址：http://blog.youkuaiyun.com/o9109003234/article/details/24910039--创建表create table TESTTABLE(  id1  VARCHAR2(12),  name VARCHAR2(32))select t.id1,t.name from TESTTABLE t

select substr(sys_guid(), 1, 8) || '-' || substr(sys_guid(), 9, 4) || '-' ||       substr(sys_guid(), 13, 4) || '-' || substr(sys_guid(), 17, 4) || '-' ||       substr(sys_guid(), 20, 12)  FROM