¾Æµê¹ÜÀíϵͳ——Oracleµ¼ÈëdmpÎļþ
ÏÂÃæÊÇCMDÃüÁî´°¿ÚϵIJÙ×÷£¬¿´¿´ÊÇÔõôµ¼ÈëµÄ¡£
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\oeg2006>imp
Import: Release 9.2.0.1.0 - Production on ÐÇÆÚÈý 11ÔÂ 25 19:24:12 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Óû§Ãû: oeg2006
¿ÚÁî: (ÊäÈë ²»»ØÏÔ)
Á¬½Óµ½: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
µ¼ÈëÎļþ: EXPDAT.DMP> D:\Documents and Settings\Administrator\workspace\hotelman
age\hotelmanage\SEVEN_TABLES.dmp
ÊäÈë²åÈ뻺³åÇø´óС£¨×îСΪ 8192 ) 30720>16384(Ëæ±ãÊäµÄ)
¾Óɳ£¹æÂ·¾¶µ¼³öÓÉEXPORT:V09.02.00´´½¨µÄÎļþ
¾¯¸æ: ´Ë¶ÔÏóÓÉ SYSTEM µ¼³ö, ¶ø²»Êǵ±Ç°Óû§
ÒѾÍê³ÉZHS16GBK×Ö·û¼¯ºÍAL16UTF16 NCHAR ×Ö·û¼¯Öеĵ¼Èë
Ö»Áгöµ¼ÈëÎļþµÄÄÚÈÝ (yes/no): no > (°´»Ø³µ¼ü)
ÓÉÓÚ¶ÔÏóÒÑ´æÔÚ, ºöÂÔ´´½¨´íÎó (yes/no): no > yes
µ¼ÈëȨÏÞ (yes/no): yes > (°´»Ø³µ¼ü)
µ¼Èë±íÊý¾Ý (yes/no): yes >
µ¼ÈëÕû¸öµ¼³öÎļþ (yes/no): no > yes
. ÕýÔÚ½«SYSTEMµÄ¶ÔÏóµ¼Èëµ½ OEG2006
. . ÕýÔÚµ¼Èë±í "BOOK_INFORMATION" 4Ðб»µ¼Èë
. . ÕýÔÚµ¼Èë±í "GUEST_REGIST" 8Ðб»µ¼Èë
. . ÕýÔÚµ¼Èë±í "GUEST_REGIST_MIDDLE" 13Ðб»µ¼Èë
. . ÕýÔÚµ¼Èë±í "PAY_TAB" 0Ðб»µ¼Èë
. . ÕýÔÚµ¼Èë±í "ROOM_INFORMATION" &nb
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Ê×ÏÈÀ´ËµOracleµÄÍøÂç½á¹¹£¬Íù¸´ÔÓ´¦ËµÄܼÓÉϼÓÃÜ¡¢LDAPµÈµÈ¡£¡£ÕâÀï²»×öÌÖÂÛ£¬Öصã·ÅÔÚ»ù±¾µÄÍøÂç½á¹¹Ò²¾ÍÊÇÎÒÃÇ×î³£ÓõÄÕâÖÖÇé¿ö
¡¡¡¡
¡¡¡¡Èý¸öÅäÖÃÎļþ
¡¡¡¡
¡¡¡¡listener.ora¡¢sqlnet.ora¡¢tnsnames.ora £¬¶¼ÊÇ·ÅÔÚ$ORACLE_HOME\network\adminĿ¼Ï¡£
¡¡¡¡
¡¡¡¡Öصã:Èý¸öÎļþµÄ×÷ÓúÍʹÓÃ
¡¡¡¡
¡¡¡¡#------- ......
µ¥Ðк¯Êý:
º¯ÊýÀà±ð:
µ¥ÐÐ:·µ»Øµ¥¸ö½á¹û:substr,length
¶àÐÐ:·µ»Ø¶à¸ö½á¹û,any,all
µ¥ÐеķÖÀà:
×Ö·ûÀ࣬ÈÕÆÚÀ࣬Êý×ÖÀ࣬ת»»À࣬ͨÓÃÀà
1.×Ö·ûÀà
ת»»´óСд:
lower:ת»»ÎªÐ¡Ð´
Select ENAME,LOWER(ENAME) from EMP
upper:ת»»Îª´óд
Select upper( ......
×ªÔØ
from: http://cid-4e5d038451e31a25.spaces.live.com/blog/cns!4E5D038451E31A25!140.entry
create or replace procedure P_QuerySplit(
sqlscript varchar2, --±íÃû/SQLÓï¾ä
pageSize integer, ......