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

OracleǧÍòÌõ¼Ç¼²åÈëÓë²éѯС½á

 
×î½ü×öÁ˸öÏîÄ¿£¬ÊµÏÖ¶Ô´æÔÚǧÍòÌõ¼Ç¼µÄ¿â±í½øÐвåÈë¡¢²éѯ²Ù×÷¡£Ô­ÒÔΪ¶ÔÊý¾Ý¿âµÄ²åÈë¡¢²éѯÊǼþºÜÈÝÒ×µÄÊ£¬¿É²»Öªµ±Êý¾Ý´ïµ½°ÙÍòÉõÖÁǧÍòÌõ¼¶±ðµÄʱºò£¬ÕâÒ»ÇÐËƺõ±äµÃÏ൱À§ÄÑ¡£¼¸¾­ÕÛÌÚ£¬×ÜËãÍê³ÉÁËÈÎÎñ¡£
¡¡¡¡1¡¢±ÜÃâʹÓÃHibernate¿ò¼Ü
¡¡¡¡HibernateÓÃÆðÀ´ËäÈ»·½±ã£¬µ«¶ÔÓÚº£Á¿Êý¾ÝµÄ²Ù×÷ÏÔµÃÁ¦²»´ÓÐÄ¡£
¡¡¡¡¹ØÓÚ²åÈ룺
¡¡¡¡ÊÔ¹ýÓÃHibernateÒ»´ÎÐÔ½øÐÐ5ÍòÌõ×óÓÒÊý¾ÝµÄ²åÈ룬ÈôIDʹÓÃsequence·½Ê½Éú³É£¬Hibernate½«·Ö5Íò´Î´ÓÊý¾Ý¿âÈ¡µÃ5Íò¸ösequence£¬¹¹Ôì³ÉÏàÓ¦¶ÔÏóºó£¬ÔÙ·ÖÎåÍò´Î½«Êý¾Ý±£´æµ½Êý¾Ý¿â¡£»¨ÁËÎÒÊ®·ÖÖÓʱ¼ä¡£Ö÷ÒªµÄʱ¼ä²»ÊÇ»¨ÔÚ²åÈëÉÏ£¬¶øÊÇ»¨ÔÚ5Íò´Î´ÓÊý¾Ý¿âÈ¡sequenceÉÏ£¬ÅªµÃÎÒÏ൱ÓôÃÆ¡£ËäÈ»ºóÀ´°ÑIDÉú³É·½Ê½¸Ä³Éincrease½â¾öÁËÎÊÌ⣬µ«»¹ÊǶÔÄÇÊ®·ÖÖӵĵȴýÐÄÓÐÓà¼Â¡£
¡¡¡¡¹ØÓÚ²éѯ£º
¡¡¡¡Hibernate¶ÔÊý¾Ý¿â²éѯµÄÖ÷Ҫ˼Ï뻹ÊÇÃæÏò¶ÔÏóµÄ£¬Õ⽫ʹÐí¶àÎÒÃDz»ÐèÒª²éѯµÄÊý¾ÝÕ¼ÓÃÁË´óÁ¿µÄϵͳ×ÊÔ´£¨°üÀ¨Êý¾Ý¿â×ÊÔ´ºÍ±¾µØ×ÊÔ´£©¡£ÓÉÓÚ¶ÔHibernateµÄÆ«°®£¬±¾×Ų»Å×Æú¡¢²»·ÅÆúµÄ×÷·ç£¬×öÁË°üÀ¨ÅäSQL£¬¸Ä½øSQLµÈµÈµÄÏ൱¶àµÄ³¢ÊÔ£¬¿É¶¼ÒÔʧ°Ü¸æÖÕ£¬²»µÃ²»ÈÌÍ´¸î°®ÁË¡£
¡¡¡¡2¡¢Ð´²éѯÓï¾äʱ£¬Òª°Ñ²éѯµÄ×Ö¶ÎÒ»Ò»Áгö
¡¡¡¡²éѯʱ²»ÒªÊ¹ÓÃÀàËÆselect * from x_tableµÄÓï¾ä£¬Òª¾¡Á¿Ê¹ÓÃselect id,name from x_table£¬ÒÔ±ÜÃâ²éѯ³ö²»ÐèÒªµÄÊý¾ÝÀË·Ñ×ÊÔ´¡£¶ÔÓÚº£Á¿Êý¾Ý¶øÑÔ£¬Ò»¸ö×Ö¶ÎËùÕ¼ÓõÄ×ÊÔ´ºÍ²éѯʱ¼äÊÇÏ൱¿É¹ÛµÄ¡£
¡¡¡¡3¡¢¼õÉÙ²»±ØÒªµÄ²éѯÌõ¼þ
¡¡¡¡µ±ÎÒÃÇÔÚ×ö²éѯʱ£¬³£³£ÊÇǰ̨Ìá½»Ò»¸ö²éѯ±íµ¥µ½ºǫ́£¬ºǫ́½âÎöÕâ¸ö±íµ¥£¬¶øºó½øÐвéѯ²Ù×÷¡£ÔÚÎÒÃǽâÎö±íµ¥Ê±£¬ÎªÁË·½±ãÆð¼û£¬³£³£Ï²»¶½«Ò»Ð©²»ÐèÒª²éѯµÄÌõ¼þÓÃÓÀÕæµÄÌõ¼þÀ´´úÌ棨È磺select count(id) from x_table where name like ‘%’£©£¬ÆäʵÕâÑùµÄSQL¶Ô×ÊÔ´µÄÀË·ÑÊÇÏ൱¿Éŵġ£ÎÒÊÔ¹ý¶ÔÓÚͬÑùµÄ½üһǧÍòÌõ¼Ç¼µÄ²éѯÀ´Ëµ£¬Ê¹ÓÃselect count(id) from x_table ½øÐбí²éѯÐèÒª11Ã룬¶øʹÓÃselect count(id) from x_table where name like ‘%’È´»¨ÁË33Ãë¡£
¡¡¡¡4¡¢±ÜÃâÔÚ²éѯʱʹÓñíÁ¬½Ó
¡¡¡¡ÔÚ×öº£Á¿Êý¾Ý²éѯʱ£¬Ó¦¾¡Á¿±ÜÃâ±íÁ¬½Ó£¨ÌرðÊÇ×ó¡¢ÓÒÁ¬½Ó£©£¬Íò²»µÃÒÑÒª½øÐбíÁ¬½Óʱ£¬±»Á¬½ÓµÄÁíÒ»ÕűíÊý¾ÝÁ¿Ò»¶¨²»ÄÜÌ«´ó£¬ÈôÁ¬½ÓµÄÁíÒ»ÕűíÒ²ÊÇÊýÍòÌõµÄ»°£¬ÄǹÀ¼Æ¿ÉÒÔ¿¼ÂÇÖØÐÂÉè¼Æ¿â±íÁË£¬ÒòΪÄÇÐèÒªµÈ´ýµÄʱ¼ä¾ö²»ÊÇÕý³£Óû§ËùÄÜÈÌÊܵġ£
¡¡¡¡5¡¢Ç¶Ìײéѯʱ£¬¾¡¿ÉÄܵØÔÚµÚÒ»´Îselect¾Í°Ñ²éѯ·¶Î§Ëõµ½×îС
¡¡¡¡ÔÚÓÐ


Ïà¹ØÎĵµ£º

¶ÔoracleÊý¾Ý¿âÖÐCLOB×ֶεÄÏà¹Ø²Ù×÷


import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
 * ´Ë´¦²åÈëÀàÐÍ˵Ã÷¡£
 * ´´½¨ÈÕÆÚ£º(2001/11/30 14:55 ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨

1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ì ......

ORACLE ¶ÔÏóµÄʹÓÃ

--´´½¨¶ÔÏóÀàÐÍ
create or replace type emp_typ as object (
id number,
name varchar2(30),
sal number,
comm number,
member procedure change_comm(new_comm number),
member function get_info return  varchar2
) ;
--´´½¨¶ÔÏóÀàÐ͹¹Ô캯Êý¶¨Òå
create or replace type body emp_typ is
member proce ......

oracle 9iÉý¼¶µ½oracle9208Êý¾Ý¿â

±³¾°£ºÔÚwindows2003serverÉÏ°²×°ÁËOracle9.2.0.1.0£¬ÏÖ´òË㽫ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×îÐµİ²È«²¹¶¡April2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©
  (1)µ½metalinkÏÂÔØÉý¼¶Ñ¹Ëõ°ü£¬patchºÅΪ4547809£¬Ñ¹Ëõ°üÃû³ÆΪ p4547809_92080_WINNT.zip£¬for windows 32bit¡£
  (2)½âѹËõzip£¬Ï±߰üº¬Ò»¸ö ......

oracle¼àÌý¼ÓÃÜ ¸ü°²È«

ºÜ¶àÈ˶¼ÖªµÀ£¬OracleµÄ¼àÌýÆ÷Ò»Ö±´æÔÚ×ÅÒ»¸ö°²È«Òþ»¼£¬¼ÙÈç²»ÉèÖð²È«´ëÊ©£¬ÄÇôÄܹ»·ÃÎʵÄÓû§¾Í¿ÉÒÔÔ¶³Ì¹Ø±Õ¼àÌýÆ÷¡£
Ïà¹ØʾÀý£º
D:\>lsnrctl stop eygle
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 28-11ÔÂ-2007 10:02:40
Copyright (c) 1991, 2006, Oracle. All rights reserved.
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ