求PL/SQL得一条语句 cast([date]+[time]as datetime)补充:cast(convert(varchar,[date],23)+' '+[time]as datetime)
有这么一条pl/sql语句 把里面的改为这个试试select imsi,score,score as t_1_score,0,0 from t_1union allselect imsi,score,0,score as t_2_score,0 from t_2union allselect imsi,score,0,0,score as t_3_score from t_3然后在外层select加avg()
为什么我在PL/SQL中执行SQL语句会出现这样的现象,求解释? 你是不是没有点击左上方commit按钮进行提交