编写数据库脚本时，编辑日期类型字段错误，跪求大神帮助

weixin_58555736 2022-02-17 10:58:21

PROCEDURE USR_QLJFW.T_JOB_JKDT 编译错误

错误：PLS-00103: Encountered the symbol "YYYY" when expecting one of the following:

* & = - + ; < / > at in is mod remainder not rem return
returning <an exponent (**)> <> or != or ~= >= <= <> and or
like like2 like4 likec between into using || multiset bulk
member submultiset
The symbol "*" was substituted for "YYYY" to continue.
行：12
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'YYYY-MM-DD')';

错误：PLS-00103: Encountered the symbol ")" when expecting one of the following:

. ( * @ % & = - + ; < / > at in is mod remainder not rem
return returning <an exponent (**)> <> or != or ~= >= <= <>
and or like like2 like4 likec between into using || bulk
member submultiset
The symbol "*" was substituted for ")" to continue.
行：12
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'YYYY-MM-DD')';

错误：PLS-00103: Encountered the symbol "YYYY" when expecting one of the following:

* & = - + ; < / > at in is mod remainder not rem return
returning <an exponent (**)> <> or != or ~= >= <= <> and or
like like2 like4 likec between into using || multiset bulk
member submultiset
The symbol "*" was substituted for "YYYY" to continue.
行：29
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'yyyy-mm-dd')';

错误：PLS-00103: Encountered the symbol ")" when expecting one of the following:

. ( * @ % & = - + ; < / > at in is mod remainder not rem
return returning <an exponent (**)> <> or != or ~= >= <= <>
and or like like2 like4 likec between into using || bulk
member submultiset
The symbol "*" was substituted for ")" to continue.
行：29
文本：where NEED_CHECKIN_DATE >= to_char(sysdate-30,'yyyy-mm-dd')';

...全文

314 1 打赏收藏转发到动态举报

写回复

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

weixin_58555736 2022-02-17

打赏
举报

回复

求大神帮忙

http://blog.csdn.net/xyz_lmn/article/details/9312837 iOS学习笔记——数据库操作(使用FMDB)

《PHP＋MySQL动态网站开发全程实例》随书光盘。下载有问题，请邮件联系booksaga@163.com，邮件标题为“求PHP＋MySQL代码”

selenium webdriver 关于python语言的实现，目前最全面实用的文档，虫师首发。

毕业设计-优秀
含论文

大家这么喜欢，我就不要资源分了，改成0分了，我为我一己私利感到抱歉…… MongoDB学习手册 ......................................................................................................................... 1 说明.......................................................................................................................................... 2 一、 Mongodb简介 .......................................................................................................... 4 二、 MongoDB特性 ......................................................................................................... 5 适用场景： ....................................................................................................................... 5 不适用场景： ................................................................................................................... 6 三、 MongoDB的工作方式.............................................................................................. 6 四、 MongoDB的下载 ..................................................................................................... 8 五、 MongoDB的安装 ..................................................................................................... 9 六、 MongoDB数据类型................................................................................................ 12 1. Timestamp类型 ...................................................................................................... 12 2. ObjectId类型 .......................................................................................................... 12 3. 数据库关联 ............................................................................................................. 14 七、 GridFS文件系统 ..................................................................................................... 15 八、索引 ......................................................................................................................... 16 九、主（Master）/从（slave）数据库同步 ................................................................ 20 1. 建立主/从服务器 ................................................................................................... 20 2. 相关参数说明 ......................................................................................................... 21 3. Slave顶替Master ................................................................................................... 22 4. 切换Master/Slave角色 ......................................................................................... 22 5. 更新主服务器位置 ................................................................................................. 22 十、 MongoDB分片和集群............................................................................................ 24 1. 简单分片实例 ......................................................................................................... 24 2. 高级分片实例 ......................................................................................................... 29 十一、 数据库基本操作：增查删改 ............................................................................. 37 1. Insert ....................................................................................................................... 37 2. Query ....................................................................................................................... 38 3. Remove.................................................................................................................... 52 4. Update ..................................................................................................................... 53 十二、 Shell控制台 ........................................................................................................ 62 1. 执行.js文件 ............................................................................................................ 62 2. –eval ........................................................................................................................ 62 3. 脚本和互动的区别 ................................................................................................. 62 十三、安全与认证 ......................................................................................................... 63 1) 开启安全认证 ......................................................................................................... 63 2) 添加用户 ................................................................................................................. 64 3) 认证 ......................................................................................................................... 64

基础和管理

17,382

社区成员

95,118

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章