Answer Posted / mglbayar

We can use oracle pipelined function

FUNCTION f_serie_arithmetica (p_nr IN NUMBER)
RETURN ARRAY PIPELINED
IS
v_sum NUMBER;
BEGIN
v_sum := 0;
FOR i IN 1 .. p_nr
LOOP
v_sum := v_sum + i;
PIPE ROW (v_sum);
END LOOP;
RETURN;
END;

Usage:
select * from table(f_serie_arithmetica(23));

What is a function in oracle pl sql?

544

---

Explain about various levels of constraint.

525

---

What are aggregate and scalar functions?

527

---

What is a pl/sql block?

595

---

What is sql profiler in oracle?

567

---

---

define data blocks ? : Sql dba

547

---

What is set serveroutput on?

643

---

How to use transactions efficiently : transact sql

546

---

Does sql use python?

563

---

Can we insert in sql function?

550

---

What is oracle sql developer?

605

---

Which software is used for pl sql programming?

521

---

Can we use pl sql in mysql?

519

---

how many triggers are allowed in mysql table? : Sql dba

559

---

how to include numeric values in sql statements? : Sql dba

562

---