±È½ÏºÃµÄoracleºÍСÐÍ»ú×ÊÁÏ
	
    
    
	 ±È½Ïרҵ£¬×¨ÃżÆËã»ú¼¼Êõµç×ÓÊéÏÂÔØµÄ£º
www.itpub.net
www.itepub.net
www.netyi.net/in.asp?id=daotong
www.chmpdf.com
Ïà¶Ô²»Ì«×¨ÒµµÄ£¬ÄÚÈÝÒ²·Ç³£·á¸»
www.infoxa.com
www.xpbook.com
ÕâÐ©ÍøÕ¾¼¸ºõ¿ÉÒÔÕÒµ½ÄãÏëÒªµÄÈ«²¿Êé¼®¡£
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    recordʾÀý£º
create or replace procedure pro_test_record(vid in varchar2) is
type userRow is record(
id t_user.id%type,
name t_user.name%type
);
realRow userRow;
begin
select id,name into realRow from t_user where id=vid;
dbms_output.put_line(realRow.id||','||realRow.name);
end pro_test_re ......
	
    
        
    
        DBWn½ø³Ì¸ºÔð½«ÔàÊý¾Ý¿éдÈë´ÅÅÌ¡£ËüÊÇÒ»¸ö·Ç³£ÖØÒªµÄ½ø³Ì£¬Ëæ×ÅÄÚ´æµÄÔö¼Ó£¬Ò»¸öDBWn½ø³Ì¿ÉÄܲ»¹»ÓÃÁË¡£´Óoracle8iÆð£¬ÎÒÃÇ¿ÉÒÔΪϵͳÅäÖöà¸öDBWn½ø³Ì¡£³õʼ»¯²ÎÊýdb_writer_process¾ö¶¨ÁËÆô¶¯¶àÉÙ¸öDBWn½ø³Ì¡£Ã¿¸öDBWn½ø³Ì¶¼»á·ÖÅäÒ»¸öcache lru chain latch¡£
   DBWn×÷Ϊһ¸öºǫ́½ø³Ì£¬ ......
	
    
        
    
    OracleÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðÊǵ¼³ö£¯µ¼È루EXP/IMP£©¡¢Èȱ¸·ÝºÍÀ䱸·Ý¡£µ¼³ö±¸¼þÊÇÒ»ÖÖÂß¼±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
Ò»¡¢ µ¼³ö£¯µ¼È루Export£¯Import£©
ÀûÓÃExport¿É½«Êý¾Ý´ÓÊý¾Ý¿âÖÐÌáÈ¡³öÀ´£¬ÀûÓÃImportÔò¿É½«ÌáÈ¡³öÀ´µÄÊý¾ÝËͻص½OracleÊý¾Ý¿âÖÐÈ¥¡£
£±¡¢ ¼òµ¥µ¼³öÊý¾Ý£¨Export£©ºÍµ¼ÈëÊý¾ ......
	
    
        
    
    Oracle±íµÄ¹ÜÀí
±íÃûºÍÁÐÃûµÄÃüÃû¹æÔò£º
1±ØÐëÒÔ×Öĸ¿ªÍ·
2³¤¶È²»Äܳ¬¹ý30¸ö×Ö·û
3²»ÄÜʹÓÃOracleµÄ±£Áô×Ö
4Ö»ÄÜʹÓÃÈçÏÂ×Ö·û£ºA-Z,a-z,0-9,$,#µÈ
OracleÖ§³ÖµÄÊý¾ÝÀàÐÍ£º
1char ¶¨³¤£¬×î´ó2000×Ö·û
Àý×Ó£ºchar(10) ‘Ïþ»Ô’ ǰËĸö×Ö·û·Å’Ïþ»Ô’£¬ºóÌíÁù¸ö¿Õ¸ñ²¹È«
2varchar2(20) ±ä³¤£¬×î´ ......
	
    
        
    
    Ò».OracleÊý¾Ý¿âÖг£ÓõÄÊý¾ÝÀàÐÍ 
varchar2(³¤¶È)¿É±ä³¤×Ö·û´® 
char(³¤¶È) ¶¨³¤ 
number()±íʾÕûÊý»òÕ߸¡µãÊýnumber(8) number(8,2) 
clog ×Ö·ûµÄ´ó¶ÔÏó 
blog ¶þ½øÖƵĴó¶ÔÏó 
¶þ.Êý¾Ý¿â²éѯ 
1£©SELECTÓï¾ä 
´Ó±íÖÐÌáÈ¡²éѯÊý¾Ý.Ó﷨ΪSELECT [DISTINCT] {column1,column2,…} from tablename WHERE {con ......