Table Has C1 And C2 Column If Exits any record in c1 then
Update c2 record Otherwise insert new record in the C1 And
C2 (Using Procedure)
Answer Posted / dinesh a.
select * from x;
C1 C2
----- ----------
1
2
3
4
5
6
7
8
9
10
1 create or replace procedure updt_x is
2 cnt number(4);
3 begin
4 select count(1) into cnt from x where c1 is not null;
5 if cnt > 0 then
6 update x
7 set c2=10;
8 else
9 insert into x
10 values(1,2);
11 end if;
12 commit;
13* end;
SQL> execute updt_x;
PL/SQL procedure successfully completed.
SQL> select * from x;
C1 C2
---------- ----------
1 10
2 10
3 10
4 10
5 10
6 10
7 10
8 10
9 10
10 10
10 rows selected.
SQL> delete from x;
10 rows deleted.
SQL> commit;
PL/SQL procedure successfully completed.
SQL> select * from x;
C1 C2
---------- ----------
1 2
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to write text literals in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Is oracle an open source?
How to execute the package in oracle?
How can I create database in oracle?
What are the differences between char and nchar in oracle?
What is a user account in oracle?
Query to retrieve record for a many to many relationship ?
How to write a query with a left outer join in oracle?
What is the scope of a local variable?
How to list all user accounts in oracle?
What are the numeric comparison operations?
Explain database link?
How to define a specific record type?
What is Virtual Private Database in Oracle?