oracleÈÕÆÚµÄÔ·ݸñʽ
ÎÒµÄoracle9iÖУ¬ÈÕÆÚÏÔʾ¸ñʽÊÇ£º 26-9ÔÂ-09 µ«ÊÇÓÐÒ»¸ösql½Å±¾µÄÈÕÆÚ¸ñʽÊÇ£º 26-SEP-09 ÔÚµ¼Èë½Å±¾µÄʱºò·¢ÉúÁËÈÕÆÚ¸ñʽ³åÍ»µÄÎÊÌ⣬ÈçºÎ½â¾ö£¿
ÊÔÊÔ£¬¸ü¸Äϵ±Ç°»á»°µÄÈÕÆÚ¸ñʽ alter session set nls_language='ENGLISH' È»ºóÔÙÖ´Ðнű¾ÒýÓà ÎÒµÄoracle9iÖУ¬ÈÕÆÚÏÔʾ¸ñʽÊÇ£º 26-9ÔÂ-09 µ«ÊÇÓÐÒ»¸ösql½Å±¾µÄÈÕÆÚ¸ñʽÊÇ£º 26-SEP-09 ÔÚµ¼Èë½Å±¾µÄʱºò·¢ÉúÁËÈÕÆÚ¸ñʽ³åÍ»µÄÎÊÌ⣬ÈçºÎ½â¾ö£¿ ÐÞ¸Ä ÏÂϵͳµÄÈÕÆÚ¸ñʽ alter session set nls_language='ENGLISH' ÐÞ¸Ä alter session set nls_language='ENGLISH' ÅŶÓcopy ½Ó·Ö alter session set nls_language='ENGLISH' È» 55£¬ËÙ¶Èû¥ÉÏÁ½Î»¿ì ½áÌûÁË
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼ ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ² SQL code:
......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ......
ÎÒ´óרѧÀú£¬ÔÚÒ»¼Ǫ̀×Ê ¼¯ÍÅµÄ ·Ö¹«Ë¾ ×öÀ²Ò»Äê´óÐÍERPÈí¼þ¿ª·¢&ά»¤£¬ÏëÔÚÖ麣ÕÒ·Ý.netµÄ¹¤×÷£¬Òª¶àÉÙ¹¤×ʺÏÊÊ£¿ ¿ªÊ¼²»ÒªÌ«¸ß£¬3K×óÓÒÓ¦¸ÃÊDZê×¼ Ö麣ÄDZßËÆºõûÉîÛÚºÃ. Èç¹ûÊÇÎҵϰ,Ê×ÏÈÊÇÒª±ÈÏ ......
Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý. Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø. µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......
sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬ ÀýÈç sqlplus /nolog conn system/oracle£¨ÃÜÂ룩 Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔÀíÉÏ£© Èç¹ûÓÐ˶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......