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

Oracle½âËøÓë¼ÓËø£¨hrÓû§ÎªÀý£©


Oracle½âËøÓë¼ÓËø£¨hrÓû§ÎªÀý£©
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 14 18:12:38 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
SQL> conn sys/sys as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> desc dba_users
 Name                                   Null?    Type
 ----------------------------------------- -------- ----------------------------
 USERNAME                         NOT NULL VARCHAR2(30)
 USER_ID                             NOT NULL NUMBER
 PASSWORD                                 VARCHAR2(30)
 ACCOUNT_STATUS                   NOT NULL VARCHAR2(32)
 LOCK_DATE                                       DATE
 EXPIRY_DATE                                    DATE
 DEFAULT_TABLESPACE                    NOT NULL VARCHAR2(30)
 TEMPORARY_TABLESPACE&n


Ïà¹ØÎĵµ£º

ORACLE ³£ÓÃ×Ö·ûº¯Êý


1.LOWER(str) Ç¿ÖÆÐ¡Ð´
2.UPPER(str) Ç¿ÖÆ´óд
3.INITCAP(str) ÿ¸öµ¥´ÊÊ××Öĸ´óд
ʾÀý£º
SQL> select initcap('my_boy') from dual; --·µ»Ø"My_Boy"
×¢Ò⣺µ¥´ÊÖ®¼äÓÃÏ»®Ïߣ¨"_"£©·Ö¸î
4.CONCAT(str1,str2£©Á¬½Óº¯Êý,Á¬½Óstr1ºÍstr2×Ö·û´®
5.SUBSTR(string,a[,b])·µ»ØstringµÄÒ»²¿·Ö£¬aºÍbÒÔ×Ö·ûΪµ¥Î»¡£´Ó× ......

oracle´æ´¢¹ý³ÌÒì³£ÐÅÏ¢µÄÏÔʾ

oracle´æ´¢¹ý³ÌÒì³£ÐÅÏ¢µÄÏÔʾ
֮ǰд´æ´¢¹ý³Ìʱ£¬Òì³£´¦Àíд·¨ÊÇ£º
...
EXCEPTION
  WHEN OTHERS THEN
    ROLLBACK;
END ...
ÕâÖÖд·¨µ±´æ´¢¹ý³ÌÅ׳öÒ쳣ʱ£¬ÎÒÃDz»ÖªµÀÆäµ½µ×Å׳öÁËÄÄÖÖÒì³££¨±ÈÈçÁпí¶È²»¹»´ó¶øÔÚ²åÈëÊý¾ÝʱÅ×Òì³££©£¬¿ÉÒÔ°´ÈçÏ·½Ê½ÏÔʾÒì³£ÐÅÏ¢
EXCEPTION
  ......

ÔÚAIX»·¾³ÎªOracle±í¿Õ¼äÔö¼ÓÂãÉ豸£¨Âß¼­¾í£©

µ±Ö´ÐвåÈëµÈ²Ù×÷ʱ³öÏÖ´íÎóÌáʾ“unable to extand table ……” £¬Ôò˵Ã÷¸Ã±íËùÔÚ±í¿Õ¼ä¿Õ¼ä²»×ãÁË¡£
Èç¹ûÊÇÔÚwinserverÏÂÔòΪ±í¿Õ¼äÔö¼ÓÎļþ¼´¿É£¨±¾ÎIJ»×ö½éÉÜ£©¡£
±¾ÎÄÖ÷Òª½éÉÜÊý¾Ý¿â·þÎñÆ÷»·¾³ÎªAIXʱ£¬ÈçºÎΪ±í¿Õ¼äÔö¼ÓÂãÉ豸¡£
͉˕
°üº¬AIXϵͳ´æ´¢¹ÜÀíµÄ»ù±¾½éÉÜ£»
AIXͨ¹ýÈý¸ö²ã´Î¶Ô ......

OracleÖеÄRawÀàÐͽâÊÍ

RAW£¬ÀàËÆÓÚCHAR£¬ÉùÃ÷·½Ê½RAW(L)£¬LΪ³¤¶È£¬ÒÔ×Ö½ÚΪµ¥Î»£¬×÷ΪÊý¾Ý¿âÁÐ×î´ó2000£¬×÷Ϊ±äÁ¿×î´ó32767×Ö½Ú¡£
¡¡¡¡LONG RAW£¬ÀàËÆÓÚLONG£¬×÷ΪÊý¾Ý¿âÁÐ×î´ó´æ´¢2G×Ö½ÚµÄÊý¾Ý£¬×÷Ϊ±äÁ¿×î´ó32760×Ö½Ú
¡¡¡¡½¨±í²Ù×÷:
¡¡¡¡create table raw_test (id number, raw_date raw(10));
¡¡¡¡²åÈërawÊý¾Ý²Ù×÷:
¡¡¡¡insert into raw ......

oracle¶¨Ê±ÈÎÎñ£¨dbms_job£©

½ñÌì×ܽáÏÂoracleµÄÈÎÎñ¶ÓÁйÜÀíÆ÷(job queue ),ÒÔºóÒ²·½±ã²éѯ.
 ÎÒÃÇÒª×ö¶¨Ê±ÈÎÎñʱ,ÓÐÁ½ÖÖ°ì·¨
Ò»ÖÖÊÇ: ²Ù×÷ϵͳµÄ¶¨Ê±,winµÄ¶¨Ê±ÈÎÎñ,unixµÄcrontab
Ò»ÖÖÊÇ: Êý¾Ý¿â¼¶µÄ¶¨Ê±,ËýµÄЧÂʸü¸ß,
ÔÙÓдóÁ¿µÄ±í¼¶²Ù×÷ʱ,½¨ÒéÓÃÊý¾Ý¿â±¾ÉíµÄjob queue,ÕâÑù·½±ã,ЧÂʸß;Èç¹ûÓÃϵͳ¼¶¶¨Ê±,
»áÔö¼ÓºÜ¶à±à³Ì¹¤×÷,³É±¾Ôö¼Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ