Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 3682 Views
- MasterCard, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
The best thing would be to create a trigger which checks and not allows duplicate data .
Create or replace trigger trig1
before insert or update on t1
for each row
declare
a number (10);
begin
select count(*) into a from t1 where col2 = :new.col2;
if a >= 1 then
raise_application_error(-20123,'data already present and data will not insert');
elsif a = 0 then
dbms_output.put_line('inserted');
end if;
end;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Explain an exception?
what is data independence exactly? give an example
Explain constraining triggers.
what is the difference between rollback & commit? can a foreign key has null value?
What are the different types of modules in oracle forms?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
difference between oracle8i and oracle9i
What is meant by a deadlock situation?
Explain alias?
does Oracle has only one table space?
How can we find out the current date and time in oracle?
What is DTS and purpose of DTS ?
Oracle General 
