ORACLE×ÔÔö³¤×Ö¶ÎʵÏÖ
Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
CREATE TABLE example(
ID Number(4) NOT NULL PRIMARY KEY,
NAME VARCHAR(25),
PHONE VARCHAR(10),
ADDRESS VARCHAR(50)
);
È»ºó£¬ÄãÐèÒªÒ»¸ö×Ô¶¨ÒåµÄsequence
CREATE SEQUENCE emp_sequence
INCREMENT BY 1 -- ÿ´Î¼Ó¼¸¸ö
START WITH 1 -- ´Ó1¿ªÊ¼¼ÆÊý
NOMAXVALUE -- ²»ÉèÖÃ×î´óÖµ
NOCYCLE -- Ò»Ö±ÀÛ¼Ó£¬²»Ñ»·
NOCACHE -- ²»½¨»º³åÇø
ÒÔÉÏ´úÂëÍê³ÉÁËÒ»¸öÐòÁÐ(sequence)µÄ½¨Á¢¹ý³Ì,Ãû³ÆÎªemp_sequence,·¶Î§ÊÇ´Ó1¿ªÊ¼µ½ÎÞÏÞ´ó(ÎÞÏÞ´óµÄ³Ì¶ÈÊÇÓÉÄã»úÆ÷¾ö¶¨µÄ),nocycle ÊǾö¶¨²»Ñ»·,Èç¹ûÄãÉèÖÃÁË×î´óÖµÄÇôÄã¿ÉÒÔÓÃcycle »áʹseqµ½×î´óÖ®ºóÑ»·.¶ÔÓÚnocache˳±ã˵һÏÂÈç¹ûÄã¸ø³öÁËcacheÖµÄÇôϵͳ½«×Ô¶¯¶ÁÈ¡ÄãµÄcacheÖµ´óС¸öseq
,ÕâÑùÔÚ·´¸´²Ù×÷ʱ»á¼Ó¿ìÔËÐÐËÙ¶È,µ«Èç¹ûÔâÓöÒâÍâÇé¿öÈçµ±»úÁË»òoracleËÀÁË,ÔòÏ´ÎÈ¡³öµÄseqÖµ½«ºÍÉϴεIJ»Á¬¹á.(Èç¹ûÁ¬²»Á¬¹áÎÞËùν½¨ÒéÓÃcache,ÒòΪʱ¼ä¾ÍÊǽðǮѽ!ÅÜÌâÁË£¡)
Êé½ÓÉÏÎÄ£¬ÄãÖ»ÓÐÁ˱íºÍÐòÁл¹²»¹»£¬»¹ÐèÒªÒ»¸ö´¥·¢Æ÷À´Ö´ÐÐËü£¡´úÂëÈçÏ£º
CREATE TRIGGER "´¥·¢Æ÷Ãû³Æ" BEFORE
INSERT ON example FOR EACH ROW WHEN (new.id is null)
begin
&nbs
Ïà¹ØÎĵµ£º
¶ÔÓÚORACLEÊý¾Ý¿âµÄÊý¾Ý´æÈ¡£¬Ö÷ÒªÓÐËĸö²»Í¬µÄµ÷Õû¼¶±ð£¬µÚÒ»¼¶µ÷ÕûÊDzÙ×÷ϵͳ¼¶°üÀ¨Ó²¼þƽ̨,µÚ¶þ¼¶µ÷ÕûÊÇORACLE RDBMS¼¶µÄµ÷Õû,µÚÈý¼¶ÊÇÊý¾Ý¿âÉè¼Æ¼¶µÄµ÷Õû,×îºóÒ»¸öµ÷Õû¼¶ÊÇSQL¼¶¡£Í¨³£ÒÀ´ËËļ¶µ÷Õû¼¶±ð¶ÔÊý¾Ý¿â½øÐе÷Õû¡¢ÓÅ»¯£¬Êý¾Ý¿âµÄÕûÌåÐÔÄÜ»áµÃµ½ºÜ´óµÄ¸ÄÉÆ¡£ÏÂÃæ´Ó¼¸¸ö²»Í¬·½Ã ......
OracleÖеĴ洢¹ý³ÌºÍÓαê:
select myFunc(²ÎÊý1,²ÎÊý2..) to dual; --¿ÉÒÔÖ´ÐÐһЩҵÎñÂß¼
Ò»:OracleÖеĺ¯ÊýÓë´æ´¢¹ý³ÌµÄÇø±ð:
A:º¯Êý±ØÐëÓзµ»ØÖµ,¶ø¹ý³ÌûÓÐ.
B:º¯Êý¿ÉÒÔµ¥¶ÀÖ´ÐÐ.¶ø¹ý³Ì±ØÐëͨ¹ýexecuteÖ´ÐÐ.
C:º¯Êý¿ÉÒÔǶÈëµ½SQLÓï¾äÖÐÖ´ÐÐ.¶ø¹ý³Ì²»ÐÐ.
ÆäʵÎÒÃÇ¿ÉÒÔ½«±È½Ï¸´ÔӵIJéѯд³Éº¯Êý.È»ºóµ½´æ´¢¹ý³Ì ......
The following are number examples for the to_char
function.
to_char
(1210.73,
'9999.9')
would return '1210.7'
to_char
(1210.73,
'9,999.99')
would return '1,210.73'
to_char
(1210.73,
'$9,999.00')
would return
'$1,210.73'
to_char
(21,
'000099')
would return '000021'
The foll ......
Èç¹ûÄãÊÇWINXP»òWIN2003µÄϵͳÖÐ×Ô´øµÄ·À»ðǽ,¿ÉÒÔÊÔÒ»ÏÂÒÔÏ·½·¨:
1.ÔÚ·À»ðǽµÄÀýÍâÖÐ,Ìí¼ÓORACLE.EXEÔËÐгÌÐò.(ÔÚoracle°²×°Ä¿Â¼ÕÒµ½binÎļþ¼ÐÖÐ)
2.ÔÙÔÚ·À»ðǽÀýÍâÖУ¬Ìí¼Ó¶Ë¿Ú1521¶Ë¿Ú¾ÍÑù¾ÖÓòÍøÄ򵀮äËû»úÆ÷¾Í¿ÉÒÔ·ÃÎÊÄãµÄORACLEÁË.
»òÕßÔڸ߼¶ÖÐ,Ñ¡Öе±Ç°Ê¹ÓõÄÍø¿¨,Ìí¼ÓIP,¶Ë¿ÚºÅ(1521),ÕâÑù,ÆäËû»úÆ÷Ò²¿ÉÒÔ·ÃÎ ......
¶ÔÓÚOracle£¬±ÊÕßÒ²ÊÇÒ»¸ö³õѧÕߣ¬ÈçÎÄÕÂÖеIJ»×ãÖ®´¦»¹Çë¸÷Î»ÍøÓÑÖ¸Õý
ÏÂÃæÎÒÃÇ¿ªÊ¼°²×°Oracle£¬ÔÚ°²×°Ö®Ç°£¬ÎÒÃÇÏÈÀ´ÁгöһЩÔÚ°²×°OracleÊý¾Ý¿âʱÐèҪעÒâµÄÊÂÏOracle°²×°³ÌÐò£¨OUI£©²»Ö§³Ö×Ö·û½çÃæ°²×°£¬Òò´Ë°²×°·þÎñÆ÷±ØÐëÓÐX windowsÖ§³Ö ÏÂÃæÊÇÎÒ°²×°OracleÊý¾Ý¿âµÄϵͳÐÅÏ¢
²Ù×÷ϵ ......