Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

OracleÁÙʱ±íʹÓÃÎÊÌâ - Oracle / ¿ª·¢

ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º
ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£
³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......

oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí

×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐР
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
 SEQUENCE# APP
---------- ---
  13 NO
  13 YES ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ