Hi Answer to Your question IS create or replace procedure samp(c

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)

Question Posted / ramprasad.s

4 Answers
7418 Views
Thermotech, I also Faced
E-Mail Answers

Answer Posted / ramprasad.s

Hi Answer to Your question
IS
create or replace procedure samp(cname IN sample.ename%type,
cno IN sample.eno%type)
AS
ccount number;
begin
select count(*) INTO ccount from sample;
IF ccount = 0 then
update sample set ename = cname;
else
insert into sample values(cname, cno);
END IF;
END;

Sample Table is
ENAME ENO
100

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how the indexes are stored in the Oracle Database?

2271

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2234

How to write date and time literals in oracle?

1002

What are internal user account in oracle?

1008

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1918

How can windows applications connect to oracle servers?

1057

Can you assign multiple query result rows to a variable?

988

How to create a table index in oracle?

1134

How many types of tables supported by oracle?

1077

how to clone 9i Database on to 10g Database.

2340

Describe the types of sub query?

999

Explain implicit cursor.

1034

When do I need to use a semicolon vs a slash in oracle sql?

1090

How to run create database statement again?

1157

What is archive log in Oracle?

1134