Answer Posted / s m nadeem

Declare
type stars is table of varchar2(10);
v_star stars;
v_str varchar2(10);

Begin
select lpad('*', rownum, '*')
bulk collect
into v_star
from tab_star
where rownum < 6;

for i in 1 .. v_star.count loop
v_str := v_star(i);
dbms_output.put_line(v_str);
End loop;
End;

Where do we use pl sql?

982

---

What are the triggers associated with image items?

1030

---

How to avoid using cursors?

1098

---

What is cursor explain with example?

964

---

How do I filter in sql profiler?

985

---

define data blocks ? : Sql dba

966

---

How do you use collections in procedure to return the resultset?

2228

---

what are the advantages of mysql in comparison to oracle? : Sql dba

987

---

What are types of exception?

904

---

What is the use of procedures?

963

---

What does the file extension accdb stand for?

956

---

What are tuples in sql?

1114

---

tell us something about heap tables. : Sql dba

1076

---

Which constraints we can use while creating database in sql?

1056

---

What are the types of subqueries?

1047

---