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

Oracle³£¼ûº¯Êý´óÈ«

SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
       A       A    ZERO     SPACE
--------- --------- --------- ---------
   65        97        48        32
2.CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- -
ÕÔ A
3.CONCAT
Á¬½ÓÁ½¸ö×Ö·û´®;
SQL> select concat('010-','88888888')||'ת23'   ¸ßǬ¾ºµç»° from dual;
¸ßǬ¾ºµç»°
----------------
010-88888888ת23
4.INITCAP
·µ»Ø×Ö·û´®²¢½«×Ö·û´®µÄµÚÒ»¸ö×Öĸ±äΪ´óд;
SQL> select initcap('smith') upp from dual;
UPP
-----
Smith
5.INSTR(C1,C2,I,J)
ÔÚÒ»¸ö×Ö·û´®ÖÐËÑË÷Ö¸¶¨µÄ×Ö·û,·µ»Ø·¢ÏÖÖ¸¶¨µÄ×Ö·ûµÄλÖÃ;
C1 ±»ËÑË÷µÄ×Ö·û´®
C2 Ï£ÍûËÑË÷µÄ×Ö·û´®
I     ËÑË÷µÄ¿ªÊ¼Î»ÖÃ,ĬÈÏΪ1
J     ³öÏÖµÄλÖÃ,ĬÈÏΪ1
SQL> select instr('oracle traning','ra',1,2) instring from dual;
INSTRING
---------
       9
6.LENGTH
·µ»Ø×Ö·û´®µÄ³¤¶È;
SQL> select name,length(name),addr,length(addr),sal,length(to_char(sal)) from gao.nchar_tst;
NAME LENGTH(NAME) ADDR          LENGTH(ADDR)    SAL LENGTH(TO_CHAR(SAL))
------ ------------ ---------------- ------------ --------- --------------------
¸ßǬ¾º          3 ±±¾©Êк£¶§Çø             6 9999.99                    7
7.LOWER
·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·ûСд
SQL> select lower('AaBbCcDd')AaBbCcDd from dual;
AABBCCDD
--------
aabbccdd
8.UPPER
·µ»Ø×Ö·û´®,²¢½«ËùÓеÄ×Ö·û´óд
SQL> select uppe


Ïà¹ØÎĵµ£º

Oracle PL\SQL²Ù×÷£¨Î壩

1.ÔÚ±íÖ®¼ä´«ÊäÊý¾Ý
1£©ÀûÓÃINSERT´«ÊäÊý¾Ý
insert into test1 (select name2,age2 from test2);
´ÓÉÏÃæµÄ²Ù×÷¿ÉÒÔ¿´³ö£¬¿Éͨ¹ýSELECTÏòÒ»¸ö±íÖгÉÅúµØÌí¼ÓÊý¾Ý£¬µ«Ó¦×¢Ò⣺Êý¾ÝÀàÐÍÒªÒ»Ö£¬ËùÑ¡ÔñµÄÁÐÊýÓ¦Ò»Ö¡£´ËÓï¾äµÄÓï·¨¸ñʽÈçÏ£º
INSERT INTO table_name (
SELECT statement
) ;
2£©»ùÓÚÒÑÓÐµÄ±í½¨Á¢Ð ......

¹ØÓÚoracle·þÎñ

OracleOraHome92Agent
OracleOraHome92ClientCache
OracleOraHome92HTTPServer
OracleOraHome92PagingServer
OracleOraHome92SNMPPeerEncapsulator
OracleOraHome92SNMPPeerMasterAgent
·Ö±ðÊÇ:
Agent´úÀí, OEMÈý²ã¹ÜÀíʱÓëOMS½øÐеǼǴ¦¹µÍ¨;
¿Í»§¶ËÐÅÏ¢Cache;
ÌṩWeb·þÎñ;
BP»ú֪ͨ·þÎñ,±ÈÈçÊý¾Ý¿âÓ ......

oracle£ºCLUSTER

±í´Ø£¨table   cluster)ÊÇÒ»¸öÊý¾Ý¿â¶ÔÏó£¬Ëü¿ÉÒÔ½«ÄÇЩ¾­³£ÔÚÏàͬÊý¾Ý¿éÖÐÒ»ÆðʹÓõıí½øÐÐÎïÀí·Ö×é¡£µ±Äã´¦ÀíÄÇЩ¾­³£Á¬½ÓÔÚÒ»Æð½øÐвéѯµÄ±íʱ£¬±í´ØÊÇÌرðÓÐЧµÄ¡£Ò»¸ö±í´Ø´æ´¢´Ø¼ü£¨ÓÃÓÚ½«±íÁ¬½Óµ½Ò»ÆðµÄÁУ©£¬ÒÔ¼°´Ø±íÖеÄÁÐÖµ¡£ÒòΪ´ØÖÐµÄ±í¶¼±»´¢´æÔÚÏàͬµÄÊý¾Ý¿â¿éÖУ¬ËùÒÔʹÓôع¤×÷ʱ£¬I/O²Ù×÷¾Í¼õÉÙÁË¡£
......

´ÓOracleÊý¾Ý¿âµ¼³ö±í½á¹¹µ½PD

1¡¢Ð½¨PDM.ÓÒ»÷Workspace->New->Free Model->Physical Data Model 
2¡¢Model nameÈÎÒâ, DBMS=>ORACLE Version 9i2->È·¶¨
3¡¢ÅäÖÃODBC
¿ØÖÆÃæ°å->¹ÜÀí¹¤¾ß->Êý¾ÝÔ´(ODBC)->ϵͳDSN->Ìí¼Ó,Èç¹ûÓÐ×°ÍêÕûµÄOracle¿Í»§¶Ë»á³öÏÖרÃŵÄÇý¶¯,ÎÒµÄÊǼò°æµÄ¾ÍÑ¡
"Microsoft ODBC for Oracl ......

ÔõôѡÔñÒ»¸ö¶ÔµÄOracle DBA

´ó²¿·ÖµÄÆóÒµºÜÄÑÒ»ÏÂ×Ó¾ÍÕÒµ½Ò»¸öÈ«·½Î»µÄOracle DBA£¨µ±È»Ò²ÊÇÓпÉÄÜ£¬Ö»²»¹ý£¬Õâ»áÓкܴóµÄÔËÆø³É·Ý£©£¬Õâ´ú±íÆóÒµÔÚÑ¡ÔñOracle DBAµÄʱºò£¬ÊƱØÒª¶Ô¸ºÔð¸ÃְλµÄDBAµÄÖ°ÄÜÓÐËùÈ¡Éá¡£ÎÒͨ³£»á½¨ÒéÎҵĿͻ§£¬ÔÚÑ°ÕÒOracle DBAʱ£¬µÃÏÈÈ·ÈÏ£¬ÆóÒµÐèÒªÕâÒ»¸ö½ÇÉ«À´Æä´¦ÀíʲôÎÊÌ⣿
¡¡¡¡´ó²¿·ÝµÄÆóÒµ¶ÔOracle DBAµÄÐèÇó£¬Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ