Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle´æ´¢¹ý³Ì

 Oracle´æ´¢¹ý³Ì¹¦ÄÜÇ¿´ó£¬ËûÖ÷ÒªµÄ×÷ÓÃÓÐÒÔϼ¸µã:
1.¿ÉÒÔÅúÁ¿Ö´ÐÐsqlÓï¾ä£¬ÌṩÄÚÖõÄÊÂÎñÖ§³Ö£¬Í¬Ê±Äܹ»Ìá¸ßÊý¾Ý¿â²Ù×÷µÄЧÂÊ¡£
2.¿Í»§¶Ë³ÌÐòÒÀ¾Ý´æ´¢¹ý³ÌÃûÀ´µ÷Óã¬Ìṩ³ÌÐòµÄ¿ÉÒÆÖ²ÐÔ¡£
3.Ìṩ¸´ÔÓµÄSQLÓï¾äÂß¼­Ö§³Ö¡£
Óï·¨½á¹¹°üÀ¨¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£
1£©²»´ø²ÎÊý£º
Create or replace procedure NoparProcedureName
is
begin
delete from tablename  a where a.id='';
delete from tablename b where b.id=''; 
exception
end;
2)´ø²ÎÊý£º
Create or replace procedure ParProcedureName(key_id in char)
is
begin
delete from tablename  a where a.id=key_id;
update tablename b set b.name='²âÊÔ' where b.id=key_id; 
exception
end;
3)´ø²ÎÊýº¬¸³Öµ
Create or replace procedure MyProcedureName(key_id in char,isal out varchar)
is icount number ;
begin
select count(*) into icount from emp where sal>isal ;
if icount==1 then ...
esle
...
end if ;
end


Ïà¹ØÎĵµ£º

oracle º¯ÊýÕûÀí(Ò»)

1. ASCII: ·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii(0) zero,ascii('') space from dual; 
   A A ZERO SPACE
   --------- --------- --------- ---------
   65 97 48 
2. CHR:¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQ ......

¹ØÓÚOracleµÄÐòÁУ¨Sequence£©Ê¹ÓÃ

OracleûÓÐ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ£¬ÎÒÃÇÐèÒª½¨Á¢Ò»¸ö×Ô¶¯Ôö³¤µÄÐòÁкţ¬²åÈë¼Ç¼ʱҪ°ÑÐòÁкŵÄÏÂÒ»¸öÖµ¸³ÓÚ´Ë×ֶΣ¡
create sequence type_id increment by 1 start with 1;
Õâ¾äÖУ¬type_idΪÐòÁкŵÄÃû³Æ£¬Ã¿´ÎÔö³¤Îª1£¬ÆðʼÐòºÅΪ1¡£
Èç¹ûҪɾ³ýÐòÁУ¬ÓÃdrop sequence ÐòÁÐÃû¾Í¿ÉÒÔÁË£¡£¡
ÐòÁпÉÒÔ±£Ö¤¶à¸öÓû§¶ÔÍ¬Ò»Õ ......

ÉîÈëѧϰOracle·ÖÇø±í¼°·ÖÇøË÷Òý

http://www.csip.com.cn/88/n-52488.html
 ¹ØÓÚ·ÖÇø±íºÍ·ÖÇøË÷Òý(About Partitioned Tables and Indexes)¶ÔÓÚ10gR2¶øÑÔ£¬»ù±¾ÉÏ¿ÉÒԷֳɼ¸Àࣺ
Range(·¶Î§)·ÖÇø
Hash(¹þÏ£)·ÖÇø
List(Áбí)·ÖÇø
ÒÔ¼°×éºÏ·ÖÇø£ºRange-Hash,Range-List¡£
¶ÔÓÚ±í¶øÑÔ(³£¹æÒâÒåÉϵĶÑ×éÖ¯±í)£¬ÉÏÊö·ÖÇøÐÎʽ¶¼¿ÉÒÔÓ¦ÓÃ(ÉõÖÁ¿ÉÒÔ¶Ôij¸ö ......

oracle ×Ö·û¼¯ÎÊÌâ

1.oracle×Ö·û¼¯ÎÊÌ⣺
Êý¾Ý¿â×Ö·û¼¯ÎªZHS16BGK£¬ºº×ÖÔÚÊý¾Ý¿â´æ·ÅµÄʱºòÕ¼ÓÃÁ½¸ö×Ö½Ú
Êý¾Ý¿â×Ö·û¼¯ÎªUTF8£¬ºº×ÖÔÚÊý¾Ý¿âÀï´æ·ÅµÄʱºòÕ¼ÓÃÈý¸ö×Ö½Ú
ÓÉÓÚ×Ö·û¼¯²»Í¬£¬µ¼ÖÂÏÖÔÚÊý¾Ý¿âIMPµÄʱºòÓÐЩ±íµÄ×ֶγ¤¶È²»¹»£¬³öÏÖORA-12899: value too large for columnµÄ´íÎó¡£
ͨ¹ýÐÞ¸Ä×Ö·û¼¯¿ÉÒÔ½â¾öÕâÖÖÎÊÌâ¡£
2.utf-8ºÍunico ......

Oracle 9iµÄÊý¾ÝÀàÐÍ

 
 Oracle 9i¹²ÌṩÁË16ÖÖ±êÁ¿Êý¾ÝÀàÐÍ£¬Èç±í7.4Ëùʾ¡£
±í7.4 Oracle 9iµÄ±êÁ¿Êý¾ÝÀàÐÍ
Ãû³Æ
º¬Òå
Char
ÓÃÓÚÃèÊö¶¨³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=2000×Ö½Ú
varchar2
ÓÃÓÚÃèÊö±ä³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=4000×Ö½Ú
nchar
ÓÃÀ´´æ´¢Unicode×Ö·û¼¯µÄ¶¨³¤×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=1000×Ö½Ú
nvarchar2
ÓÃÀ´´æ´¢Un ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ