Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 4 Answers
- 7290 Views
- Thermotech, I also Faced
- E-Mail Answers
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 can we view last record added to a table?
How to establish administrator authentication to the server?
What is an oracle wallet?
Explain the difference between sap and oracle?
What is a tns file?
Explain the function of optimizer in oracle?
How to define a record variable to store a table row?
What is a read write transaction in oracle?
What is clustered table in Oracle?
Explain the use of compress option in exp command.
What do you understand by a database object?
How to create an oracle database?
How to lock and unlock a user account in oracle?
What is the difference between hot backup and cold backup in oracle?
How do you store pictures in a database?
