October 7, 2008 07:56pm pdt

1. schwertner 723,919
2. sdstuber 634,594
3. angelIII 292,002
4. sujith80 190,324
5. jinesh_ka... 157,224
6. markgeer 139,349
7. DrSQL 112,054
8. sonicefu 111,287
9. rolutola 107,615
10. johnsone 105,710
11. dbmullen 97,466
12. sventhan 92,471
13. nav_kum_v 86,553
14. aiklamha 83,985
15. MikeOM_... 59,061
16. shajukg 58,542
17. rbrooker 58,002
18. dvz 56,361
19. Dr_Billy 49,135
20. awking00 47,567
21. joebednarz 45,690
22. ee_rlee 42,297
23. Milleniuma... 38,293
24. mohamma... 37,914
25. gatorvip 32,146

1. schwertner 2,840,424
2. markgeer 1,280,942
3. angelIII 1,136,589
4. seazodiac 1,054,253
5. paquicuba 896,141
6. DrSQL 816,750
7. slightwv 796,996
8. sdstuber 744,935
9. sujith80 712,520
10. rbrooker 575,578
11. ram_0218 526,239
12. johnsone 511,552
13. nav_kum_v 442,051
14. andrewst 421,039
15. actonwang 391,037
16. sathyagiri 387,489
17. MohanKN... 351,476
18. jrb1 343,052
19. anand_2... 329,251
20. MikeOM_... 328,576
21. awking00 300,921
22. GGuzdziol 296,266
23. Henka 267,064
24. RCorfman 266,355
25. jinesh_ka... 258,604

04.22.2008 at 02:27PM PDT, ID: 23344688

	[x] Attachment Details

SQL Loader - can you update or Insert with one control file?

Asked by Winware in Oracle Database

Tags: Oracle, SQL Loader

I'm very new to using SQL Loader but I need to write a control file that will either update an existing record, using the primary key to validate, or insert the record if that primary key doesn't exist. Is that possible with SQL *Loader using one control and CSV fileStart Free Trial

Keywords: SQL Loader - can you update or Inser…

	Title
1	loading CSV file using SQL Loader
2	Setting COMMIT points using SQL*Loa…
3	Dealing with the $ sign in a CSV
4	Sql Loader variable using %
5	SQL Loader
6	USE SQL LOADER to transfer data fro…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

SQL Loader - can you update or Insert with one control file?

Asked by Winware in Oracle Database

Tags: Oracle, SQL Loader

About this solution