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
3679 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

What is oracle rownum?

1016

what are the advantages of running a database in archive log mode?

2253

How to rename an index?

1122

What is oracle open database communication (odbc)?

1082

What is sequence?

1136

Explain the use of log option in exp command.

1183

What is proxy method?

1021

How data locks are respected in oracle?

1109

Whether any commands are used for months calculation? If so, what are they?

1137

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5677

What is the usage of save points in oracle database?

1011

How to connect to a local oracle 10g xe server?

1032

what are bitmap indexes? How does they work?

2302

What is a system tablespace and when it is created?

1015

What is tns service name?

1177