SQL help needed

[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

 

[SQLDenis]

>>Create or Replace

is this Oracle? This is a SQL Server (Microsoft) forum

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[malini0905]

yes,but this question does not depend on the database.
I need the logic for the SQL statement.

can you please help me.Thanks in advance.

 

[SQLBill]

Yes it does depend on the database. ORACLE uses a different SQL than Microsoft SQL Server (what this forum is for) does.

You need to post your question in one of the Oracle forums.

-SQLBill

Posting advice: FAQ481-4875