[color=green]
1. 打开PL/SQL和excel
2. 打开PL/SQL的SQL window,方式是:File--New--SQL window
3. select * from table for update; 写你需要导入的表sql。
4. 如图所示点击锁
[img]http://dl2.iteye.com/upload/attachment/0107/8089/b48e749e-4abd-3bdb-959c-229cc9f15299.png[/img]
5. 如图所示,复制excel数据
[img]http://dl2.iteye.com/upload/attachment/0107/8096/4b2b6e96-1c39-327c-be3c-671d8523949a.png[/img]
6. 如图所示复制
[img]http://dl2.iteye.com/upload/attachment/0107/8098/6a81345e-7fe5-318b-add4-8e0b5699e227.png[/img]
[/color]
1. 打开PL/SQL和excel
2. 打开PL/SQL的SQL window,方式是:File--New--SQL window
3. select * from table for update; 写你需要导入的表sql。
4. 如图所示点击锁
[img]http://dl2.iteye.com/upload/attachment/0107/8089/b48e749e-4abd-3bdb-959c-229cc9f15299.png[/img]
5. 如图所示,复制excel数据
[img]http://dl2.iteye.com/upload/attachment/0107/8096/4b2b6e96-1c39-327c-be3c-671d8523949a.png[/img]
6. 如图所示复制
[img]http://dl2.iteye.com/upload/attachment/0107/8098/6a81345e-7fe5-318b-add4-8e0b5699e227.png[/img]
[/color]