ORACLE¸´Ï°(Ò»)
ºÜ¾ÃûÓÐÓõ½OracleÁË£¬Ç°Ð©ÈÕ×Óµ¥Î»½ÓÁËÒ»¸öOracleÊý¾Ý¿âµÄÏîÄ¿£¬×ÔÈ»ÐèÒª¸´Ï°Ò»Ï£¬ÏÖ½«¸´Ï°¹ý³ÌÖеÄһЩҪµã¼Ç¼ÏÂÀ´£¬ÒÔ±¸²éÔÄ¡£
Ò»¡¢ ±íÁÐÊý¾ÝÀàÐÍ
1¡¢×Ö·û
1) VARCHAR2(n)£¬nÊDZØÐëµÄ£¬ÓÃÓÚ´æ´¢×Ϊ4000¸ö×Ö·ûµÄ×Ö·û´®¡£µ«ËüÊǿɱäµÄ£¬Ö»Ê¹ÓÃËùÐèÒªµÄ×îÉÙ×Ö½Ú¡£
2) CHAR(n)£¬nÊDZØÐëµÄ£¬ÓÃÓÚ´æ´¢¹Ì¶¨³¤¶ÈµÄ×Ö·û´®¡£Èç¹ûËù²åÈëµÄֵСÓÚCHARËùÉùÃ÷µÄ³¤¶È£¬ÔòÓÒ±ßÒÔ¿Õ¸ñÌî³ä¡£Ò»°ã²»ÓøÃÀàÐÍ
3) NCHAR(n), NVARCHAR2(n)£¬½öÓÃÓÚ´æ´¢Unicode×Ö·û¼¯
2¡¢Êý×Ö
1) NUMBER, NUMBER(a), NUMBER(a, b)
2) ÕâÖÖÀàÐÍÓÃÓÚ´æ´¢Êý×Ö£¬²»ÒªÊ¹Óþ«È·µÄ²ÎÊýÀ´´æ´¢Î´Öª·¶Î§µÄÖµ¡£ÈçCreate table temp(amout number)£¬Ôò¿ÉÒÔÔÚÁÐamoutÖд洢ʵ¼ÊÉÏÊÇÈÎÒâ´óСµÄÊý×Ö¡£
3) ²ÎÊýa´ú±í¾«¶È£¬¼´Õ¼Î»·ûµÄ×ÜλÊý£¬²ÎÊýb±íʾ¿Ì¶È£¬¼´Ð¡ÊýµãÓұߵÄλÊý¡£ÈçCreate table temp(age number(3))±íʾ¿ÉÒÔ´æ´¢ÈÎÒâ3λµÄÕûÊý£»Èç¹ûÒª´æ´¢¹ÉƱ¼Û¸ñ£¬Æä×î´óֵΪ100ÍòÃÀÔª£¨Ð¡Êýµã×ó±ßÓÐ7룩£¬Ð¡ÊýµãÓÒ±ßÓÐ4룬Ôò¿ÉÒÔʹÓÃCreate table temp(price number(11,4))
4) ¿Ì¶ÈÊÇ¿ÉÑ¡µÄ£¬Èç¹ûûÓÐÕâ¸ö²ÎÊý£¬ÔòÖµ½«×÷ΪÕûÊý´æ´¢¡£¶ÔÓÚ·ÖÊý£¬ÔÚ²åÈëʱ½«±»ËÄÉáÎåÈëΪ×î½Ó½üµÄÕûÊý¡£Èç¹ûÖ»Ö¸¶¨¿Ì¶È£¬Ôò¿ÉÒÔʹÓÃCreate table temp(price number(*,4))
3¡¢ÈÕÆÚÀàÐÍ
1) DATE,ÓÃÓÚ´æ´¢ÈÕÆÚºÍʱ¼ä£¬Ä¬ÈÏÏÔʾ¸ñʽΪDD-MON-YY
2) TIMESTAMPÅÉÉúÓÚDATE£¬Ëü¿ÉÒÔ±íʾÓëDATE¾ßÓÐÏàͬ¾«¶ÈµÄʱ¼ä£¬²¢°üÀ¨ÃëµÄСÊý²¿·Ö
¶þ¡¢ ÐòÁÐ
¸÷ÖÖÊý¾Ý¿âÒÔ²»Í¬µÄ·½Ê½À´´¦ÀíÁеÄ×Ô¶¯Éú³É£¬SQL ServerʹÓÃÒ»¸öIDENTITYÁУ¬¶øORACLEÔòʹÓÃÐòÁС£ÐòÁÐÊÇÒ»¸ö¶ÔÏ󣬸öÔÏó´æ´¢ÔÚÊý¾Ý×ÖµäÖС£ÐòÁÐÒ»Ö±±£Áô״̬ÐÅÏ¢£¬È統ǰֵ£¬¶øÆäÉÏÏÂÎÄÊÇÔÚÊý¾Ý×ÖµäÖÐά»¤µÄ¡£
1¡¢ÐòÁеÄÊôÐÔ£ºNEXTVAL£¬Çó³ö½ÓÏÂÀ´µÄ×î¸ßÖµ£»CURRVAL£¬×î½üÒ»´Îµ÷ÓÃNEXTVALʱ·µ»ØµÄÖµ¡£
2¡¢´´½¨ÐòÁÐʱ£¬ÐòÁÐÊý×Ö¿ÉÒÔÊÇÑ»·µÄ£¬»òÕßÊÇÔÚij¸ö×î´óÖµÄÇÀïÍ£ÏÂÀ´¡£ÓëÖ®¶ÔÓ¦µÄ¹Ø¼ü×Ö·Ö±ðÊÇCYCLEºÍNOCYCLE¡£INCREMENT BY ¼ä¾à(interval)¿ÉÒÔʹÐòÁÐ
Ïà¹ØÎĵµ£º
¹Ù·½Îĵµ£ºhttp://tahiti.oracle.com/
metalink:http://metalink.oracle.com
itpub:www.itpub.com
TOM:asktom.oracle.com
oracle forum:http://forums.oracle.com/forums/main.jspa?categoryID=84
OTN:http://www.oracle.com/technology/index.html
www.oracle.com.cn
www.eygle.com
Oracle ERP
www.erp10 ......
תÔØ
DML statements on temporary tables do not generate redo logs for the data changes. However, undo logs for the data
and redo logs for the undo logs are generated. Data from the temporary table is automatically
dropped in the case of session termination, either when the user logs o ......
oracle ÔöÁ¿±¸·Ý½Å±¾
¡¡¡¡OS :RHEL AS 4 oracle 10g
¡¡¡¡0±¸·Ý½Å±¾
¡¡¡¡#!/bin/bash
¡¡¡¡# incremental level 0 backup script
¡¡¡¡source /home/oracle/.bash_profile
¡¡¡¡current_day=`date +%Y%m%d`
¡¡¡¡mkdir /home/oracle/RMANBACKUP/$current_day
¡¡¡¡rman target / <<EOF
¡¡¡¡run
¡¡¡¡{
¡¡¡¡CONFIG ......
½üÆÚ£¬ÔÚ¸ø¿Í»§×öÒ»¸öDemoÒ³Ãæʱ£¬ÐèÒªÓÃJAVA¶ÁÈ¡OracleÖеÄblobͼƬ×ֶβ¢ÏÔʾ£¬Ôڴ˹ý³ÌÖУ¬Óöµ½Ò»Ð©ÎÊÌ⣬ÀýÈ磺Á¬½ÓOracleÊý¾Ý¿â¶ÁÈ¡blob×Ö¶ÎÊý¾Ý£¬¶ÔͼƬbyteÊý¾Ý½øÐÐËõ·ÅµÈ£»Ìش˼Ǽ£¬¸ø×Ô¼º±¸Íü£¬¸ø´ó¼Ò²Î¿¼¡£
Õû¸öÁ÷³Ì·ÖΪËIJ½£¬Á¬½ÓoracleÊý¾Ý¿â -> ¶ÁÈ¡blobͼƬ×ֶΠ-> ¶ÔͼƬ½øÐÐËõ·Å ->°ÑͼƬչʾÔÚ ......
http://kang275284.javaeye.com/blog/154331
Ò»¡¢ ÏȽéÉÜÒ»ÏÂoracle
µÄSGA£ºÊý¾Ý¿âµÄϵͳȫ¾ÖÇø£¬SGAÖ÷ÒªÓÉÈý²¿·Ö¹¹
³É£º¹²Ïí³Ø¡¢Êý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇø¡£
1¡¢ ¹²Ïí³ØÓÖÓÉÁ½²¿·Ö¹¹³É£º¹²ÏíSQL
Çø
ºÍÊý¾Ý×ֵ仺³åÇø¡£¹²ÏíSQL
ÇøרÃÅ´æ·ÅÓû§SQL
Ãü
Áoracle
ʹÓÃ×î½ü×îÉÙʹÓõÈÓÅÏȼ¶Ëã·¨À´¸üи²¸Ç£ ......