Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÅäÖû·¾³±äÁ¿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ÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

oracle - Oracle / »ù´¡ºÍ¹ÜÀí

oracleÊý¾Ý¿âÓÐÄÄЩ¶ÔÏó
ÕâÎʵÃÌ«ÁýͳÁË,ÓÑÇé°ï¶¥.

ÕâÊÇÒ»¸ö´óÎÊÌ⣬ºÜ´óµÄÎÊÌâ¡£


°ï¶¥......
------------------------------------------------------------------------------ 
Blog£º http://b ......

oracleÊý¾Ý¿â - Oracle / ¸ß¼¶¼¼Êõ

ÔÚOracleÖÐÔõôɾ³ýÖØ¸´µÄÐУ¬µ«Òª±£ÁôÒ»Ìõ¼Ç¼¡£

delete table where rowid not in (select max(rowid) from table group by col1,col2,...,coln);

¶Ô£¬ÓÃrowid À´¹ýÂË.

delete tb a
where a.rowid > ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ