SELECT ORDER_NUM,CUSTOMER_NUM,CUSTOMER_NAME,ADD_DAYS (ORDER_DATE,20) FROM CUSTOMER,ORDERS;
Oracle Express表示ADD_DAYS无效？任何想法我做错了什么？
如果你想添加N天你的日子。您可以使用加号运算符如下：
SELECT ( SYSDATE + N ) FROM DUAL;
SELECT ORDER_NUM,CUSTOMER_NUM,CUSTOMER_NAME,ADD_DAYS (ORDER_DATE,20) FROM CUSTOMER,ORDERS;
Oracle Express表示ADD_DAYS无效？任何想法我做错了什么？
SELECT ( SYSDATE + N ) FROM DUAL;
