Oracle row_number()移除重複
利用row_number()為重複record編號，然後選取 …
Oracle重設identity column
alter table [table_name] modif …
Oracle查找sequence table mapping sequence current/next value
查找Mapping select SEQUENCE_NAME …
Oracle export full database
sysdba登入sqlplus sqlplus / as s …
Oracle 18c開啟Enterprise Manager
開啟EM sqlplus / as sysdba 顯示htt …
oracle常用命令
Listener lsnrctl status #查看lis …
CentOS 更換 java版本
alternatives –config javac al …
SSH to QNAP Container Station
安裝open ssh server 容器設定->進階設 …
Ubuntu18安裝openssh server
sudo apt-get update sudo apt-g …
Appache開啟/關閉SSL
關閉SSL sudo a2dismod ssl …