pl/sql可将excel的数据直接复制保存到数据库中

使用select * from ams_town for update语句执行

 

 

# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLE10G_192.168.100.56 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.56)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = ORACLE10g)
      (SERVER = DEDICATED)
    )
  )

ORACLE10G =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.56)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracle10g)
    )
  )

ORACLE227 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.227)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

LPEAC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.235)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = lpeac)
    )
  )

ORC31 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracle10g)
    )
  )