September 6, 2008 06:26pm pdt

1. schwertner 564,329
2. sdstuber 535,481
3. angelIII 251,505
4. sujith80 160,881
5. jinesh_ka... 148,880
6. markgeer 119,551
7. sonicefu 100,615
8. DrSQL 100,582
9. johnsone 95,974
10. rolutola 95,915
11. dbmullen 88,130
12. aiklamha 80,153
13. nav_kum_v 71,337
14. sventhan 63,236
15. MikeOM_... 50,689
16. rbrooker 49,506
17. awking00 43,123
18. Dr_Billy 42,485
19. dvz 42,149
20. ee_rlee 42,125
21. joebednarz 38,246
22. Milleniuma... 35,793
23. gatorvip 28,623
24. mohamma... 26,872
25. ajexpert 25,730

1. schwertner 2,681,834
2. markgeer 1,261,144
3. angelIII 1,096,092
4. seazodiac 1,054,253
5. paquicuba 884,702
6. DrSQL 805,278
7. slightwv 783,788
8. sujith80 683,077
9. sdstuber 645,822
10. rbrooker 567,082
11. ram_0218 526,239
12. johnsone 501,816
13. nav_kum_v 426,835
14. andrewst 421,039
15. actonwang 391,037
16. sathyagiri 384,625
17. MohanKN... 351,476
18. jrb1 343,052
19. anand_2... 326,323
20. MikeOM_... 320,204
21. awking00 296,477
22. GGuzdziol 288,895
23. RCorfman 266,355
24. Henka 262,189
25. jinesh_ka... 250,260

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