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

OracleϵÁУºÍ¼Æ¬µÄ´æ´¢

 OracleϵÁУºÍ¼Æ¬µÄ´æ´¢
Ò»£ºÊ²Ã´ÊÇ´ó¶ÔÏ󣬴ó¶ÔÏó»ù±¾²Ù×÷£¿
 ²Î¼ûÎÒµÄBLOG£ºOracleϵÁУºLOB´ó¶ÔÏó´¦Àí
 http://blog.csdn.net/qfs_v/archive/2008/05/21/2464599.aspx
 
¶þ£¬Í¼Æ¬µÄ´æ´¢»ò¶þ½øÖÆÎļþµÄ´æ´¢
 1£¬ÏȲåÈëÆÕͨÊý¾Ý£¬Óöµ½´ó¶ÔÏóÁÐʹÓÃempty_blob()¹¹Ôì¿ÕµÄÖ¸Õë¡£
  Àý×Ó£º
  /*
   conn scott/tiger;
   Create TableSpace ts5_21;
  */
   Create Table MyLob
   (
     no number(8) primary key,
     fname varchar2(30),
     myfile blob
   )
   Lob (myfile) Store As
   (
     Tablespace ts5_21
     Chunk 15K
     Disable Storage In Row
   );
 
  Insert Into MyLob Values(1,'IMG_0210.JPG',empty_blob());
 
 2£¬´´½¨Âß¼­Ä¿Â¼MYDIR
  Create Directory  MYDIR As 'E:\Oracle';
 
 3£¬ÉùÃ÷Ò»¸öBLOBÀàÐͱäÁ¿£¬Ê¹ÓÃselect into Óï¾äÈÃÆäÖ¸Ïòµ½empty_blob()¹¹Ôì¿ÕµÄÖ¸ÕëËùÖ¸ÏòµÄ´æ´¢¿Õ¼ä
    Select myfile Into BLOBÀàÐͱäÁ¿  from myLob Where no = 1 FOR UPDATE;
 
 4£¬ÉùÃ÷Ò»¸öBFileÀàÐͱäÁ¿£¬¹ØÁªÂß¼­Ä¿Â¼ºÍÎïÀíĿ¼Îļþ£¬Ê¹Óà BFileName() ½«ÆäÖ¸Ïòµ½´ý´æ´¢µÄÎļþ¡£
    BFileÀàÐͱäÁ¿ := BFileName('MYDIR','IMG_0210.JPG');
 
 5£¬Ê¹ÓÃDBMS_LOB.open()·½·¨½«BFileÀàÐͱäÁ¿ËùÖ¸ÏòµÄÎļþ´ò¿ª
    DBMS_LOB.Open(BFileÀàÐͱäÁ¿);
 
 6£¬Ê¹ÓÃDBMS_LOB.loadfromfile()·½·¨½«BFileÀàÐͱäÁ¿ËùÖ¸ÏòµÄÎļþ¶ÁÈëµ½BLOBÀàÐͱäÁ¿ËùÖ¸ÏòµÄ´æ´¢¿Õ¼ä
    DBMS_LOB.LoadfromFile(BLOBÀàÐͱäÁ¿,BFileÀàÐͱäÁ¿,DBMS_LOB.getlength(BFileÀàÐͱäÁ¿));
 
 7£¬Ê¹ÓÃDBMS_LOB.close()·½·¨½«bfileµÄ±äÁ¿ËùÖ¸ÏòµÄÎļþ¹Ø±Õ
    DBMS_LOB.Close(BFileÀàÐͱäÁ¿);
 
 8£¬Ìá½»ÊÂÎñ
    Commit;
 
 Àý×Ó;
  Declare
     varB blob;
     varF Bfile;
  Begin
 


Ïà¹ØÎĵµ£º

Á¬½Óoracle£¬sqlserverÖÐÊý¾Ý¿âµÄʾÀý´úÂë

Ò» ÔÚOracleÖÐÁ¬½ÓÊý¾Ý¿â
public class Test1 {
 public static void main(String[] args) {
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   Connection conn = DriverManager.getConnection(
       &nbs ......

Oracle CASE±í´ïʽ


CASE±í´ïʽ¿ÉÒÔÔÚSQLÖÐʵÏÖif-then-elseÐ͵ÄÂß¼­£¬¶ø²»±ØÊ¹ÓÃPL/SQL¡£CASEµÄ¹¤×÷·½Ê½ÓëDECODE()ÀàËÆ£¬µ«Ó¦¸ÃʹÓÃCASE,ÒòΪËüÓëANSI¼æÈÝ¡£
CASEÓÐÁ½ÖÖ±í´ïʽ:
1. ¼òµ¥CASE±í´ïʽ,ʹÓñí´ïʽȷ¶¨·µ»ØÖµ.
Óï·¨:
CASE search_expression
WHEN expression1 THEN result1
WHEN expression2 THEN ......

Oracle °ó¶¨±äÁ¿


oracle ÖУ¬¶ÔÓÚÒ»¸öÌá½»µÄsqlÓï¾ä,´æÔÚÁ½ÖÖ¿ÉÑ¡µÄ½âÎö¹ý³Ì, Ò»ÖÖ½Ð×öÓ²½âÎö,Ò»ÖÖ½Ð×öÈí½âÎö.
Ò»¸öÓ²½âÎöÐèÒª¾­½âÎö,ÖÆ¶¨Ö´Ðз¾¶,ÓÅ»¯·ÃÎʼƻ®µÈÐí¶àµÄ²½Öè.Ó²½âÊͲ»½ö½öºÄ·Ñ´óÁ¿µÄcpu£¬¸üÖØÒªµÄÊÇ»áÕ¼¾ÝÖØÒªµÄÃÇãÅ£¨latch£©×ÊÔ´£¬ÑÏÖØµÄÓ°ÏìϵͳµÄ¹æÄ£µÄÀ©´ó£¨¼´ÏÞÖÆÁËϵͳµÄ²¢·¢ÐУ©£¬ ¶øÇÒÒýÆðµÄÎÊÌâ ......

Aix 5.3ÏÂ×Ô¶¯±¸·ÝOracle¶à¸öʵÀý£¬²¢ÉÏ´«ÖÁFTP·þÎñÆ÷

Ò»¡¢Ð½¨databack.shÎļþ£¬´æ·ÅĿ¼/opt/databack/
#Êý¾Ý¿âÓû§×ÊÁÏ
USERNAME=Êý¾Ý¿âÓû§Ãû(ÐÅÏ¢Òþ²Ø)
PASSWORD=Êý¾Ý¿âÃÜÂë(ÐÅÏ¢Òþ²Ø)
#FTP·þÎñÆ÷ÐÅÏ¢
FTP_SERV=FTP·þÎñÆ÷(ÐÅÏ¢Òþ²Ø)
FTP_USER=FTPÓû§Ãû(ÐÅÏ¢Òþ²Ø)
FTP_PASS=FTPÃÜÂë(ÐÅÏ¢Òþ²Ø)
FTP_DIR=FTPĿ¼(ÐÅÏ¢Òþ²Ø)
#±¸·ÝĿ¼
BACKUP_DIR=/opt/databack
#¸ ......

oracle 10g em¡¢isqlplus·ÃÎʲ»Á˵ÄÎÊÌâ½â¾ö£¨»ã±à£©

Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§                     http://ip:5560/isqlplus
DBAÓû§   &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ