ÇóÒ»Ìõ¹ØÓںϲ¢ÄÚÈݵÄsqlÓï¾ä - Oracle / »ù´¡ºÍ¹ÜÀí
Óï¾ä
select t1.scrq,substr(T2.CNAME,0,instr(T2.CNAME,'×¢')-1) Õ¾Ãû,T1.BBH,T1.RBCKSL,T1.RYDL,T1.BCKYL,T1.GXYL
from dmba01 T1,SJZD T2 where TO_CHAR(SCRQ,'YYYYMMDD')='20100504' AND T1.ZM='ZS01' AND T1.ZM=T2.DM
½á¹ûΪ
2010-5-4 ÐÓÊ®ÎåÒ» 1
2010-5-4 ÐÓÊ®ÎåÒ» 2 7586 38520 14.20 14.10
2010-5-4 ÐÓÊ®ÎåÒ» 3
2010-5-4 ÐÓÊ®ÎåÒ» 4
ÏëµÃµ½½á¹û
2# 1# 3# 4# 2010-05-04 ÐÓÊ®ÎåÒ» 7586 38520 14.20 14.10
¾ÍÊǰѳýÁËscrq¡¢CNAME¡¢BBH²»¿ÕµÄ¼Ç¼ÖÐBBH£¨3¸ö£©ºÏ²¢³ÉÒ»¸ö×ֶβé³öÀ´
ÇëÎÊÔõôдÓï¾ä
create table DMBA01
(
CM VARCHAR2(10) not null,
KM VARCHAR2(10) not null,
ZM VARCHAR2(10) not null,
SCRQ DATE not null,
BGG VARCHAR2(2) not null,
BBH VARCHAR2(2) not null,
LSSZLX VARCHAR2(1) not null,
BCKYL NUMBER(4,2),
BRKYL NUMBER(4,2),
GXYL NUMBER(4,2),
BGYC NUMBER(4,2),
LL NUMBER(4,1),
DL NUMBER(4),
DY NUMBER(5),
GLYS NUMBER(3,2),
JKSW NUMBER(4,2),
CKSW NUMBER(4,2),
WC NUMBER(4,2),
RBCKSL NUMBER(7),
RYDL NUMBER(7),
DJXL NUMBER(5,2),
YXSS NUMBER(6,2),
BX NUMBER(5,2),
BSDH NUMBER(6,4),
LJYXSS NUMBER(9,2),
RYX
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......