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

oracle²»Í¬°æ±¾¼äÊý¾ÝµÄµ¼Èëµ¼³ö


oracle²»Í¬°æ±¾¼äÊý¾ÝµÄµ¼Èëµ¼³ö
OracleµÄimp/exp×é¼þÊÇÎÒÃdz£ÓõŤ¾ß£¬ËüµÄÒ»¸ö²Ù×÷Ô­Ôò¾ÍÊÇÏòϼæÈÝ¡£ÏÂÃæÊǾݴË×ܽáµÄ¼¸¸öʹÓùæÔòºÍÏà¹Ø²âÊÔ£º
 
¹æÔò1£ºµÍ°æ±¾µÄexp/imp¿ÉÒÔÁ¬½Óµ½¸ß°æ±¾£¨»òͬ°æ±¾£©µÄÊý¾Ý¿â·þÎñÆ÷£¬µ«¸ß°æ±¾µÄexp/imp²»ÄÜÁ¬½Óµ½µÍ°æ±¾µÄÊý¾Ý¿â·þÎñÆ÷
 
1.1 ʹÓÃ9i¿Í»§¶Ëͨ¹ýimpÁ¬½Óµ½10gÊý¾Ý¿â
 
C:\Documents and Settings\yuechaotian>exp userid=hdtest/test@s67 tables=(ab01) rows=n file=d:\x.dmp
 
Export: Release 9.2.0.1.0 - Production on ÐÇÆÚÈý 2ÔÂ 20 10:09:55 2008
 
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
 
Á¬½Óµ½: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Òѵ¼³ö ZHS16GBK ×Ö·û¼¯ºÍ AL16UTF16 NCHAR ×Ö·û¼¯
×¢: ½«²»»áµ¼³ö±íÊý¾Ý£¨ÐУ©
 
¼´½«µ¼³öÖ¸¶¨µÄ±íͨ¹ý³£¹æ·¾¶ ...
. . ÕýÔÚµ¼³ö±í                            AB01
ÔÚûÓо¯¸æµÄÇé¿öϳɹ¦ÖÕÖ¹µ¼³ö¡£
 
 
1.2 ʹÓÃ10g¿Í»§¶Ëͨ¹ýimpÁ¬½Ó9iÊý¾Ý¿â£ºÁ¬½Óʧ°Ü£¨¶ø²»Êǵ¼³öʧ°Ü£©
 
C:\Documents and Settings\yuechaotian>exp userid=hbjb_kf_hd/test@s46 owner=hdtest file=d:\x.dmp
 
Export: Release 10.2.0.1.0 - Production on ÐÇÆÚÈý 2ÔÂ 20 09:57:22 2008
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
EXP-00056: Óöµ½ ORACLE ´íÎó 6550
ORA-06550: µÚ 1 ÐÐ, µÚ 41 ÁÐ:
PLS-00302: ±ØÐë˵Ã÷ 'SET_NO_OUTLINES' ×é¼þ
ORA-06550: µÚ 1 ÐÐ, µÚ 15 ÁÐ:
PL/SQL: Statement ignored
EXP-00000: µ¼³öÖÕֹʧ°Ü
 
 
 
¹æÔò2£º¸ß°æ±¾exp³öµÄdmpÎļþ£¬µÍ°æ±¾ÎÞ·¨imp£¨ÎÞ·¨Ê¶±ðdmpÎļþ£©
 
2.1 ʹÓÃ10g¿Í»§¶Ëexp³ö10gµÄÊý¾Ý
 
C:\Documents and Settings\yuechaotian>exp userid=test/test@orcl owner=test file=d:\10g.dmp
 
Export: Release 10.2.0.1.0 - Production on ÐÇÆÚÈý 2ÔÂ 20 11:16:39 2008
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
Á¬½Óµ½


Ïà¹ØÎĵµ£º

ÓÃjavaµ÷ÓÃoracle´æ´¢¹ý³Ì×ܽá

ÉùÃ÷£º
ÒÔϵÄÀý×Ó²»Ò»¶¨ÕýÈ·£¬Ö»ÊÇΪÁËÑÝʾ´ó¸ÅµÄÁ÷³Ì¡£
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
CREATE OR REPLACE PROCEDURE TESTA(PARA1 IN VARCHAR2,PARA2 IN VARCHAR2)  AS
BEGIN
   INSERT INTO HYQ.B_ID (I_ID,I_NAME) VALUES (PARA1, PARA2);
END TESTA;
È»ºóÄØ£¬ÔÚjavaÀïµ÷ÓÃʱ¾ÍÓÃÏÂÃæµÄ´ ......

mysql,sqlserver,oracleÈýÖÖÊý¾Ý¿âµÄ´ó¶ÔÏó´æÈ¡

mysql ´ó¶ÔÏó´æÈ¡:
¡¡¡¡ÀàÐÍÒ»°ãÓ¦¸ÃÓÃmediumblod,
¡¡¡¡blobÖ»ÄÜ´æ2µÄ16´Î·½¸öbyte,
¡¡¡¡mediumblodÊÇ24´Î·½,
¡¡¡¡Ò»°ãÀ´Ëµ¹»ÓÃÁË.longblobÊÇ32´Î·½ÓÐЩ´ó.
¡¡¡¡MYSQLĬÈÏÅäÖÃÖ»ÄÜ´æ1M´óСµÄÎļþ,ÒªÐÞ¸ÄÅäÖÃ,WIN°æ±¾µÄÔÚmysql.iniÎļþÖÐ
¡¡¡¡ÐÞ¸Ämax_allowed_packet,net_buffer_lengthµÈ¼¸¸ö²ÎÊý,»òÖ±½ÓSET GLOBAL va ......

sqlserverÒÆֲΪOracle±Ê¼Ç

Oracle±Ê¼Ç
l         ¹ØÓÚTRUNCº¯Êý
   SELECT
   RELATED_ID ,
      DOC_ID ,
      CAT_ID ,
      CAT_CODE ,
      RELEASE_DATE ,
&n ......

SQLServerºÍOracle³£Óú¯Êý¶Ô±È


Êýѧº¯Êý
ÔÚoracle ÖÐdistinct¹Ø¼ü×Ö¿ÉÒÔÏÔʾÏàͬ¼Ç¼ֻÏÔʾһÌõ
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:select floor(-1.001) value ......

Oracle SQLµÄÓÅ»¯


SQLµÄÓÅ»¯Ó¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æСÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
SQLÓï¾ä£º
ÊǶÔÊý¾Ý¿â(Êý¾Ý)½øÐвÙ×÷µÄΩһ;¾¶£»
ÏûºÄÁË70%~90%µÄÊý¾Ý¿â×ÊÔ´£»¶ÀÁ¢ÓÚ³ÌÐòÉè¼ÆÂß¼­£¬Ïà¶ÔÓÚ¶Ô³ÌÐòÔ´´úÂëµÄÓÅ»¯£¬¶ÔSQLÓï¾äµÄÓÅ» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ