摘要： select nvl(t.NAME, '合计') NAME, sum(decode(t.vehicletypename, 'A1', j.totalhours, 0.00)) as A1, sum(decode(t.vehicletypename, 'B2', j.totalhours, 0.00)) as B2, sum(decode(t.vehicletypename, 'C1', j.totalhours, 0.00)) as C1, sum(decode(t.vehicletypename, 'C2', j 阅读全文

摘要： Oracle数据库密码有效期参数1.查看数据库用户对应的概要文件。SQL>select username,profile from dba_users;检查显示信息中历史库用户sersv对应的profile。一般都为DEFAULT，如下所示。USERNAME PROFILE------------------------------ ------------------------------SYSTEM DEFAULTSYS DEFAULT……sersrv DEFAULT2.检查概要文件（默认为d... 阅读全文