³öÓÚ½ÚÔ¼µÄ¿¼ÂÇ£¬ÓÃSolaris 10 u4 SPARC CD1ºÍSolaris 10 u4 SPARC DVD¾µÏñ°²×° »úÐÍSun Fire V880£¬ÄÚ´æ8G£¬Áù¿é72GÓ²ÅÌ ÓùâÅÌÆô¶¯£¬ÏµÍ³³õʼѡÏîÉèÖÃÍê³Éºó£¬ÔÚ²»ÍêÕûµÄCDEÏ¿ªÆô¿ØÖÆÌ¨ ½«·Ç°²×°Ä¿±êµÄÒ»¿éÓ²ÅÌ·ÖÇø£¬´´½¨Îļþϵͳ£¬mountµ½/mntÏ ftpµ½×Ô¼ºµÄFTP·þÎñÆ÷£¬ÏÂÔØ¾µÏñ¡£ lofiadm ¨Ca /mnt/¡±¹âÅÌÓ³ÏñÎļþÃû¡± umount /cdrom rm /dev/dsk/c0t6d0s0 cd /dev/dsk n ¨Cs ../lofi/1 c0t6d0s0 mount ¨CF hsfs ¨Co ro /dev/...
oracleÖУº¡°ÔõôÑùÈÃÒ»¸ö±í,Ò»¸öʱ¼äÖ»ÄÜÒ»¸öÈ˶Á¡±£¬??? ÇëÖ´½ÌÎÒ Ð»£¡£¡£¡
INSERT INTO "CHEN"."COLLECT_DEFINE"(NODE_NAME,NODE_IP,NODE_PORT,PORT_TYPE,TYPE_DESC,TIMEOUT_ALARM,REL_NUM) VALUES('101','192.168.16.123',7601,1,'alarm',30,1), ('102','192.168.16.123',7602,1,'alarm',30,2); ÔÚoracleÀïÐв»Í¬Ñ½,²»ÖªµÀÔõôÑùʵÏÖÄØ?
ÒªÊä³ö·ûºÏÒªÇó¸ñʽµÄÊý¾ÝÎļþÖ»ÐèÔÚselectʱÓÃ×Ö·ûÁ¬½ÓÀ´¹æ·¶¸ñʽ¡£±ÈÈçÓÐÈçϱí SQL>; select id,username,password from myuser;//²âÊÔ±í 1 John 1234 2 Jack 12345 3 Rose 2345 4 Joe 384657 5 Tom 384655 6 Jordan 384455 ÒªÊä³ö·ûºÏ1,John,1234,ÕâÑùµÄÊý¾Ý¸ñʽ¾ÍÓÃselect id||','||username||','||password||',' from myuserÕâÑù...
ÏÖÔÚ¿ÉÒÔÀûÓÃsqlldr¿ÉÒÔ½«¹æ·¶µÄÎı¾µ¼Èëµ½oracleÊý¾Ý¿âÖÐ È磺 aaaa,aaaa,111,222,333 ÎÊÌâÊÇÈçºÎ½«ÒѾ´æÔÚµÄoracleÊý¾Ý±íµÄÊý¾Ýµ¼³ö³ÉÕâÖֹ淶µÄÎı¾ÎļþÄØ£¿£¿ Çó½â£¡
ÎÊÌ⣺ ÎÒµÄoracleÊý¾Ý¿â·þÎñÆ÷µÄ×Ö·û¼¯ÊÇZHS16GBK£¬µ«ÊÇoracle¿Í»§¶ËµÄNLS_LANGΪNA,²»ÖªµÀÕâÑù¿Í»§¶ËµÄ×Ö·û¼¯ÊDz»ÊÇÓë·þÎñÆ÷µÄ×Ö·û¼¯Ò»Ö£¿Èç¹û²»Ò»Ö£¬ÎҸý«NLS_LANGµÄÖµÉèΪʲô£¿ ÇëÖ¸µã£¬Ð»Ð»¡£ ÏÂÃæ²¹³äÊý¾Ý¿â·þÎñÆ÷µÄÏêϸÐÅÏ¢£º NAME VALUE$ ------------------------------ --------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CHARACTERSET ...
°Ñmysqlµ¼Èëµ½oracleÖУ¬µ¼Èë¶¼Õý³£µÄ£¬µ«ÎÒ¼¸ºõÿÕÅ±í¶¼ÓÐÒ»¸ö×Ö¶ÎÃûΪ user µÄ×ֶΣ¬Õâ¸ö×Ö¶ÎÎÒÓà select * from tableÊÇûÎÊÌâµÄ£¬userÏÔʾÕý³££¬µ«ÎÒÓÃselect user from table ·¢ÏÖÕâ¸öuserµÄֵȫ²¿ÊÇSYSTEM£¬ÏëÏëÓ¦¸ÃÊÇoracle¹Ø¼ü×ÖµÄÎÊÌ⣬¶øÇÒÎÒʹÓÃÁ˺ܶà×óÁ¬½Ó£¬ÀïÃæ on µÄ»°Ò²ÓÃuser×ֶεģ¬ÕâÑùËü¾Í»áÌáʾ: µÚ 1 ÐгöÏÖ´íÎó: ORA-01747: ÎÞЧµÄÓû§.±í.ÁÐ, ±í.ÁÐ, »òÁйæ¸ñ.. sqlÓï¾äÈçÏ£º SELECT b.title,b.id,b...
Èç½á¹û£º1 20040401000089 ÒѾÕý³£¡£ 2004.04.01 11£º10·Ö 2 20040401000212 ÒѾÕý³£¡£ 2004.04.01 ÔÚ¿âÖÐʱ¼äÓ¦¸ÃÊÇÔÚÎı¾ºóÃæµÄ£º(ÒѾÕý³£¡£ 2004.04.01 11£º10·Ö)Ò»¸ö×ֶΡ£ ÕâÑùµ¼³öµÄÎı¾²»±ãÓÚ´¦Àí£¬¸÷λ´óÏÀ£¬ÊÇÎÒ²Ù×÷ÓÐÎó»¹ÊÇÆäËüµÄ ʲôÎÊÌ⣬oracle²»Ê죬¼ûЦÁË¡£
ÎÒÏÖÔÚÖØÐÂÆô¶¯ÏµÍ³ºóÊäÈëSQLPLUS¡£ÊäÈëÓû§ÃûºÍÃÜÂë²»Äܵǽѽ£¿ ÔõôÑù²ÅÄܽ¨Ò»¸öʵÀý£¬ÔÚ½¨Êý¾Ý¿â£¿
ÓÐÒ»ÕűȽϴóµÄoracle±í£¬ÎªÁËÌá¸ßËÙ¶È£¬Ï£ÍûÓÃ¶à½ø³Ì²¢·¢¶ÁÈ¡ÕâÕűí¶Á£¬ÇëÎÊ´ó¼ÒÓ¦¸ÃÈçºÎ±£Ö¤½ø³Ì¼ä²»»á¶Áµ½Öظ´µÄÊý¾Ý²¢ÇÒ²»»á©¶ÁÄØ£¿´ó¼Ò¶à°ï°ïæ°¡£¬Íò·Ö¸Ðл~