oracleÖÐʵÏÖ×ÔÔöÁÐ
1.´´½¨Ñ§Éú±í£º
CREATE TABLE student (
xh number primary key,
Name varchar2(10) not null);
2. ´´½¨ÐòÁУº
CREATE SEQUENCE student_seq
START WITH 1
INCREMENT BY 1
NOCACHE;
°´»Ø³µ¼ü£¬ÏµÍ³Ìáʾ“ÐòÁÐÒÑ´´½¨”¡£ÕâÑù¾Í´´½¨ÁËÒ»¸ö×ÔÔöµÄÐòÁУ¬´ËÐòÁдÓ1¿ªÊ¼£¬Ã¿´ÎÔö³¤1¡£
3. Ïòstudent±íÖвåÈëÊý¾Ý£¬ÊäÈë´úÂëÈçÏ£º
INSERT INTO student
VALUES
(student_seq.nextval,’zhangsan’);
Ïà¹ØÎĵµ£º
HA
ÊÇHigh Availability
µÄÊ××Öĸ×éºÏ£¬·Òë¹ýÀ´£¬¿ÉÒÔ½Ð×ö¸ß¿ÉÓ㬻ò¸ß¿ÉÓÃÐÔ£¬¸ß¿ÉÓ㨻·¾³£©¡£ÎÒ¾õµÃÓ¦¸Ã˵HAÊÇÒ»¸ö¹ÛÄî¶ø²»ÊÇÒ»Ïî»òһϵÁоßÌå¼¼Êõ£¬¾ÍÏóÍø¸ñÒ»Ñù¡£×÷¹ýϵͳ
·½°¸¾ÍÖªµÀÁË£¬ÆÀ¼ÛϵͳµÄÐÔÄܵ±ÖоÍÓÐÒ»Ïî¸ß¿ÉÓ᣹ãÒåµÄ¸ß¿ÉÓÃÉæ¼°µ½ÏµÍ³µÄ¸÷¸ö·½Ã棬¼òµ¥À´Ëµ£¬ÈÃϵͳ²»»áÖжÏ
ÔËÐУ¬¾ÍÊǸ߿ÉÓᣰüÀ¨È ......
.Frm644 { display:none; }
¡¡¡¡1¡£ÒѾ¼ìÑéµÄÓï¾äºÍÒÑÔÚ¹²Ïí³ØÖеÄÓï¾äÖ®¼äÒªÍêȫһÑù
¡¡¡¡2¡£±äÁ¿Ãû³Æ¾¡Á¿Ò»ÖÂ
¡¡¡¡3¡£ºÏÀíʹÓÃÍâÁª½Ó
¡¡¡¡4¡£ÉÙ
Óöà²ãǶÌ×
¡¡¡¡5¡£¶àÓò¢·¢
¡¡¡¡
¡¡¡¡Óï¾äµÄÓÅ»¯²½ÖèÒ»°ãÓУº
¡¡¡¡1¡£µ÷ÕûsgaÇø£¬Ê¹µÃsgaÇøµÄÊÇÓÃ×îÓÅ¡£
¡¡
¡¡2¡£sqlÓï¾ä±¾ÉíµÄÓÅ»¯£¬¹¤¾ßÓÐexplain,sql trace ......
´Ó8iµ½10g£¬Oracle²»¶Ï½ø»¯×Ô¼ºµÄSQL TuningÖÇÄÜ£¬Ò»Ð©Ãؼ®¼¶µÄÓÅ»¯¿Ú¾÷ÒѾʧЧ¡£
µ«ÎÒϲ»¶Ê§Ð§£¬²»Óüǿھ÷£¬²Ù¸öToad for Oracle Xpert
£¬°´ÕÕ´ó·½ÏòÊæÊæ·þ·þµÄ
µ÷ÓŲÅÊǰ®×öµÄÊÂÇé¡£
1.Excution Plan
Excution
PlanÊÇ×î»ù±¾µÄµ÷ÓŸÅÄ²»¹ÜÄãµÄµ÷ÓÅ´µµÃÈçºÎÌ ......
Create [or replace] trigger [ģʽ.]´¥·¢Æ÷Ãû
Before| after |instead of insert|delete|(update of ÁÐÃû)
{insert|delete|(update of ÁÐÃû) }
On ±íÃû|ÊÓͼ|ģʽÃû|Êý¾Ý¿âÃû
[for each row]
When Ìõ¼þ
PL/SQL¿é
˵Ã÷£º
......
×Ö·ûÀàÐÍ£º
CHAR(size)£º¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
VARCHAR2(size)£º¿É±ä³¤¶ÈµÄ×Ö·û´®£¬×î´ó³¤¶È4000 bytes£¬¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´®£¬×î´ó³¤¶È2000 bytes
NVARCHAR2(size)£º¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´®£¬×î´ó³¤¶È4000 byte
LONG£º±ä³¤µÄ×Ö·û´®£¬×î´ó³¤¶ÈÏÞ ......