hi u can use DUP_VAL_ON_INDEX exception SQL> create table test(id

t1
col1 col2
nishi 5000
lucky 6700
akash 7000
i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

Question Posted / ravi gali

2 Answers
3596 Views
MasterCard, I also Faced
E-Mail Answers

Answer Posted / ravi gali

hi u can use DUP_VAL_ON_INDEX exception

SQL> create table test(id number primary key);

Table created.

SQL> set serverout on

SQL>

begin

insert into test values(1);

exception

when DUP_VAL_ON_INDEX then

raise_application_error('duplicate value entered on the row ');

when others then

dbms_output.put_line('if u entered wrong data');

end;

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to best split csv strings in oracle 9i?

1041

What is dynamic proxy?

1005

Explain the use of grant option in imp command.

1026

How to pass a parameter to a cursor in oracle?

1178

Explain the different normalization forms?

1094

How to end the current transaction in oracle?

1030

What is private procedure oracle?

1009

How to create tables for odbc connection testing?

1117

When do we use group by clause in a sql query?

1035

How to create a new table in your schema?

1081

what is the difference between data migration and production migration.

2346

How do I spool in oracle?

1004

What is data type in oracle?

1123

How to update values in a table in oracle?

1026

Explain the use of Merge statement in oracle 11g

1027