¸÷λ´óÏÀ£¬Ð¡µÜÇë½ÌÒ»¸ö´ó×ֶε¼Èëµ¼³öµÄÎÊÌ⣡
ÎÒÔÚ±í¿Õ¼äÖÐÅܽű¾½¨Á¢ºÃһЩ±í£¬²¿·Öº¬Óдó×ֶΣ¨CLOB£©£¬È»ºó´æÈ벿·ÖÊý¾Ý¡£
ÔÙÀûÓÃPLSQL¹¤¾ß½«´ËÊý¾Ý¿âµ¼³ö£¨³É¹¦ÎÞ´íÎóÌáʾ£©
È»ºó½«´ËÊý¾Ý¿âÎļþµ¼Èëµ½ÁíÍâһ̨µçÄÔÉÏ£¬È´Ìáʾ´íÎó(º¬Óдó×Ö¶ÎµÄ±í¶¼ÎÞ·¨µ¼Èë)£¬»·¾³ÊÇÒ»ÑùµÄ£¡
ÇëÎÊÓ¦ ......
ÇëÎÊÔÚsql2005Êý¾Ý¿âÖУ¬¿ÉдһϺ¯Êý£º
if object_id('orderchar') <>0 drop function orderchar
go
create function OrderChar(@OriStr varchar(100))
returns varchar(100)
as
BEGIN
DECLARE @re varchar(100) --·µ»ØÖµ
DECLARE @ch char - ......
ÎÒÃǵÄoracleÊý¾Ý¿âÔÚÒ»¸ö·þÎñÆ÷ÉÏ£¬µØÖ·ÊÇ192.168.10.11£¬ÎÒÏë°ÑÊý¾Ý¿âµ¼³öµ½Îҵı¾µØ×ö±¸·Ý£¬Ôõô×ö£¿
exp user/password@orcl full=y file='......';
oracleʲô°æ±¾µÄ£º
±¾»úÒѾ½¨Á¢µÄÁ´½Ó·þÎñ
imp Óû§Ãû/ÃÜÂë@·þÎñÃû file=ÄãÒª±£´æµÄ·¾¶\±¸·ÝÃû³Æ.dmp
±¾»úûÓн¨Á¢Ö¸Ïò·þÎñÆ÷µÄ·þÎñ
imp ÓÃ ......
Çë¸ßÊÖ°ï°ï棬¾ÀíÒªÎÒÉèÖÃoracleÊý¾Ý¿âÍíÉÏ12µã×Ô¶¯±¸·Ý£¬ÎÒÔÚѧУ¶¼Ã»Ñ§¹ýÕâÑùµÄ£¬²»¶®Ôõô×ö£¬ÈçºÎдÃüÁÇë¸ßÊֽ̽ÌÎÒ£¬°ÑÏêϸ²½ÖèдÏ£¬Ð»Ð»£¡ÔÚÏߵȣ¬¼±¼±¼±
Windowsϵͳ¿ÉÒÔ×öÒ»¸öbatÎļþ£¬Ìí¼ÓÈÎÎñ¼Æ»®¶¨Ê±Ö´ÐÐ
ÒýÓÃ
Windowsϵͳ¿ÉÒÔ×öÒ»¸öbatÎļþ£¬Ìí¼ÓÈÎÎñ¼Æ»®¶¨Ê±Ö´ÐÐ
linux,°Ñshell±¸·Ý½Å± ......
ÇëÎÊÈç¹ûÒª¼æÈÝoracle,mysql,mssqlÈý¸öÊý¾Ý¿â,hibernateµÄÖ÷¼ü×ÔÔö²ß·ÊDz»ÊÇÖ»ÄÜÑ¡ÔñnativeÄØ?ÎÒÊÔ¹ý ÁË
incrementËäÈ»¿ÉÒÔ,µ«ÊÇincrementÔÚ¶à¸öÏ̷߳ÃÎÊÒ»¸ö±íµÄʱºò ......
ÔÚubuntu9.04(ÐéÄâ»ú)Éϰ²×°oracle 10g,ǰÆÚ¹¤×÷»¹±È½Ï˳Àû£¬µ±ÊäÈë./runInstallerʱ²úÉú´íÎó£ºbash: ./runInstaller:No such file or directory¡£ÎÒ²»ÖªµÀoralceµÄ°²×°ÎļþÓ¦¸Ã·ÅÔÚʲôλÖ㬳¢ÊÔÁ˼¸¸ö¶¼²»ÐС£Çë´ó¼Ò°ï°ï棡ÎÒÒѾװÁËÁ½Ìì¶àÁË£¡linuxºÍoracle¶¼ÊǸսӴ¥£¬²ËÄñÒ»¸ö£¡ÔÚÏßµÈ---
Çë¸÷λ¸ßÊÖ°ï°ï棡¶àлÁ ......