十二種常用的英文標點符號

常用的英文標點符號有十二種

1.Apostrophe 上標點(')  
2.Comma 逗號(,)  
3.Colon 冒號(:)  
4.Dash 破折號(--)  
5.Exclamation Point 驚嘆號(!)  
6.Hyphen 連字號(-) 
7.Parentheses 括號( )  
8. Period 句號(．)  
9. Question Mark 問號 (?) 
lO.Quotation Marks 引號("…")   
11.Semicolon 分號(;)  
l2.Triple Dots 刪節號(…)

MySQL dump (import and export)

C:\mysqldump --user=root -p OLD_DBNAME > c:\test.sql
C:\mysqldump --user=root -p NEW_DBNAME < c:\test.sql

判斷Excel的值並複製到新的分頁

Sub Macro1()
 
   '在Sheet1執行巨集
   Sheet1.Activate
 
   '定義參數
   Dim k As Long, Km As Long

   '從1開始
   Km = 1

   '複製抬頭
   Sheet2.Rows(1).Value = Rows(1).Value
 
   For k = 2 To Range("E65536").End(xlUp).Row
 
      'E欄位
      With Range("E" & k)
   
         If .Value = 3 And .Value <> "" Then
     
            Km = Km + 1
         
            '將k列的資料複製到 Sheet2的Km列
            Sheet2.Rows(Km).Value = Rows(k).Value
         
         End If
      End With
   Next k
 
End Sub

Update sql with join table

update TABLE_A
set TABLE_A.COLUMN_A = TABLE_B.COLUMN_A
from TABLE_A
join TABLE_B on TABLE_A.COLUMN_PK = TABLE_B.COLUMN_PK

Use '&' in oracle Database

oracle 裡面
[ & ]後面的字串會當做變數處理(變數首碼符號)

set define off;

insert ......

set define on

oracle 自動新增欄位 procedure

SET SERVEROUTPUT ON; --ENABLE

EXEC DBMS_OUTPUT.ENABLE(1000000);

DECLARE

B NUMBER;

BEGIN

SELECT COUNT(*)

INTO B

FROM USER_TAB_COLUMNS

WHERE TABLE_NAME = 'TABLE_A' AND COLUMN_NAME = 'COLUMN_A';

IF B = 0

THEN

EXECUTE IMMEDIATE 'ALTER TABLE TABLE_A ADD(COLUMN_A NVARCHAR2(100) DEFAULT ''IB'' )';

DBMS_OUTPUT.PUT_LINE('ALTER TABLE TABLE_A ADD(COLUMN_A NVARCHAR2(100) DEFAULT ''IB'' )');

END IF;

END;

oracle drop database

shutdown abort;
startup mount exclusive restrict;
drop database_name;
exit;

Oracle imp/exp file

exp userid/password@SID file=d:\file_name.dmp full=y;

imp userid/password@SID file=d:\file_name.dmp ignore=y tables=(table1);
tables=(table1) is option

MS SQL rename table

ALTER TABLE tablename RENAME TO footable

EXEC sp_rename 'OldTableName', 'NewTableName'

EXEC sp_rename
   @objname = 'TableName.OldColumnName',
   @newname = 'NewColumnName',
   @objtype = 'COLUMN'

Oracle marge into

若符合條件則 update，
否則 insert

MERGE INTO Table1 target
USING Table2 source
ON (target.COLUMN1 = source.COLUMN1)
WHEN MATCHED THEN UPDATE SET taeged.COLUMN2 = source.COLUMN2
WHEN NOT MATCHED THEN
INSERT /** (target.COLUMN1, target.COLUMN2, target.COLUMN3) **/
VALUES (source.COLUMN1, source.COLUMN2, source.COLUMN3)
;