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 meant by temporal data?

904

---

What does inner join mean?

1060

---

what is a trigger in mysql? : Sql dba

1067

---

What are the various levels of constraints?

1059

---

Can a key be both primary and foreign?

943

---

How can a pl sql block be executed?

888

---

What jobs use sql?

925

---

What does seeding a database mean?

890

---

how to use case expression? : Sql dba

957

---

How do I view an execution plan in sql?

922

---

What are the different sql languages?

984

---

how do you tune the slow running queries in oracle db , explain the methodology

2058

---

How do I remove duplicates in two columns?

974

---

Is left join and outer join same?

1001

---

What do you mean by dbms? What are its different types?

949

---