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 to get @@error and @@rowcount at the same time? : Sql dba

1018

---

What are tables in sql?

1054

---

Can %notfound return null after a fetch?

1051

---

What are the different ways to optimize a sql query?

941

---

What's the difference between a primary key and a clustered index?

984

---

What program will open a mdb file?

958

---

What are the different dml commands in sql?

1166

---

What trigger means?

972

---

what are the performance and scalability characteristics of mysql? : Sql dba

995

---

Why do we need sharding?

982

---

What is use of package in pl sql?

1009

---

Could you please provide oca (oracle 10g) dumps for my certification ?

5148

---

Why truncate is used in sql?

998

---

What are the different types of dbmss?

1009

---

define sql update statement ? : Sql dba

1112

---