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.

What is the difference between truncate & delete command?

1236

---

How to create a new tablespace in oracle?

1035

---

What is oracle instant client?

1070

---

How to upsert (update or insert into a table)?

1044

---

What are the original export and import utilities?

1261

---

what is dynamic SGA and static SGA

4492

---

Can you assign multiple query result rows to a variable?

1039

---

What is rowid and rownum in oracle?

1070

---

Please explain drop constraint oracle?

1160

---

How view is different from a table?

1089

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2038

---

How to create a temporary table in oracle?

1335

---

What would you do with an in-doubt distributed transaction?

2049

---

What is the difference between hot backup and cold backup in oracle?

1078

---

What the is the diff between local index and global index. give some example.

1685

---