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;

Why functions are used in sql?

975

---

What is bind reference and how can it be created?

1003

---

What is character functions?

1046

---

Is pl sql different from sql?

968

---

What is on delete set null?

1071

---

what are the differences between char and varchar? : Sql dba

1059

---

How to get each name only once from an employee table?

1097

---

Are stored procedures compiled?

900

---

what is the use of set statement in tsql? : Transact sql

994

---

What is data type in sql?

941

---

What is java sql connection?

1031

---

how are mysql timestamps seen to a user? : Sql dba

1117

---

What is dense_rank in sql?

957

---

Is truncate ddl or dml?

976

---

How do I view tables in sql developer?

925

---