Oracleѧϰ±Ê¼ÇÈý·½°¸
Oracleѧϰ±Ê¼ÇÈý·½°¸
——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
·½°¸£¨schema£©
ÔÚOracleÖУ¬ÎÒÃÇ¿ÉÒÔ¶ÔÊý¾Ý¿â¶ÔÏó·Ö×飬Õâ¾ÍÊÇ·½°¸£¨schema£©£¬ÊÇÊý¾Ý¿â¶ÔÏóµÄ¼¯ºÏ¡£Ò»¸öÓû§Ò»°ã¶ÔÓ¦Ò»¸öschema,¸ÃÓû§µÄschemaÃûµÈÓÚÓû§Ãû£¬²¢×÷Ϊ¸ÃÓû§È±Ê¡schema¡£ÕâÒ²¾ÍÊÇÎÒÃÇÔÚÆóÒµ¹ÜÀíÆ÷µÄ·½°¸Ï¿´µ½schemaÃû¶¼ÎªÊý¾Ý¿âÓû§ÃûµÄÔÒò¡£OracleÊý¾Ý¿âÖв»ÄÜд´½¨Ò»¸öschema£¬ÒªÏë´´½¨Ò»¸öschema£¬Ö»ÄÜͨ¹ý´´½¨Ò»¸öÓû§µÄ·½·¨½â¾ö(OracleÖÐËäÈ»ÓÐcreate schemaÓï¾ä£¬µ«ÊÇËü²¢²»ÊÇÓÃÀ´´´½¨Ò»¸öschemaµÄ)£¬ÔÚ´´½¨Ò»¸öÓû§µÄͬʱΪÕâ¸öÓû§´´½¨Ò»¸öÓëÓû§ÃûͬÃûµÄschem²¢×÷Ϊ¸ÃÓû§µÄȱʡshcema¡£¼´schemaµÄ¸öÊýͬuserµÄ¸öÊýÏàͬ£¬¶øÇÒschemaÃû×ÖͬuserÃû×ÖÒ»Ò» ¶ÔÓ¦²¢ÇÒÏàͬ£¬ËùÓÐÎÒÃÇ¿ÉÒÔ³ÆschemaΪuserµÄ±ðÃû£¬ËäÈ»ÕâÑù˵²¢²»×¼È·£¬µ«ÊǸüÈÝÒ×Àí½âһЩ¡£
ÏÂÃæ¿´ÕŸ´ÔÓµÄͼ£¬±íÏÖÓû§·½°¸£¬±í¿Õ¼ä £¬ÎļþÖ®¼äµÄ¹Øϵ¡£
Ïà¹ØÎĵµ£º
·1979ÄêµÄÏļ¾£¬RSI·¢²¼ÁËOracleµÚ¶þ°æ
·1983Äê3Ô£¬RSI·¢²¼ÁËOracleµÚÈý°æ
´ÓÏÖÔÚÆðOracle²úÆ·ÓÐÁËÒ»¸ö¹Ø¼üµÄÌØÐÔ:¿ÉÒÆÖ²ÐÔ
·1984Äê10Ô£¬Oracle·¢²¼Á˵Ú4°æ²úÆ·
ÕâÒ»°æÔö¼ÓÁ˶ÁÒ»ÖÂÐÔÕâ¸öÖØÒªÌØÐÔ
·1985Ä꣬Oracle·¢²¼ÁË5.0°æ
Õâ¸ö°æ±¾ËãµÃÉÏÊÇOracleÊý¾Ý¿âµÄÎȶ¨°æ±¾¡£ÕâÒ²ÊÇÊ ......
delete ɾ³ýÒ»ÕÅ´ó±íʱ¿Õ¼ä²»ÊÍ·Å£¬·Ç³£ÂýÊÇÒòΪռÓôóÁ¿µÄϵͳ×ÊÔ´£¬Ö§³Ö»ØÍ˲Ù×÷£¬¿Õ¼ä»¹±»ÕâÕűíÕ¼ÓÃ×Å¡£
truncate table ±íÃû (ɾ³ý±íÖмǼʱÊͷűí¿Õ¼ä)
DML Óï¾ä£º
±í¼¶¹²ÏíËø£º ¶ÔÓÚ²Ù×÷Ò»ÕűíÖеIJ»Í¬¼Ç¼ʱ£¬»¥²»Ó°Ïì
Ðм¶ÅÅËüËø£º¶ÔÓÚÒ»ÐмǼ£¬oracle »áÖ»ÔÊÐíÖ»ÓÐÒ»¸öÓû§¶ÔËüÔÚͬһʱ¼ä½øÐÐÐ޸IJÙ×÷ ......
exp document/document2009@document owner=document rows=y compress=y buffer=65536 feedback=100000 file=D:\document.dmp log=D:\document.log
exp whd/whd2009@whddb owner=whd rows=y compress=y buffer=65536 feedback=100000 file=D:\whd.dmp log=D:\whd.log
imp document/document2009@document fromuser=docume ......
1>.NUMBERÀàÐÍϸ½²£º
Oracle number datatype Óï·¨£ºNUMBER[(precision [, scale])]
¼ò³Æ£ºprecision --> p
scale --> s
NUMBER(p, s)
·¶Î§£º 1 <= p <=38, -84 <= s <= 127
±£´æÊý¾Ý·¶Î§£º-1.0e-130 <= number value < 1.0e+1 ......
Oracleѧϰ±Ê¼ÇһʵÀý
——ͨ¹ýÓëSqlServer¶Ô±Èѧϰ
Oracleѧϰ±Ê¼ÇһʵÀý
Oracleѧϰ±Ê¼Ç¶þ´æ´¢
Oracleѧϰ±Ê¼ÇÈý·½°¸
ʵÀý
ÔÚOracleºÍSqlServerÖж¼ÓÐʵÀýһ˵£¬µ«ÕâÁ½¸öʵÀýÊDz»Í¬µÄ¡£
ÔÚSql ......