存储过程
摘要：
create or replace procedure Hello is h number; g char(20); begin select extract(hour from systimestamp)+8 into h from dual; if h >=20 or h<=5 then g:= 阅读全文
posted @ 2020-10-26 15:48 winecork 阅读(40) 评论(0) 推荐(0) 编辑
oracle extract()函数
摘要：
select extract(year from sysdate) as year , extract(month from sysdate) as month, extract(day from sysdate) as day from dual; //使用extract()函数，分别取出年月日 阅读全文
posted @ 2020-10-26 15:30 winecork 阅读(296) 评论(0) 推荐(0) 编辑
