How write the ignore dupkey command in UNIX?

Shell Programming and Scripting
1

I know that in oracle the is a way to write to ignore the dupkey, something like

/*+ ignore_row_on_dupkey_index(tab, index_tab) */

Is there a way to do the same thing but with unix commands? I think there's a way with WHENEVER SQLERROR EXIT SQL.SQLCODE but i'm not sure and i don't know how do it. Thanks

ps: i mean records in the db. Ignore when there are the same record and go on.

2

you can use uniq:

file1

1 2 3 4
1 2 3 4
1 2 3 3
9 9 9 3

## ignore first three columns
$ uniq file1 -f 3
1 2 3 4
1 2 3 3
3

I'm looking for SQL*Plus solution. The insert i'm going to do takes a file. This file has no duplicate rows. The problem is in the oracle. Not in the file. The recors could be duplicated.

4

then this may help (distincts for col1 and col2):

select * from
(
select col1, col2, col3 ,row_number() over (partition by col1, col2 order by null) rn
from table1
) where rn=1;