dannis

不错,希望大家一起来完善,谢谢扶程星云

dannis

开发水晶报表时经常要用到的语句：fficeffice" />

SELECT ATABLE.ABRFIC_0 AS 表缩写,ATABLE.CODFIC_0 AS 数据表,ATABIND.CODIND_0 AS 表索引,ATABIND.DESCRIPT_0 AS 索引描述 FROM GJERP.ATABLE LEFT OUTER JOIN GJERP.ATABIND ON ATABLE.CODFIC_0=ATABIND.CODFIC_0 ORDER BY ATABLE.ABRFIC_0;

dannis

修改Admin密码语句（Oracle数据库）：fficeffice" />

UPDATE DEMOCHI.AUTILIS SET AUTILIS.PASSE_0='BAABAA' WHERE AUTILIS.USR_0='ADMIN';

UPDATE DEMOCHI.AUTILIS SET AUTILIS.NEWPAS_0 = (SELECT NEWPAS_0 FROM AUTILIS WHERE AUTILIS.USR_0='ADMIN') WHERE AUTILIS.USR_0='ADMIN';