less Page UP or b 向上翻页 Page Down or space 向下翻页 UP Arrow 向上翻一行 Down Arrow 向下翻一行 G 移动到最后 1G or g 移动到开头 /characters 向前查找 n 向前查找下一个出现的字符串，这个字符串

匹配行 ^.*内容.*$ ^.*内容.*\r?\n 删除字符 A之后字符：A.*$ A之前字符：^([^s]*)A 换行: \n

建表 1 2 3 4 5 CREATE INDEX idx_table_name_column_name ON table_name(column_name); CREATE UNIQUE INDEX idx_table_name_column_name ON table_name(column_name); CREATE sequence seq_table_name; COMMENT ON TABLE table_name IS 'table_name'; COMMENT ON COLUMN table_name.column_name IS 'column_name'; 修改表 1 2 3 4 DROP sequence seq_name; ALTER TABLE table_name ADD (column_name datatype,column_name datatype); ALTER TABLE table_name MODIFY (column_name datatype,column_name datatype); ALTER TABLE table_name DROP (column_name,column_name); 复制表 1 CREATE TABLE NEW_TAB AS

批量merge Oracle 参数做判断，需要传入map 1 2 3 4 5 6 <statement id="merge" parameterClass="map"> <iterate property="list" open="begin" close=";end;" conjunction=";"> merge into... <isNotEmpty property="list[].id"> id=id, </isNotEmpty> 不用判断参数，传入list 1 2 3 <statement id="merge" parameterClass="list"> <iterate open="begin" close=";end;" conjunction=";"> merge into... #list[].id# mysql 1 2

settings.xml 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 <?xml version="1.0" encoding="UTF-8"?> <settings xmlns="http://maven.apache.org/SETTINGS/1.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/SETTINGS/1.0.0 http://maven.apache.org/xsd/settings-1.0.0.xsd"> <localRepository>C:\repository</localRepository> <mirrors> <mirror> <id>aliyun</id> <mirrorOf>central</mirrorOf> <name>Nexus aliyun</name> <url>http://maven.aliyun.com/nexus/content/groups/public</url> </mirror> </mirrors> </settings> 脚本 1 2 mkdir %USERPROFILE%\.m2 copy .\settings.xml %USERPROFILE%\.m2\