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;

how tsql statements can be written and submitted to the database engine? : Transact sql

1000

---

What is t sql used for?

1018

---

What are types of exception?

922

---

What does select * from mean in sql?

3247

---

What are aggregate functions in sql?

1166

---

what is a cursor? : Sql dba

1029

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1218

---

what is csv? : Sql dba

1001

---

What is scope and visibility in PL/SQL?

1210

---

what is a view? : Sql dba

1104

---

Does inner join remove duplicates?

945

---

What are the methods of filing?

935

---

what is the difference between cluster and non cluster index? : Sql dba

1034

---

Why we use sql profiler?

963

---

What are the different schemas objects that can be created using pl/sql?

1037

---