Oracle 10g ÒªµãÕûÀí Ö® ¹ÜÀí±í
¹ÜÀí±í
±íÊÇÕæÕý´æ´¢ÐÅÏ¢µÄ¶ÔÏó¡£
1 Êý¾ÝÀàÐÍ
£¨1£©ÊýÖµÀàÐÍ£ºÓÃÓÚ´æ´¢ÕûÊý¡¢¸¡µãÊý¡¢ÊµÊý¡£
number£¨¾«¶È£¬·¶Î§£©¾«¶ÈÊÇÖ¸Êý×Ö¸öÊý×ܺͣ¬·¶Î§ÊÇָСÊýµãÓұߵÄλÊý¡£
£¨2£©×Ö·ûÀàÐÍ£ºÉùÃ÷°üº¬ÁË×Öĸ¡¢Êý×ÖÊý¾ÝµÄÁС£
char£º´æ´¢¹Ì¶¨³¤¶È×Ö·û´®
nchar£º´æ´¢UnicodeÊý¾Ý
varchar2£º¿É±ä³¤¶È£¬ÉùÃ÷ʱ±ØÐëÖ¸¶¨´óС¡£
nvarchar2£º¿É±ä³¤¶È
£¨3£©ÈÕÆÚºÍʱ¼ä
date£º´æ´¢ÈÕÆÚºÍʱ¼ä£¬¿ÉÒÔʹÓÃto_date()ºÍsystdate()º¯ÊýÀ´½¨Á¢ÈÕÆÚÖµ£¬Ö»´æÕûÃë
timestamp£º¿ÉÒԹ涨¾«¶È
2 ´´½¨±íºÍÔ¼Êø
¶ÑÊÇ×î»ù±¾µÄ±íÀàÐÍ¡£
create table [Óû§Ãû.] table_name (ÁÐÃû Êý¾ÝÀàÐÍ (default value) not null£¬·····);
£¨1£©Ô¼Êø
Ô¼Êø¿ÉÒÔÔÚcreate tableÓï¾äÖд´½¨Ò²¿ÉÒÔÔÚalter tableÓï¾äÖÐÌí¼Ó¡£
¹Ø¼ü×Ö£ºconstraint
alter table table_name add constraint Ô¼ÊøÃû Ìõ¼þ;
¢Ù Ö÷¼üÔ¼Êø£ºÈ·±£Ò»¸ö±íÖÐûÓÐÖظ´ÐС£
alter table table_name add constraint Ö÷¼üÃû primary key(ÁÐÃû);
Ò»¸ö±í×îÓÐÖ»ÄÜÓÐÒ»¸öÖ÷¼üÔ¼Êø¡£
±íÖв»ÄÜÓÐÈκÎÁ½ÐÐÔÚÖ÷¼üÔ¼ÊøÁÐÉϾßÓÐÏàͬµÄÖµ¡£
Ö÷¼üÁв»ÄÜΪnull¡£
¢Ú Íâ¼üÔ¼Êø£º½¨Á¢±íºÍ±íÖ®¼äµÄ¸¸×Ó¹Øϵ
alter table ×Ó±íÃû add constraint Íâ¼üÃû foreign key(×Ó±íÁÐ) references ¸¸±íÃû(ÁÐÃû)
Èç¹û²åÈë×Ó±íµÄÐÐÔÚÍâ¼üÁÐÓзÇnullÖµ£¬ÄÇôÔÚ¸¸±íÐÐÖбØÐèÔÚÒýÓõÄÁÐÖÐÓÐÏàͬµÄÖµ¡£
ÔÚ¸¸±íÖб»²ÎÕÕµÄÁбØÐëÊÇΨһµÄ»òÖ÷¼ü¡£
ÔÚ×Ó±í²åÈë¼Ç¼ʱ£¬²»ÂÛ¸¸±íÔÚ¶ÔÓ¦µÄÁÐÊÇ·ñ¾ßÓÐnullÖµ£¬Íâ¼üÁж¼¿ÉÒÔ²åÈënull
¢Û ΨһÐÔÔ¼Êø£ºÈ·±£±íÖеĸ÷ÐУ¬¶ÔÓÚֵΪ·ÇnullµÄ¸øµãÁж¼¾ßÓÐΨһֵ¡£
ÔÚ±íÖУ¬¿ÉÒÔÓжà¸öÐÐÔÚÏàÓ¦µÄΨһÐÔÔ¼ÊøÁÐÖоßÓÐnullÖµ¡£
alter table ±íÃû add constrains Ô¼ÊøÃû unique(ÁÐÃû);
¢Ü ¼ì²éÔ¼Êø£ºÖ¸¶¨Ô¼ÊøÁеÄÈ¡Öµ·¶Î§
alter table ±íÃû add
Ïà¹ØÎĵµ£º
exp/impÊÇOracle×Ô´øµÄµ¼Èëµ¼³öÃüÁÔËÓÃËü£¬¼´Ê¹²»ÐèÒªÄǽáUI¹¤¾ßÒ²ÄÜÇáÒ×µÄÍê³ÉÊý¾Ýµ¼³öµ¼È빤×÷£¬ÏÂÃæÊÇËüÃǵIJÎÊý£º
EXP²ÎÊýÏê½â
ʹÓõĸñʽÊÇ£ºEXP KEYWORD=value »ò KEYWORD=(value1,value2,...,valueN)
ÆäÖÐUSERIDÊDZØÐëµÄÇÒΪµÚÒ»¸ö²ÎÊý
¹Ø¼ü×Ö
±¸×¢
USERID
Óû§Ãû/¿ÚÁî
FULL
µ¼³öÕû¸öÎļþ (N)
BUFFER
......
oracle½«×Ö·û´®×ª»»Îª12СʱÓë24СʱÖÆ£º
--12СʱÖÆ£º
select hsv.mydate from huhai_seq_value hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-mm-dd hh:mi:ss');
--24СʱÖÆ£º
select hsv.mydate from huhai_seq_value hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-m ......
Ò»¡¢³£ÓÃÊý¾ÝÀàÐÍ£º
Number£ºÊý×ÖÀàÐÍ
Int£ºÕûÊýÐÍ
Pls_integer£ºÕûÊýÐÍ£¬²úÉúÒç³öµÄ´íÎó
Binary_integer£ºÕûÊýÐÍ
Char£º¶¨³¤×Ö·û£¬×255¸ö×Ö·û
Varchar2£º±ä³¤×Ö·û£¬×2000¸ö×Ö·û
Long£º±ä³¤×Ö·û£¬×2GB
Date£ºÈÕÆÚÐÍ
Boolean£º²¼¶ûÐÍ
¶þ¡¢¶¨Òå³£Á¿
¸ñʽ£º³£Á¿Ãû constant &nbs ......
ÎÒ½ñÌìѧϰÁËOracle Êý¾Ý¿âµÄÅäÖü°¹ÜÀí£º
1 Oracle Êý¾Ý¿âÌåϵ½á¹¹¼ò½é
1.1 ƽ³£Ëù˵µÄ Oracle »ò Oracle Êý¾Ý¿âÖ¸µÄÊÇ Oracle Êý¾Ý¿â¹ÜÀíϵͳ. Oracle Êý¾Ý¿â¹ÜÀíϵͳÊǹÜÀíÊý¾Ý¿â·ÃÎʵļÆËã»úÈí¼ ......
1Á¬½ÓÊý¾Ý¿âʵÀý
£¨1£©Óû§½ø³Ì£ºÈí¼þ£¬SQL*Plus£¬Ê¹ÓÃOracle Net Services£¨ÍøÂç·þÎñ£©ÓëÊý¾Ý¿âͨѶ
£¨2£©Oracle¼àÌýÆ÷£ºlistener.ora£¬¶¨ÒåÁËÊý¾Ý¿âʵÀýÃû£¬Â·¾¶£¬¿ÉÒÔʹÓõÄÐÒ飬¶Ë¿Ú
£¨3£©OracleÍøÂç¿Í»§£ºtnsnames.ora£¬¶¨ÒåÁËͨѶÐÒ飬¶Ë¿Ú£¬·þÎñÆ÷µØÖ·
2 ·þÎñÆ÷½ø³Ì
¸ºÔðÓû§½ø³ÌºÍOracleʵÀý ......