Oracle explain plan
先將要解釋的sql用explain plan for作解釋 …
Oracle connect by level
生成全年日期 select to_date(‘2023010 …
[Windows] Oracle Unable to OpenSCManager: err=5
用系統管理員身份運行lsnrctl start即可
[Oracle] TNS-12545: Connect failed because target host or object does not exist
vi /u01/app/oracle/product/19. …
[Oracle] 19c on Oracle Linux 8 Unexpected error while executing the action at state: ‘supportedOSCheck’
$ vi /u01/app/oracle/product/1 …
[Oracle / Mysql] 返回第一個非null值
select coalesce(null,’abc’,nul …
[Oracle] Oracle實現column累加
select [fields],sum(field) ove …
Oracle 12c 啟動 PDB
alter pluggable database [pdb …
Oracle 字串相似度
使用SYS.UTL_MATCH.edit_distance_ …
[Oracle]尋找並kill指定session
select p.SPID, s.username, s.s …