摘要:
--游标遍历某个字段 (打印出来) declare res_sql varchar2(2000); cursor cur is select f_dcname from W_EC_PLACESTATION_COLLECT t where f_collectdate >= TRUNC(TO_DATE( 阅读全文
摘要:
--建表 create table kecheng( id NUMBER, name VARCHAR2(20), course VARCHAR2(20), score NUMBER); --插入数据insert into kecheng (id, name, course, score)values 阅读全文
摘要:
计算九月每个电厂的数量select f_dcname,count(f_dcname) as 九月份的数量 from W_EC_PLACESTATION_COLLECT twhere f_collectdate >= TRUNC(TO_DATE('2018-09-01','yyyy-MM-dd'),' 阅读全文