ÔÚoracleÖÐÇóÒ»sql

SQL code:
ÒÑÖª±íÖдæÔÚÒÔÏÂÊý¾Ý
Order_Auto fact
SL2009110001 SL
SL2009110002 SL
SL2009100001 SL
SL2009100003 SL
Order_AutoµÄ×é³ÉÊÇÓÉ factµÄÖµ¼ÓÉÏÄêÔÂÒÔ¼°ËÄλÁ÷Ë®ºÅ£¬
Èç¹ûµ±Ç°ÊÇ09Äê9ÔÂʱ£¬ ÒªÇóµÃµ½ SL2009100001
Èç¹ûµ±Ç°ÊÇ09Äê10ÔÂʱ£¬ÒªÇóµÃµ½ SL2009100004
Èç¹ûµ±Ç°ÊÇ09Äê11ÔÂʱ£¬ÒªÇóµÃµ½ SL2009110003
ÇëÎÊÓÃÒ»Ìõsql¸ÃÈçºÎʵÏÖ£¡

---

decode(to_char(time,'hh24'),'09','SL2009100001','10','SL2009100004','SL2009110003
')

---

factµÄÖµÖ»ÓÐSLÕâÒ»ÖÖÂð?
factµÄÖµ»á²»»á±ä»¯£¿

---

ÕâÑù×ÓµÄÐèÇó,²»¹»ÍêÕû,Èç¹û8ÔÂÊý¾Ý,12ÔµÄÊý¾Ý?

---

select :fact||to_char(sysdate,'yyyymm')||to_char(nvl(max(to_number(substr(Order_Auto,length(Order_Auto)-3)),0),'0000') Order_Auto
from table1
where Order_Auto like :fact||to_char(sysdate,'yyyymm')||'%'

---

Èç¹ûfactµÄÖµ¶¼ÊÇÒ»ÖµĻ°¿ÉÒÔÕâÑù£º
SQL code:
select nvl(max(substr(order_auto,1,8))||trim(to_char(max(substr(order_auto,9,4)+1),'0000')),'SL'||to_char(sysdate,'yyyymm')||'0001') result
from tb where substr(order_auto,3,6) = to_char(sysdate,'yyyymm');

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
htt