ÅäÖû·¾³±äÁ¿oracleÔÚ XP - Oracle / »ù´¡ºÍ¹ÜÀí
ÅäÖû·¾³±äÁ¿oracleÔÚ XP
ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.
XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûºÍIP¾Í¿ÉÒÔÁË
»òÕßÖ±½ÓÅäÖð²×°Ä¿Â¼ÏµÄADMIN/NETWORK/TNS¡£ORAÎļþ
LINUXϰ²×°ORACLEËùÐèµÄ»·¾³±äÁ¿ÔÚXP¶¼±»×Ô¶¯Ð´½ø×¢²á±íÁË£¬²»ÐèÒªÅäÖÃÁË
°²×°Íê³É£¬Èç¹ûÊÇ·þÎñÆ÷±¾»úµÇ¼£¬¿ÉÒÔ²»ÓÃÈκÎÅäÖã¬Ö±½Ó
c:>sqlplus <Óû§Ãû>/<ÃÜÂë>
¾Í¿ÉÒԵǼʹÓÃÁË£¬Èç¹ûÔÚÆäËü¿Í»§¶ËµÇ¼£¬ÔòÐèÒªÅäÖüàÌýºÍTNSNAMES
windows
»·¾³±äÁ¿°²×°Ê±¶¼±»×Ô¶¯Ð´½ø×¢²á±íÁË
ÎÒÏëÎʵÄÊÇÔõÑù²ÅÄÜÐ޸Ļ·¾³±äÁ¿£¿Ð»Ð»
ÐÞ¸Ä×¢²á±íÁË¡£¡£¡£¡£¡£¡£
ÄܾßÌåµÄ˵˵¸ÃÔõôÐÞ¸ÄÂð£¿ÎÒÊdzõѧÕß
лл
http://www.hackline.net/a/Special/Linux/application/2009/1107/1424.html
Õâ¸ö¿ÉÄÜÄãÒªµ½oracle¹Ù·½ÍøÕ¾¿´¿´
»¹ÊÇû¿´Ã÷°×°¡
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
oracleÊý¾Ý¿âÓÐÄÄЩ¶ÔÏó
ÕâÎʵÃÌ«ÁýͳÁË,ÓÑÇé°ï¶¥.
ÕâÊÇÒ»¸ö´óÎÊÌ⣬ºÜ´óµÄÎÊÌâ¡£
°ï¶¥......
------------------------------------------------------------------------------
Blog£º http://b ......
ÔÚOracleÖÐÔõôɾ³ýÖØ¸´µÄÐУ¬µ«Òª±£ÁôÒ»Ìõ¼Ç¼¡£
delete table where rowid not in (select max(rowid) from table group by col1,col2,...,coln);
¶Ô£¬ÓÃrowid À´¹ýÂË.
delete tb a
where a.rowid > ......