ZKX's LAB

PLSQL语句 plsql 求余数

2021-04-08知识5

求一个sql语句,pl/sql SELECT birthdayFROM(SELECT birthday,'1' DFROM AWHERE TO_CHAR(SYSDATE,'MMDD')(birthday,'MMDD')UNION ALLSELECT birthday,'2' D FROM A WHERE TO_CHAR(SYSDATE,'MMDD')>;TO_CHAR(birthday,'MMDD'))ORDER BY D,birthday

关于PL/SQL Developer的问题 1 create table classesclassId number(2),cname varchar(40)最后没有逗号2 pl/sql developer菜单中 tools—user interface—editor—syntax highlighting—keywords bold 打挑3 没懂

求PL/SQL得一条语句 cast([date]+[time]as datetime)补充:cast(convert(varchar,[date],23)+' '+[time]as datetime)

#plsql 求余数#plsql developer配置

随机阅读

qrcode
访问手机版