ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
ÒòΪÄã°ÑÎļþ¼Ð¿´´íÁ˰ɡ£
´ó¸ç£¬Èç¹û²»ÊÇÄãÑÛ»¨µÄ»°£¬ÄÇ¿ÉÄܾÍÊÇÄã½ø´íµØ·½ÁË¡£
ÓÃÈýÂ¥µÄ·½·¨²éһϾÍÖªµÀÊÇʲôÁË
ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£
ÕûÈËÓÐÒâ˼Â𣿡¡ÖªµÀ´ð°¸Ö±½Ó·¢ÉÏÀ´¹²Í¬Ñ§Ï°¡£¡¡Ñ§Ï°ÒªÇ«Ð飬¡¡Ã¿È˶¼ÓÐ×Ô¼ºµÄÓŵ㡣¡¡±ðÈËÈÈÐĵİïÄ㣬»¹³ö¿ÚÂîÈË£¬ÓÖ¼ûÒ»¸ö¸öÐÔµÄ90ºó£¬ ÕæÎÞÓïѽ.. ÒÔºó»¹ÏëÔÚÕâÀï»ì£¬×îºÃÇ«Ðéµã..
liuxinyu19901016
ÏȰÑÕâÌù¶¥ÆðÀ´£¬Èôó¼Ò¶¼ÈÏʶÈÏʶÄã.. liuxinyu19901016
¹þ¹þ
90ºó¡¡
ʲô½ÐÖªµÀ´ð°¸£¬ÕâÊǺóÀ´Ñ§Ï°²éÕÒ¸ãÃ÷°×µÄ¡£Ê²Ã´½ÐÎÒÑÛ¾¦ÓÐÎÊÌ⣬²»ÖªµÀ¾ÍÊDz»ÖªµÀ»¹ÓýƱçÂð£¿ÎÞÓï¡£¡£¡£¡£¡£
ºÇºÇ
ºÍг ÂÛ̳ÐèÒªºÍг
1
¼´±ãÊÇÄãºóÀ´×Ô¼ºÍ¨¹ýѧϰ¸ãÃ÷°×ÁË Ò²ÒªÀ´ºÍ´ó¼Ò·ÖÏíÒ»ÏÂѽ ÔõôÄÜÖ»Îʲ»·ÖÏíÄØ ¶Ô²»¶Ô ÂÛ̳¾ÍÊÇÒ»¸ö´ó¼Ò»¥°ï»¥Öú¹²Ïí֪ʶµÄµØ·½
2
¼´±ãij¸öÈË˵´íÁË»° ÄãÒ²²»ÄÜ˵´ó¼Ò¶¼ÊÇÖí°É ºÇºÇ
Ïà¹ØÎÊ´ð£º
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......
±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......
Developer SuiteÁ¬½ÓÊý¾Ý¿âµÄÎÊÌ⣬ÀͼݸßÊÖÖ¸µã£¡
µçÄÔÀïÃæÍ¬Ê±×°ÁËOraHome92ºÍDevSuiteHome2£¬Ç°ÕßµÄsql*plusÄÜ·ÃÎÊ£¬ºóÕßµÄÔò²»ÐС£ÊäÈëscott/tigerµÇ½ºóÕßʱ£¬ÎÒÊäÈëÁË"Ö÷»ú×Ö·û´®"ºÅÒԺ󣬱¨´í£º&n ......
лл
ÎÒÒ²ÊÇÏëÖªµÀ
me too
ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......
¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......