yesefuhua的专栏

第一種方法:create database link link18myerp    dblink名稱  connect to myerp identified by myerp   用戶名,密碼  using (DESCRIPTION =    (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.150.18)(PORT = 152

 今天遇到一個語句取不到最大值,我的本意是取出part_no中間四位的最大值的那條記錄,語句如下:         SELECT   to_char(max(substr(PART_NO,4,4)),0000)                 INTO  TPART              FROM  DAT_PART            WHERE substr(PART_NO,1,1)