@DIV
CREATE or REPLACE FUNCTION today
RETURN DATE
AS
RET_VALUE DATE;
BEGIN
BEGIN
select 売上日付 into RET_VALUE from コントロールマスタ where キー = '1';
EXCEPTION
WHEN OTHERS THEN
RET_VALUE := SYSDATE;
END;
RETURN RET_VALUE;
END today;
@END
@DIV
select * from USER_SOURCE
order by LINE
@END
@DIV
select * from USER_ERRORS
order by LINE
@END
【*_SOURCE】
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19228-03/statviews_2.htm#112741
【*_ERRORS】
http://otndnld.oracle.co.jp/document/products/oracle10g/102/doc_cd/server.102/B19228-03/statviews_1.htm#84046
|