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

ÇëÎÊΪʲôOracle¼àÌýºó»áÓдóÁ¿µÄµÈ´ýÁ¬½Ó£¿

ÏÂÃæÊǸոÕÖØÆôºóÔËÐÐnetstatµÄ½á¹û£¬ÕªÂ¼ÁËÆäÖÐÓë1521¶Ë¿ÚÓйصIJ¿·Ö

  TCP    tky-026e3e945e8:1055  localhost:1521        ESTABLISHED
  TCP    tky-026e3e945e8:1057  localhost:1521        TIME_WAIT
  TCP    tky-026e3e945e8:1060  localhost:1521        TIME_WAIT
  TCP    tky-026e3e945e8:1061  localhost:1521        TIME_WAIT
  TCP    tky-026e3e945e8:1062  localhost:1521        TIME_WAIT
  TCP    tky-026e3e945e8:1063  localhost:1521        TIME_WAIT
  TCP    tky-026e3e945e8:1064  localhost:1158        TIME_WAIT
  TCP    tky-026e3e945e8:1065  localhost:1521        TIME_WAIT
  TCP    tky-026e3e945e8:1066  localhost:1521        TIME_WAIT
  TCP    tky-026e3e945e8:1068  localhost:1521        TIME_WAIT
  TCP    tky-026e3e945e8:1069  localhost:1521        TIME_WAIT
  TCP    tky-026e3e945e8:1070  localhost:1521        TIME_WAIT
  TCP    tky-026e3e945e8:1071  localhost:1521 


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

OracleÈçºÎʹÓô°¿Úº¯ÊýʵÏÖÕâÑùµÄ²éѯ

±í¼Ç¼
======================================
name        date        score
Fei Zhang  1          100
Fei Zhang  ......

Ôõô½«·ûºÅµ¥ÒýºÅ²åÈëORACLEÊý¾Ý¿âµÄ±íÖÐ

Ôõô½«·ûºÅµ¥ÒýºÅ²åÈëORACLEÊý¾Ý¿âµÄ±íÖÐÈ¥°¡£¿
лл¸÷λ.

SQL code:
SQL> insert into test values('''');
ÒÑ´´½¨ 1 ÐС£
SQL> select * from test;
ID
----------
'

¿ÉÒÔÓÃÁ½¸öµ¥ÒýºÅÀ´±íʾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ