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´æ´¢ ÏÖÔÚæ,»Ø¼Ò¿´Óпղ»......
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
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 / ......
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 ......