Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÒ»Ìõ¹ØÓںϲ¢ÄÚÈݵÄ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


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......

ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

×Ö¶Î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·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

oracle ÈçºÎµ÷ÓÃmssql´æ´¢¹ý³Ì - Oracle / ¸ß¼¶¼¼Êõ

oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ