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

oracle ͼƬÎÊÌâ

ÎÒÓÃc#.netÏë°ÑͼƬֱ½Ó´æ´¢ÔÚoracleÊý¾Ý¿âÖУ¬ÏÖÔÚ¶Áд²Ù×÷²»ÖªµÀ¸ÃÔõôдÁË£¬
»¹ÓÐÏÖÔÚÔÚSqlServer ÖÐÓÐһЩÊý¾ÝÒ²ÊÇͼƬÀàÐÍ£¨image£©µÄÐèÒªµ¼µ½ oracleÊý¾Ý¿âÖУ¬
Çë¸÷λ¸ßÊÖ°ïæ
1.ÔÚoracleÊý¾Ý¿â½¨Á¢Ò»Ìõº¬blob×ֶεıí
2.ÔÚ±íÖвåÈëÒ»Ìõ¿ÕµÄ¼Ç¼,blob×Ö¶ÎÒª¸ø³öÒýÈëµã£¬ÓÃempty_blob()
3.ÓÃÁ÷¶ÔÕâ¸ö×Ö¶ÎÀ´½øÐжÁд¡£
4.sqlServerÖеÄimageµ¼Èëµ½oracleÖУ¬²»Ì«Çå³þ£¬²»ºÃ˵£¬Çë¸ßÈË¿´°É

д¸ö³ÌÐò¶Á³öimageÈ»ºóÔÙд¾¡oracle¾Í¿ÉÒÔÁË

Ö±½Ó´æµØÖ·

ÒýÓÃ
1.ÔÚoracleÊý¾Ý¿â½¨Á¢Ò»Ìõº¬blob×ֶεıí
2.ÔÚ±íÖвåÈëÒ»Ìõ¿ÕµÄ¼Ç¼,blob×Ö¶ÎÒª¸ø³öÒýÈëµã£¬ÓÃempty_blob()
3.ÓÃÁ÷¶ÔÕâ¸ö×Ö¶ÎÀ´½øÐжÁд¡£
4.sqlServerÖеÄimageµ¼Èëµ½oracleÖУ¬²»Ì«Çå³þ£¬²»ºÃ˵£¬Çë¸ßÈË¿´°É

ÄܰѴúÂë·¢ÉÏÀ´Âð£¿Õâ¸öÒâ˼ÎÒÃ÷°×£¬µ«ÊǾÍÊDz»ÖªµÀÔõôд¡£

Éæ¼°µ½Êý¾Ý¿âÇ¨ÒÆÁ˰¡,¶øÇÒÊÇÌØÊâÊý¾ÝÀàÐÍÇ¨ÒÆ,
ÎÒÏëÔÚ³ÌÐòÖÐÍê³ÉÊDZȽÏÀíÏëµÄ°ì·¨
C#Õâ¸öÎÒ»á,·ÖÊýÌ«µÍÁË,²»Ð´--(¹þ¹þ)

--SQL SERVER µÄIMAGEÖ»ÊǼǼÊý¾Ý´æ´¢Ö¸Õë,ÐèÒª½âÎöΪÊý¾ÝÁ÷ºó,ÔÙдÈëORACLEµÄBLOG´æ´¢

ÏÖÔÚæ,»Ø¼Ò¿´Óпղ»......


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

oracle Ö´ÐÐ˳Ðò - Oracle / »ù´¡ºÍ¹ÜÀí

SQL code:

declare
v_deptno number(2);
v_dname varchar2(14);
begin
dbms_output.put_line('ÇëÊäÈ벿ÃźźͲ¿ÃÅÃû:');
v_deptno:=&deptno;
v_dname:='&dname';
insert into dept01(deptno,dnam ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ