ÇëÎÊΪʲô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
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
±í¼Ç¼
======================================
name date score
Fei Zhang 1 100
Fei Zhang  ......
Ôõô½«·ûºÅµ¥ÒýºÅ²åÈëORACLEÊý¾Ý¿âµÄ±íÖÐÈ¥°¡£¿
лл¸÷λ.
SQL code:
SQL> insert into test values('''');
ÒÑ´´½¨ 1 ÐС£
SQL> select * from test;
ID
----------
'
¿ÉÒÔÓÃÁ½¸öµ¥ÒýºÅÀ´±íʾ ......