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
- 3552 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 |
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
What happens to the current transaction if the session is killed?
What is index in Oracle?
What would you use to improve performance on an insert statement that places millions of rows into that table?
where we have to use ON clause and where we have to use USING clause in JOINS
How do you rate yourself in oracle and sql server ?
What is SQL access advisor in Oracle?
What do you understand by database schema and what does it hold?
List the parts of a database trigger.
What are the different types of database objects?
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
How to resolve name conflicts between variables and columns?
Oracle General 
