Answer Posted / bijaylaxmi

declare
m number:=5;
n varchar2(30);
begin
for i in 1..m
loop
for j in 1..i
loop
n:=n||'*';
end loop;
dbms_output.put_line(n);
n:=null;
end loop;
end;

What are procedures used for?

529

---

What is data profiling in sql?

518

---

What is over () in sql?

529

---

What is a unique key?

588

---

What does pragma mean?

511

---

---

what are all types of user defined functions? : Sql dba

550

---

Does access use sql?

565

---

Can two tables have same primary key?

531

---

Is pl sql useful?

543

---

what is 'mysqlimport'? : Sql dba

574

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

578

---

What are the types of records?

537

---

Is t sql a programming language?

539

---

Why do we use procedures?

519

---

what is a unique key ? : Sql dba

547

---