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

How to define an anonymous block?

1127

---

How to work with data objects interactively?

957

---

What is truncate oracle?

959

---

Explain a synonym?

1007

---

How to view the data files in the current database?

1079

---

What is oracle and what are its different editions?

1054

---

What is the recommended interval at which to run statspack snapshots, and why?

2897

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1925

---

How to end the current transaction in oracle?

1012

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2295

---

What is data file?

1082

---

How to call a stored function with parameters?

1010

---

What is oracle server autotrace in oracle?

1141

---

What is an oracle and why it is used?

1127

---

What is an oracle database?

1018

---