求一个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)