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 is meant by truncate in sql?

752

---

What is a dynamic query?

762

---

Does access use sql?

750

---

what are different types of keys in sql?

767

---

Can you join views in sql?

719

---

---

What is union, minus and interact commands?

937

---

how to show all tables with 'mysql'? : Sql dba

816

---

What are the possible values that can be stored in a boolean data field?

717

---

What is autocommit sql?

708

---

What is benefit of creating memory optimized table?

703

---

Can we use distinct and group by together?

783

---

what is sp_pkeys? : Transact sql

889

---

Define union, minus, union all, intersect ?

738

---

What is view explain with example?

686

---

How do you create a db file?

710

---