/etc/network/interfaces

auto eth0
iface eth0 inet static
        address 10.56.34.38
        netmask 255.255.254.0
        network 10.56.34.0
        broadcast 10.56.35.255
        gateway 10.56.35.254
        # dns-* options are implemented by the resolvconf package, if installed
        dns-nameservers 10.56.34.1 10.56.34.2
        dns-search xxx.com.tw

samba /etc/samba/smb.conf 設定檔

[root@linux ~]# cd /etc/samba
[root@linux samba]# cp smb.conf smb.conf.raw  <==先備份再說！
[root@linux samba]# vi smb.conf
# 先設定好主機方面的參數
[global]
        # 與主機名稱有關的設定資訊 

        # workgroup 可以是domain name

        workgroup     = HUKO

        netbios name  = vbirdserver
        server string = This is vbird's samba server

        # 與語系方面有關的設定項目喔，為何如此設定請參考前面的說明
        unix charset    = utf8
        display charset = utf8
        dos charset     = cp950

        # 與登錄檔有關的設定項目，注意變數 (%m)
        log file = /var/log/samba/%m.log
        max log size = 50

        # 這裡才是與密碼有關的設定項目哩！
        security = share

        # 其他預設存在的項目
        socket options = TCP_NODELAY SO_RCVBUF=8192 SO_SNDBUF=8192
        dns proxy = no
        template shell = /bin/false
        winbind use default domain = no

# 底下則是針對 /tmp 的設定而來的！可瀏覽且可寫入喔！
[temp]
        comment   = Temporary file space
        path      = /tmp
        read only = no
        public    = yes

花正當春，人亦年少

人最怕就是動了情

Ubuntu 安裝 sqldeveloper

1:oracle网站下载最新的oracle sql developer 2.1
访问：http://www.oracle.com/technology/software/products/sql/index.html
下载：Oracle SQL Developer for other platforms (This zip does not include a JDK)
sqldeveloper-2.1.0.63.73-no-jre.zip


2：安装jdk
sudo apt-get install sun-java6-jdk
3：为sqldeveloper添加jdk支持
在用户目录下创建
cd $home (桌面用户的根目录)
touch ~/.sqldeveloper/jdk
mkdir -p ~/.sqldeveloper
touch ~/.sqldeveloper/jdk

echo /usr/lib/jvm/java-6-sun > ~/.sqldeveloper/jdk

4：安装sql developer
unzip sqldeveloper-2.1.0.63.73-no-jre.zip
cd sqldeveloper
sh sqldeveloper.sh

5: 中文乱码问题 : 出现乱码是由于java缺少中文字体

cd /usr/lib/jvm/java-6-sun/jre/lib/fonts
sudo mkdir fallback/
sudo cp simsun.ttc fallback/
sudo mkfontdir
sudo mkfontscale

SAP read_text : Batch Short text

SQL 多筆資料成為一筆 by XML functions

1.
with mv as (
            select idnrk,b.small_group
              from sap_bom a,mes_mv_small_class b
             where a.idnrk between 'C00' and 'C62'
               and stlst = '1'
               and a.matnr = b.matnr
               and b.middle_group in ('Top View','Side View','Chip LED','High Power')
             group by idnrk,b.small_group
             order by 1
           )
select idnrk,ltrim(extract(xmlagg(xmlelement("small_group",','||small_group)),'/small_group/text()').getstringval(),',')
       small_groups
  from mv
 group by idnrk

SMALL_GROUPS會以 "," 分隔

Result
IDNRK             SMALL_GROUPS
C01RZ0109-000A    3804
C01RZ0109-001A    3804
C01RZ0109-002A    3804
C01RZ0431-000B    5050
C01RZ0431-001B    5050
C01RZZ613-001A    3804
C01RZZ813-000A    1615
C01RZZ913-001A    0603RE
C01RZZ913-002A    0603RE
C01RZZ913-003A    0603RE
C02RZZ913-000A    0603AM
C02RZZ913-001A    0603AM
C03RZZ713-000A    0603YL
C03RZZ813-000A    0603YL
C03RZZ913-000A    0603YL
C03RZZ913-001A    0603YL
C04RZZ913-000A    0603YG
C04RZZ913-001A    0603YG
C05RA2603-000A    0603GS,1615
C05RA2603-001A    0603GS,1615
C05RA2603-002A    0603GS,1615
C05RA2603-003A    0603GS,1615
C05RA2603-008A    0603GS

2.
with mv as (
            select empno, b.codevalue ktsch
              from dwmgr.mes_tbl_certification a,hr_tbl_codedetail b
             where a.ktsch = b.codeid
             group by empno,b.codevalue
             order by 1,2
           )
select empno,ltrim(extract(xmlagg(xmlelement("ktsch",','||ktsch)),'/ktsch/text()').getstringval(),',')
       ktsch,count(*) cnt
  from mv
 group by empno

EMPNO    KTSCH    CNT
89003    包裝,測試,收發料,捲目    4
89004    收發料,測試    2
90004    捲目    1
90005    包裝,測試    2
90007    PLASMA,打線    2
90008    固晶-Chip,控片    2
90010    包裝,測試    2
90015    壓模,戳膠    2
90017    包裝,測試    2
90019    包裝,測試,收發料    3
90020    戳膠    1
90022    包裝,測試    2
90023    捲目    1
90024    固晶-Chip    1
90028    包裝,測試    2
90030    收發料,測試    2
90031    包裝,測試    2
90036    離心機,點膠    2
90037    打線    1
90038    沖壓,目檢    2
90039    打線,控片    2
91009    封裝膠烘烤,控片    2
91014    切割,目檢,熱測(WB),沖壓,戳膠,封裝膠烘烤,壓模    7
91016    戳膠,沖壓    2
91019    捲目    1
91022    切割,目檢    2
91025    捲目    1
91026    PLASMA,打線    2

產出貢獻度

Sum[ MENGE / ( UPD x OPMCHR ) ] / DDCNT / OPCNT

1. 半天時，實際產出為一半
2. 全天時，人數有兩人 
3. 單位 :