QWQ19980801的博客

查询有效期1.select t.username,t.account_status,t.profile,t.expiry_date from dba_users t;2.select t.username,t.account_status,t.profile,t.expiry_date from dba_users t;设置密码无限制有效期alter profile default limit PASSWORD_LIFE_TIME unlimited;...

解决PageHelper重复数据优先排序日期有值的数据，二次排序倒序排列order by case when date is null then 1 else 0 end,date desc

报错如图：解决方法：查看Oracle安装所在目录下\product\11.2.0\dbhome_1\NETWORK\ADMIN的tnsnames.ora,文件中HOST修改为数据库的ip地址ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XX)(PORT = 1521)) ) (CONNECT_DATA = (SERVER =

从服务器数据库导出到本地dmp目标地址导出该用户的数据库 ：exp test/test@orcl file=F:/user.dmp owner=test导入该用户的数据库 ：imp test01/test01@orcl file=F:/user.dmp owner=test01...