oracle ͼƬÎÊÌâ
ÎÒÓÃc#.netÏë°ÑͼƬֱ½Ó´æ´¢ÔÚoracleÊý¾Ý¿âÖУ¬ÏÖÔÚ¶Áд²Ù×÷²»ÖªµÀ¸ÃÔõôдÁË£¬
»¹ÓÐÏÖÔÚÔÚSqlServer ÖÐÓÐһЩÊý¾ÝÒ²ÊÇͼƬÀàÐÍ£¨image£©µÄÐèÒªµ¼µ½ oracleÊý¾Ý¿âÖУ¬
Çë¸÷λ¸ßÊÖ°ïæ
1.ÔÚoracleÊý¾Ý¿â½¨Á¢Ò»Ìõº¬blob×ֶεıí
2.ÔÚ±íÖвåÈëÒ»Ìõ¿ÕµÄ¼Ç¼,blob×Ö¶ÎÒª¸ø³öÒýÈëµã£¬ÓÃempty_blob()
3.ÓÃÁ÷¶ÔÕâ¸ö×Ö¶ÎÀ´½øÐжÁд¡£
4.sqlServerÖеÄimageµ¼Èëµ½oracleÖУ¬²»Ì«Çå³þ£¬²»ºÃ˵£¬Çë¸ßÈË¿´°É
д¸ö³ÌÐò¶Á³öimageÈ»ºóÔÙд¾¡oracle¾Í¿ÉÒÔÁË
Ö±½Ó´æµØÖ·
ÄܰѴúÂë·¢ÉÏÀ´Âð£¿Õâ¸öÒâ˼ÎÒÃ÷°×£¬µ«ÊǾÍÊDz»ÖªµÀÔõôд¡£
Éæ¼°µ½Êý¾Ý¿âÇ¨ÒÆÁ˰¡,¶øÇÒÊÇÌØÊâÊý¾ÝÀàÐÍÇ¨ÒÆ,
ÎÒÏëÔÚ³ÌÐòÖÐÍê³ÉÊDZȽÏÀíÏëµÄ°ì·¨
C#Õâ¸öÎÒ»á,·ÖÊýÌ«µÍÁË,²»Ð´--(¹þ¹þ)
--SQL SERVER µÄIMAGEÖ»ÊǼǼÊý¾Ý´æ´¢Ö¸Õë,ÐèÒª½âÎöΪÊý¾ÝÁ÷ºó,ÔÙдÈëORACLEµÄBLOG´æ´¢
ÏÖÔÚæ,»Ø¼Ò¿´Óпղ»......
Ïà¹ØÎÊ´ð£º
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
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 ......
ÏÖÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬ÓÐ3¸öÓû§£¬·Ö±ðÓÃÓÚ²»Í¨µÄϵͳ£¬ÏÖÔÚÎÒÐèÒª°ÑÕâÈý¸öϵͳµÄÊý¾Ý¿â·ÖÀ뿪À´£¬×°ÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ¡£ÓÐŪ¹ýµÄÅóÓÑÇë¸øµãÒâ¼û¡£
²»Í¬ÏµÍ³Ö®¼äÓÐÁªÏµ?
ûÓÐÁªÏµµÄ
exp, imp
ÎÒÒª°ÑÆäÖеÄÁ½ ......