摘要：
reference: https://blog.csdn.net/huaishuming/article/details/74762652法一：SELECT * from jc_archives where senddate>UNIX_TIMESTAMP('2014-9-1' ) into outf 阅读全文
摘要：
reference: https://unix.stackexchange.com/questions/182537/write-python-stdout-to-file-immediately 立即输出print内容到文件 $ export PYTHONUNBUFFERED=1 $ ./mysc 阅读全文
摘要：
update fund_nav set nav_chg_rate=left(nav_chg_rate, length(nav_chg_rate)-1) where right(nav_chg_rate, 1) != '%' and nav_chg_rate != ' 0000' Error Code 阅读全文
摘要：
select uc.table_name, uc.r_constraint_name, ucc.table_name, listagg(ucc.column_name, ',') within group (order by ucc.column_name) over (partition by u 阅读全文
摘要：
直接用19c导出的dmp文件导入到12c，报错： ORA-39002: invalid operation ORA-39358: Export dump file version 19.0.0.0.0 not compatible with target version 12.2.0 解决方法： 重 阅读全文
摘要：
reference: https://blog.csdn.net/dandandeshangni/article/details/485442211. 在运行/调试 配置对话框的Startup/Connection面板中，勾选Pass environment variables.并添加一个envir 阅读全文
摘要：
C:\Users\Jilil>mysql -u root -pEnter password: *************ERROR 1040 (HY000): Too many connectionsC:\Users\Jilil>C:\Users\Jilil>java.sql.SQLNonTrans 阅读全文
摘要：
reference: https://webgeest.blogspot.com/2015/07/ora-39083-ora-02304-on-impdp-datapump.html 解决方法： 添加选项 TRANSFORM=ODI:N:TYPE or TRANSFORM=ODI:N 我之前还辛苦的 阅读全文
摘要：
oracle 在杀会话时，会出现杀不掉的情况。 原因是在回滚大事物 解决方法： alter system disconnect session 'sid, serial#' immediate; or alter system disconnect session 'sid, serial#' po 阅读全文
摘要：
reference: https://www.akadia.com/services/ora_optimize_undo.html#:~:text=Turning%20on%20automatic%20undo%20management,tablespace%20and%20set%20UNDO_M 阅读全文
摘要：
su - oracle sqlplus /nolog conn / as sysdba select * from v$flash_recovery_area_usage; select sum(percent_space_used)*3/100 from v$flash_recovery_area 阅读全文
摘要：
Reference: https://cloudlinux.zendesk.com/hc/en-us/articles/115004075294-Fix-rpmdb-Thread-died-in-Berkeley-DB-library[installadmin@dnafexpapp003 ~]$ y 阅读全文
摘要：
reference:https://www.cnblogs.com/XQiu/p/5212787.html--以下几个为相关表SELECT * FROM v$lock;SELECT * FROM v$sqlarea;SELECT * FROM v$session;SELECT * FROM v$pr 阅读全文
摘要：
Reference: https://stackoverflow.com/questions/35037288/incorrect-decimal-integer-value-mysql Error Code: 1366. Incorrect DECIMAL value: '0' for colum 阅读全文
摘要：
Reference：https://stackoverflow.com/questions/11448068/mysql-error-code-1175-during-update-in-mysql-workbench Error Code: 1175. You are using safe upd 阅读全文
摘要：
netsh wlan show profile name="WIFINAME-Test" key=clear C:\windows\system32> C:\windows\system32>netsh wlan show profile name="WIFINAME-Test" key=clear 阅读全文
摘要：
oracle ORA-01114 IO error writing block to file 207 (block # ) Reference: https://stackoverflow.com/questions/20961832/ora-01114-io-error-writing-bloc 阅读全文
摘要：
centos 修改系统时间 [echo0282@instance-1 ~]$ sudo timedatectl set-timezone Asia/Shanghai timedatefctl list-timezone | grep Asia 阅读全文
摘要：
sudo apt-get install tomcat8-admin tomcat8-docs tomcat8-examplessudo vi /etc/tomcat8/tomcat-users.xmladd line: <user username="admin" password="passwo 阅读全文
摘要：
Reference: https://stackoverflow.com/questions/38986910/intellij-idea-address-localhost1099-is-already-in-use Solution: netstat -aon | find "1099" tas 阅读全文