sql help

[malini0905]

I have SQL statement select * from tableA,but to this SQL statement i need to add the functionality of 3 functions.

Function1

Create or Replace Function1()
RETURM object1
IS

CURSOR c1
IS

SELECT * from tableA where (c1='A' or c2='Y');

---

---
RETURN object1;

END Function1


Function2

Create or Replace Function2()
RETURN object2

IS

CURSOR c2
IS

SELECT * from tableA where c2='Y';

---

---
RETURN object2

END Function2


Function3

Create or Replace Function3()

IS

CURSOR c3
IS

object1:=Function1();
object2:=Function2();

If object1.c1=object2.c1 then
return object1
---

---

END Function3

can any one help me with this.


Thanks