Answer Posted / selvaraj v

In oracle 10g :
---------------->

Step 1 : SQL> CREATE TABLE identity( ID NUMBER);

Step2 : Write a Simple Procedure for to insert values into
table.

DECLARE
i NUMBER;
BEGIN
FOR i IN 1..100 LOOP
INSERT INTO identity VALUES(i);
END LOOP;
END;
/
PL/SQL procedure successfully completed.

Step 3 : SELECT COUNT(*) FROM identity;

COUNT(*)
----------
100


Please check it. Works fine.



PL/SQL procedure successfully completed.

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2370

---

What do you mean by cdb and pdb in oracle 12c?

1062

---

Can you tell me how to add new column in existing views?how?How is possible?

1449

---

How to count groups returned with the group by clause in oracle?

1079

---

How to work with data objects interactively?

989

---

Can we store pictures in the database and if so, how it can be done?

1046

---

what is port in oracle? how is it related to database application.

1949

---

What is object data modeling?

970

---

How many anonymous blocks can be defined?

1187

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2139

---

What is an oracle table?

992

---

Explain database link?

1128

---

How to turn on or off recycle bin for the instance?

1085

---

Query to retrieve record for a many to many relationship ?

2521

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1890

---