Ôõôǿ»¯oracleѧϰ
¸÷λ´óÏÀ£¬Ð¡µÜÒÔǰѧ¹ýoracle£¬µ«ÄÇÖ»ÊÇ»ù´¡¡£
ÏÖÔÚ¹«Ë¾Ö»ÊǼòµ¥µÄʹÓÃһЩsqlÓï¾ä¶øÒÑ¡£
µ«ÎÒÏëÈ¥ºÃ¹«Ë¾£¬¿ÉÄܶÔÓÚoracleÒªÇóºÜ¸ß
ËùÒÔÏë¼ÓǿһÏÂoracle֪ʶ£¬Ï£Íû´ó¼ÒÄܸøÐ©½¨Ò飬Ôõô½øÐÐÏà¹ØµÄѧϰ
Ö÷Òª»¹ÊÇÕë¶ÔʵÓÃÐÔ¡£»òÕ߸ø¸ö·½Ïò£¬Ñ§ÄÄЩ·½Ãæ±È½ÏʵÓá£
ÏÈл¹ý¡£
²»¼ä¶ÏµÄѧϰ¡£Ç°¶Îʱ¼ä¹«Ë¾Ã»ÓÐʲôÊ£¬ÎÒÉϰà¾ÍÒ»°ãѧϰoracle¡£ÄêÖÕÁËÒµÎñÉϵÄʱȽ϶àÁË£¬Ã»ÓÐʱ¼äѧϰºÍ¹®¹ÌÒÔǰѧµÄ¶«Î÷ÁË¡£ÓÐЩ¼òµ¥µÄÃüÁî»òÓï¾äһʱ°ë»á¶¼Ïë²»ÆðÀ´ÁË¡£
¡¡¼±ÕÐÆ¸ÖС£¡£¡£¡£¡£¡£¡£¡£¡£
ְλ±àºÅ:00000569 Oracle FIN/SCM-ÉϺ£/±±¾©¡¡¡¡
Oracle FINºÍSCMʵʩ¹ËÎÊ£ºÉϺ£/±±¾©£¬4ÄêÒÔÉÏʵʩ¾Ñ飬ӢÎÄ¿ÉÒÔ¼òµ¥½»Á÷¼´¿É¡£
ְλ±àºÅ 002531 Oracle²ÆÎñ,·ÖÏú,ÖÆÔì 18-25k/m
Oracle ²ÆÎñ£¬·ÖÏú£¬ÖÆÔì×ÊÉî¹ËÎÊ--5ÄêÒÔÉϾÑ飬ӢÎÄÁ÷Àû
ÓÐÒâÕßÇë·¢¼òÀú£¨×¢Ã÷ְλ±àºÅ£©µ½ÓÊÏävivian1683@live.cn
ÁªÏµ£Ñ£Ñ£¶£³£µ£¸£´£´£³£µ£±¡¡¡¡¡¡£Í£Ó£Î£ºvivian1683@live.cn
²é²é×ÊÁÏ£¡
ƽʱ¼òµ¥µÄÓ¦ÓÃûʲôÎÊÌ⣬ÏëÔÙѧµÄ¶¯Á¦ºÍ·½Ïò¾ÍûÓÐÁË
¿ÉÒÔÈ¥¹«Ë¾µÄʱºòÔÙÂýÂýѧµÄ°¡£¡
½¨ÒéÄãȥӦƸÏ£¡
ÎÒ¾ÍÊÇÕâÑù×ßÀ´µÄ£¡
¶à×öÏîÄ¿¾Í¿ÉÒÔÁË
¹þ¹þ£¬¶àÉÏÂÛ̳À²
¶÷£¬²»´í£¡
CSDN
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......