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;

What is sql analyzer?

1028

---

How to raise user-defined exception with custom sqlerrm ?

1141

---

What is the use of desc in sql?

988

---

What is PL/SQL Records?

1198

---

Can procedure in package be overloaded?

1094

---

How many rows can sqlite handle?

1130

---

Is stored procedure faster than query?

974

---

What do you mean by “trigger” in sql?

1095

---

Can you selectively load only those records that you need? : aql loader

1061

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1446

---

Can we call procedure in select statement?

1069

---

How to write pl sql program in mysql command prompt?

1105

---

What is interval partition?

1066

---

What does closing a cursor do?

1332

---

What are joins in sql?

1051

---