begin
var dd date;
dd=Day_next(sysdate,5);
select dd from dual;dd=Day_next(dd,5);select dd from dual;end;
反正就是这个意思,大家帮我看一下 啊,指点一下
var dd date;
dd=Day_next(sysdate,5);
select dd from dual;dd=Day_next(dd,5);select dd from dual;end;
反正就是这个意思,大家帮我看一下 啊,指点一下
已写入 file afiedt.buf 1 declare
2 dd date;
3 begin
4 dd:=sysdate+5;
5 dbms_output.put_line(dd);
6* end;
SQL> /
25-5月 -08PL/SQL 过程已成功完成。SQL>
dd=Day_next(sysdate,5);
select dd from dual; 那为什么这么写就不行呢?
用法: VAR[IABLE] [ <variable> [ NUMBER | CHAR | CHAR (n [CHAR|BYTE]) |
VARCHAR2 (n [CHAR|BYTE]) | NCHAR | NCHAR (n) |
NVARCHAR2 (n) | CLOB | NCLOB | BLOB | BFILE
REFCURSOR | BINARY_FLOAT | BINARY_DOUBLE ] ]
SQL>
没有date类型啊
-------- Declares a bind variable that can be referenced in PL/SQL, or
lists the current display characteristics for a single variable
or all variables.VAR[IABLE] [variable [type]] where type represents one of the following: NUMBER CHAR CHAR (n [CHAR|BYTE])
NCHAR NCHAR (n) VARCHAR2 (n [CHAR|BYTE])
NVARCHAR2 (n) CLOB NCLOB
REFCURSOR BINARY_FLOAT BINARY_DOUBLE
SQL>
dd=Day_next(dd,5); 应该变为dd := Day_next(dd,5);