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 the difference between Union and Union all. Which is faster.

1340

---

What is equi join in sql?

1007

---

Is sql scripting language?

973

---

What are system versioned tables?

965

---

how to shutdown mysql server? : Sql dba

1027

---

What is a procedure in pl sql?

1128

---

how to convert character strings to dates? : Sql dba

982

---

What is function and procedure?

983

---

How do you create a db file?

956

---

What are different functions in sql?

896

---

What is varchar data type in sql?

1010

---

Is a table valued function object?

958

---

what are the different functions in sorting an array? : Sql dba

967

---

Can we call procedure in select statement?

974

---

How to pipe multiline string to isql?

959

---