¹ØÓÚORACLE¼àÌý·þÎñÎÞ·¨Æô¶¯µÄÎÊÌâ
½ñÌìµçÄÔÄûؼң¬Æô¶¯oracleÊý¾Ý¿âµÄ¼àÌý·þÎñʱ·¢ÏÖÎÞ·¨Æô¶¯¡£¸ø³öµÄ´íÎóÌáʾÊÇ˵£¬Õâ¸ö·þÎñÆô¶¯ÁËÓÖÍ£Ö¹ÁË£¬²»ÖªµÀÊÇΪʲô¡£ÒòΪÔÚѧУµÄʱºòÓÃÊÇûÓÐÎÊÌâµÄ¡£ÎÒÏëÓ¦¸ÃÊÇÒòΪipµÄÊÇÎÊÌâ¡£ÔÚÍøÉϲéÁËһϣºÄãÊÇ·ñÐÞ¸ÄÄãµÄ»úÆ÷Ãû»òIPµØÖ·£¬Èç¹ûÓÐÐ޸쬰ÑORACLE\ora81\network\admin\listener.oraÎļþÖеÄhostÐÞ¸ÄΪлúÆ÷Ãû»òIP¡£ÎÒÓõÄÊÇoracle 10g£¬listener.oraµÄĿ¼ÔÚD:\oracle\product\10.1.0\db_1\NETWORK\ADMINÏ¡£listener.oraÎļþµÄÄÚÈÝÈçÏ£º
# listener.ora Network Configuration File: d:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
)
)
)
ÐÞ¸ÄΪ£º
# listener.ora Network Configuration File: d:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
174. /*+ALL_ROWS*/
¡¡¡¡ ±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='CCBZZP';
¡¡¡¡ 175. /*+FIRST_ROWS*/
¡¡¡¡ ±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ¼ä,ʹ×ÊÔ´ÏûºÄ×îС»¯.ÀýÈç:
SEL ......
ORACLE內²¿º¯數ƪ ×Ö·û´®
204. ÈçºÎµÃµ½×Ö·û´®µÄµÚÒ»個×Ö·ûµÄASCIIÖµ?
ASCII(CHAR)
SELECT ASCII('ABCDE') from DUAL;
結¹û: 65
205. ÈçºÎµÃµ½數ÖµNÖ¸¶¨µÄ×Ö·û?
CHR(N)
SELECT CHR(68) from DUAL;
結¹û: D
206.  ......
ѧÉúÔÚѧϰjdbcµÄʱºò£¬»áÎʵ½Ôõôµ÷Óô洢¹ý³Ì£¬ÏÖÔÚ½«javaµ÷ÓÃoracle´æ´¢¹ý³ÌµÄʾÀý×ܽáÈçÏ¡££¨¹ØÓÚµ÷ÓÃsqlserverµÄ´æ´¢¹ý³Ì½«ÔÚÏ´νøÐÐС½áÇë¹Ø×¢£©
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌΪ£º
• create or replace procedure adddept(deptno number,dname varc ......
×î½ü×ܽáÁËÒ»ÏÂoracleÖ÷¼üµÄÉèÖ÷½·¨£¬Ìùµ½Õâ±£´æÒ»Ï°ɡ£ ÓÐÁ½ÖÖ·½·¨¿ÉÒÔÉèÖÃÖ÷¼ü£¬Ò»ÖÖÊÇ×ÔÔö³¤Ö÷¼ü£¬ÁíÒ»ÖÖ¾ÍÊÇÉú³ÉΨһÐòÁС£ Ò»¡¢×ÔÔö³¤Ö÷¼ü --Ê×ÏȽ¨Ò»¸ö±íTEST
create tableTEST (
NID int PRIMARY KEY,
test1 varchar2(20),
test2 varchar2(20),
test3 ......