2019-06-01から1ヶ月間の記事一覧
Ubuntu (16)(18) apt install ufw ufw status ufw disable ※OCIの場合、下記も確認必要iptables -L Debian (9) apt install ufw ufw status ufw disable CentOS (7) systemctl disable firewalldsystemctl stop firewalldsystemctl status firewalld firewal…
Ubuntu (16)(18)apt updateapt upgrade Debian (9) vi /etc/apt/sources.list deb http://ftp.jp.debian.org/debian/ stretch maindeb-src http://ftp.jp.debian.org/debian/ stretch main deb http://security.debian.org/debian-security stretch/updates …
Ubuntu (16)(18)apt install openssh-server systemctl enable sshsystemctl restart ssh Debian (9)apt install openssh-server systemctl enable sshsystemctl restart ssh CentOS (7) yum install openssh-server systemctl enable sshdsystemctl restart…
Ubuntu (16) ----NetworkManagerを使う場合nmtui ----NetworkManagerを使わない場合 systemctl stop NetworkManagersystemctl disable NetworkManager vi /etc/network/interfaces auto loiface lo inet loopback auto ens33iface ens33 inet staticaddress …
Oracle set timing on drop table tab1;create table tab1(col1 int); declarebegin for i in 1..1000000 loop insert into tab1 values(i); commit; end loop;end;/ select sum(bytes) from user_segments where segment_name = 'TAB1'; alter table tab1 a…
Oracle select DUMP('a',16) from dual;select DUMP('あ',16) from dual; select DUMP('a',1016) from dual;select DUMP('あ',1016) from dual; SELECT UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('61')) FROM DUAL;SELECT UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('E381…
Oracle create table tab1(col1 int,col2 int); insert into tab1 values(1,100);insert into tab1 values(1,110);insert into tab1 values(1,120);insert into tab1 values(2,100);insert into tab1 values(2,200);insert into tab1 values(3,10);insert in…
Oracle プロプラエタリのため、作成不可 MySQL https://blog.infobuild.jp/e/?c=201902010745https://gihyo.jp/dev/serial/01/mysql-road-construction-news/0084https://norikone.hatenablog.com/entry/2018/12/29/MySQL%E3%81%AE%E3%82%B9%E3%83%88%E3%83%…
MySQL (8.0.22) drop table tab22;create table tab22(col1 int,col2 int);create index ind22 on tab22(col2);alter table tab22 add constraint tab22pk primary key(col1); show create table tab22;show create table tab22rename; -- テーブル名の変更a…