我用toda写的写面这个函数
CREATE OR REPLACE FUNCTION TIEXIN.GetTheTime
(OLDTIME INT)
RETURN VARCHAR2
IS
THEHOUR int;
THEMIN int;
THESEC int;
STRTIME VARCHAR2(20000);
BEGIN
IF OLDTIME < 60 THEN
STRTIME := TO_CHAR(OLDTIME) || '''秒''';
ELSE
THEMIN := OLDTIME/60;
THESEC := MOD(60,OLDTIME);
IF THEMIN >= 60 THEN
THEHOUR := THEMIN/60;
THEMIN := MOD(60,THEMIN);
STRTIME := TO_CHAR(THEHOUR) || '''小时''' || TO_CHAR(THEMIN) || '''分''' || TO_CHAR(THESEC) || '''秒''';
ELSE
STRTIME := TO_CHAR(THEMIN) || '''分''' || TO_CHAR(THESEC) || '''秒''';
END IF;
END IF;
RETURN STRTIME;
END GetTheTime;他总是报
PLS-00103: 出现符号 ""在需要下列之一时:
begin case
declare end exception exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier这个错误....请专家指教一下.....谢谢
CREATE OR REPLACE FUNCTION TIEXIN.GetTheTime
(OLDTIME INT)
RETURN VARCHAR2
IS
THEHOUR int;
THEMIN int;
THESEC int;
STRTIME VARCHAR2(20000);
BEGIN
IF OLDTIME < 60 THEN
STRTIME := TO_CHAR(OLDTIME) || '''秒''';
ELSE
THEMIN := OLDTIME/60;
THESEC := MOD(60,OLDTIME);
IF THEMIN >= 60 THEN
THEHOUR := THEMIN/60;
THEMIN := MOD(60,THEMIN);
STRTIME := TO_CHAR(THEHOUR) || '''小时''' || TO_CHAR(THEMIN) || '''分''' || TO_CHAR(THESEC) || '''秒''';
ELSE
STRTIME := TO_CHAR(THEMIN) || '''分''' || TO_CHAR(THESEC) || '''秒''';
END IF;
END IF;
RETURN STRTIME;
END GetTheTime;他总是报
PLS-00103: 出现符号 ""在需要下列之一时:
begin case
declare end exception exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier这个错误....请专家指教一下.....谢谢
解决方案 »
- 使用分析函数LAG("MONTH", 12, 0)做同期比较,但是某些月份缺失怎么办?
- 貌似简单的SQL查询,急切等待解决!!!
- PRO*C程序连接数据库问题,高人请进!
- 关于oracle9i的apache的启动问题,在线等
- 如何才能改变当前序列的值呢?
- 高分相求:PL/SQL高手请进!
- 谁知道关于介绍sql92,sql99的网址?
- 请问查询longrow的字段 用selectblob语句可以吗
- SQL优化请教
- 新手求教 Oracle数据库常用的增删改查语句
- 没分~初学ORCAL 谁告诉我个ORCAL的作业怎么写啊 最好有例子 谢谢
- 初学ORCAL 谁告诉我个ORCAL的作业怎么写啊 最好有例子 谢谢
注意STRTIME VARCHAR2(20000); 没有20000的长度;SQL> CREATE OR REPLACE FUNCTION GETTHETIME(OLDTIME IN INT)
2 RETURN VARCHAR2
3 IS
4 THEHOUR int;
5 THEMIN int;
6 THESEC int;
7 STRTIME VARCHAR2(2000);
8 BEGIN
9 IF OLDTIME < 60 THEN
10 STRTIME := TO_CHAR(OLDTIME) || '''秒''';
11 ELSE
12 THEMIN := OLDTIME/60;
13 THESEC := MOD(60,OLDTIME);
14 IF THEMIN >= 60 THEN
15 THEHOUR := THEMIN/60;
16 THEMIN := MOD(60,THEMIN);
17 STRTIME := TO_CHAR(THEHOUR) || '''小时''' || TO_CHAR(THEMIN)
|| '''分''' || TO_CHAR(THESEC) || '''秒''';
18 ELSE
19 STRTIME := TO_CHAR(THEMIN) || '''分''' || TO_CHAR(THESEC)
|| '''秒''';
20 END IF;
21 END IF;
22 return StrTime;
23 END GETTHETIME;
24 /Function created