注册码：Product Code：4t46t6vydkvsxekkvf3fjnpzy5wbuhphqzserial Number：601769password：xs374ca

变成实用的sql 为select canal, (select A.ECL_VALUE from BEIYIN_BYJG A where A.flag=2 and A.canal=BEIYIN_BYJG.canal) as base_ecl, (select A.ECL_VALUE from BEIYIN_BYJG A where A...

SELECT 'ALTER TABLE I9_B_RETAIL_LOAN ADD PARTITION'|| PARTITION_name || ' VALUES ('''||SUBSTR(PARTITION_name，2， 4)||'-'||SUBSTR(PARTITION_name，6， 2)||'-'||SUBSTR(PARTITION_name，8， 2)||''') tablesp...