Answer / ashutosh

you can use 3 different collections for it...

suppose the table is emp have the following columns
1. empname varchar
2. empid number
3. sal number

declare
type name_typ is table of emp.empname%type;
type id_typ is table of emp.empid%type;
type sal_typ is table of emp.sal%type;
name_tab name_typ;
id_tab id_typ;
sal_tab sal_typ;
begin
name_tab := name_typ('ramit','rohan');
id_tab := id_typ(10,20);
sal_tab := sal_typ(21000,22000);
for all i in name_tab.first .. name_tab.last
insert into emp values(name_tab(i),id_tab(i),sal_tab(i));
end;

Answer / amarnath

in stead of above discription we need to use dynamic sql.

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

What operating systems are supported by oracle sql developer?

1 Answers  

---

What are the indexing methods?

1 Answers  

---

What is the usage of sql functions?

1 Answers  

---

What are stored procedures used for?

1 Answers  

---

Explain the difference between drop and truncate commands in sql?

1 Answers  

---

What is difference between inner join and self join?

1 Answers  

---

Explain alias in sql?

1 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

---

how to create a new table in mysql? : Sql dba

1 Answers  

---

What are pl sql procedures?

1 Answers  

---