指令:
$ vim ~/.vimrc
若裡面有內容,在首行加上:
syntax on
min-width: 1000px; /* 在Firefox,Chrome,Opera有效 */
width: expression(document.body.clientWidth < 1000? "1000px": "auto" ); /* 在IE有效 */
/* Start – Code Snippet */
code {
background: grey;
border: solid black;
border-width: 1px 1px 1px 10px;
font: 13px 'Courier New', Courier, monospace;
line-height: 16px;
margin: 5px 5px 5px 5px;
padding: 5px 5px 5px 5px;
color: white;
display: block;
}
/* End – Code Snippet */
$ awk "/^__ARCHIVE_BELOW__/ {print NR + 1; exit 0; }" aliedit.sh
$ mkdir alipay_plugin
$ tail -n+95 aliedit.sh | tar xzvm -C alipay_plugin
$ install -D -m644 lib/libaliedit64.so /usr/lib/mozilla/plugins/libaliedit64.so
$ install -D -m644 lib/libaliedit32.so ~/.mozilla/plugins/libaliedit32.so
$
sqlplus username/password@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=IP or hostname)(Port=port))(CONNECT_DATA=(SID=sid)))"
$ sqlplus / as sysdba
> SELECT value FROM v$parameter WHERE name='background_dump_dest';
> show parameter BACKGROUND_DUMP_DEST
SELECT *
FROM Orders
LEFT JOIN OrderLines ON OrderLines.OrderID=Orders.ID AND Orders.ID=12345
SELECT *
FROM Orders
LEFT JOIN OrderLines ON OrderLines.OrderID=Orders.ID
WHERE Orders.ID = 12345
cat /etc/passwd | cut -d: -f1
cat /etc/group | cut -d: -f1
cat /etc/passwd | cut -d: -f1
SELECT
user_tab_columns.column_name Column_Name,
user_tab_columns.data_type Format,
NVL2(user_cons_columns.constraint_name, 'YES', '') Primary_Key,
CASE
WHEN user_tab_columns.nullable='Y' THEN 'NO'
WHEN user_tab_columns.nullable='N' THEN 'YES'
END Mandatory,
user_tab_columns.table_name
FROM user_cons_columns
LEFT JOIN user_constraints ON (user_cons_columns.constraint_name=user_constraints.constraint_name)
RIGHT OUTER JOIN user_tab_columns ON (user_cons_columns.table_name=user_tab_columns.table_name AND user_cons_columns.column_name=user_tab_columns.column_name AND user_constraints.constraint_type='P')
ORDER BY user_tab_columns.table_name, user_tab_columns.column_id;
SELECT
user_tab_columns.column_name Column_Name,
CASE
WHEN user_tab_columns.data_type LIKE '%CHAR%' THEN user_tab_columns.data_type || '(' || user_tab_columns.char_length || ' CHAR)'
ELSE user_tab_columns.data_type
END Format,
NVL2(user_cons_columns.constraint_name, 'YES', '') Primary_Key,
CASE
WHEN user_tab_columns.nullable='Y' THEN 'NO'
WHEN user_tab_columns.nullable='N' THEN 'YES'
END Mandatory,
user_tab_columns.table_name
FROM user_cons_columns
LEFT JOIN user_constraints ON (user_cons_columns.constraint_name=user_constraints.constraint_name)
RIGHT OUTER JOIN user_tab_columns ON (user_cons_columns.table_name=user_tab_columns.table_name AND user_cons_columns.column_name=user_tab_columns.column_name AND user_constraints.constraint_type='P')
ORDER BY user_tab_columns.table_name, user_tab_columns.column_id;
echo "blacklist pcspkr" > /etc/modprobe.d/nobeep.conf
SAVE_VOLUME="yes"
echo "alsactl restore -f ~/.asoundrc" >> ~/.bash_login
echo "alsactl store -f ~/.asoundrc" >> ~/.bash_login
pacman -S libusb usbutils
pacman -S usb_modeswitch
lsusb
Bus 004 Device 009: ID 19d2:0166 ONDA Communication S.p.A.
vim /usr/share/usb_modeswitch/19d2:0166
DefaultVendor= 0x19d2
DefaultProduct=0x0166
TargetVendor= 0x19d2
TargetProduct= 0x0167
MessageEndpoint=0x01
MessageContent="55534243e856e2892400000080000685000000240000000000000000000000"
CheckSuccess=20
Bus 004 Device 010: ID 19d2:0167 ONDA Communication S.p.A.
modprobe -v option
echo -n "19d2 0167" > /sys/bus/usb-serial/drivers/option1/new_id
pacman -S wvdial
wvdialconf
[Dialer Defaults]
Init1 = ATZ
Init2 = ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0
# Init command for ZTE 4G modem
#auto (default)
#Init3 = AT+ZSNT=0,0,0
#只使用GPRS
#Init3 = AT+ZSNT=1,0,0
#GPRS優先
#Init3 = AT+ZSNT=0,0,1
#只使用3G
#Init3 = AT+ZSNT=0,0,2
#3G優先
#Init3 = AT+ZSNT=2,0,0
#只使用LTE
Init3 = AT+ZSNT=6,0,0
#LTE優先(此指命經測試並未成功)
#Init3 = AT+ZSNT=0,0,6
Modem Type = Analog Modem
Phone = *99#
ISDN = 0
Password = any
Username = any
Modem = /dev/ttyUSB2
#Baud = 9600
Baud = 460800
Stupid Mode = 1
wvdial &
ALTER SEQUENCE sequence_name INCREMENT BY 156; --令序列的遞增量每次為156,那下個序列號就是256了。
SELECT sequence_name.nextval FROM dual; --令序列號達到下個序列號(256),他就會自己重設了。
ALTER SEQUENCE sequence_name INCREMENT BY 1; --令序列號的遞增量變回原來的值,這裡假設每次遞增1。
SELECT table_name, constraint_name, r_constraint_name, status
FROM user_constraints
WHERE constraint_type = 'R'
AND r_constraint_name in
(
SELECT constraint_name from user_constraints
WHERE constraint_type in ('P', 'U')
AND UPPER(table_name) = UPPER('table_name')
)
ORDER BY table_name, constraint_name;
SELECT table_name, constraint_name, r_constraint_name, status
FROM user_constraints
WHERE constraint_type = 'R'
AND UPPER(table_name) = UPPER('table_name')
ORDER BY table_name;
SELECT * FROM student WHERE classname = '&classname';
SELECT * FROM student WHERE student_name = 'Jr. Sledgehammer & Maul';
SET DEFINE OFF;
No wired connection present, attempting to autoconnect to
wireless network
dhcpcd -k eth0
dhcpcd -bn eth0
echo "dhcpcd -k eth0" >> /etc/rc.local
echo "dhcpcd -bn eth0" >> /etc/rc.local
wget http://libqq-pidgin.googlecode.com/files/libqq-pidgin.0.71_x64.tar.gz
tar xzf libqq-pidgin.0.71_x64.tar.gz
cp ./libqq.so /usr/lib/purple-2/
chmod 755 /usr/lib/purple-2/libqq.so
wget http://libqq-pidgin.googlecode.com/files/libqq.so_0.71_i386.7z
7z x libqq.so_0.71_i386.7z
(請確認為有安裝7zip)cp ./libqq.so /usr/lib/purple-2/
chmod 755 /usr/lib/purple-2/libqq.so
SELECT student_number, name, class FROM student ORDER BY enrollment_year DESC LIMIT 10, 20;
SELECT * FROM (SELECT student_number, name, class FROM student WHERE enrollment_year>2010) WHERE ROWNUM BETWEEN 11 AND 20;
ROWNUM>10 AND ROWNUM<=20
SELECT * FROM (SELECT student_number, name, class FROM student WHERE enrollment_year>2010) WHERE ROWNUM>10 AND ROWNUM<=20;
cat /proc/sys/kernel/shmmax
du -h ~/.avast/400.vps
sysctl -w kernel.shmmax=52428800
#!/bin/bash
#boost shmmax to 50MB
#then start avast!
sudo sysctl -w kernel.shmmax=52428800
nohup avastgui > /dev/null &