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

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


Ïà¹ØÎÊ´ð£º

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

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

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

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 ......

ORACLE Êý¾Ý¿â·ÖÀë - Oracle / »ù´¡ºÍ¹ÜÀí

ÏÖÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬ÓÐ3¸öÓû§£¬·Ö±ðÓÃÓÚ²»Í¨µÄϵͳ£¬ÏÖÔÚÎÒÐèÒª°ÑÕâÈý¸öϵͳµÄÊý¾Ý¿â·ÖÀ뿪À´£¬×°ÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ¡£ÓÐŪ¹ýµÄÅóÓÑÇë¸øµãÒâ¼û¡£
²»Í¬ÏµÍ³Ö®¼äÓÐÁªÏµ?

ûÓÐÁªÏµµÄ

exp, imp

ÎÒÒª°ÑÆäÖеÄÁ½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ