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 do you write an index?

527

---

how to convert numeric values to character strings? : Sql dba

569

---

what is unique key constraint? : Sql dba

572

---

What are all ddl commands?

549

---

what is meant by nl2br()? : Sql dba

566

---

---

List the ways to get the count of records in a table?

512

---

How do you write a subquery?

523

---

How do I run a script in sql developer?

496

---

What version is sql?

553

---

Is ms sql is free?

530

---

Is sqlite free?

538

---

How do rank () and dense_rank () differ?

522

---

Is sql easier than java?

527

---

Is sql similar to python?

538

---

How do I view a sql database?

558

---