OraFAQ Forum: SQL & PL/SQL » Combining 3 queries into 1

Home » SQL & PL/SQL » SQL & PL/SQL » Combining 3 queries into 1 (Oracle11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Combining 3 queries into 1 [message #676357]

Wed, 05 June 2019 01:31

ssyr
Messages: 65
Registered: January 2017

Member

Hello all,

I have 3 queries deleted, accepted, changed rows queries.
Now I have to combine all 3 queries into 1 .I am able to combine 2 queries (deleted and accepted) but when tried to combine changed query with other2 I am getting error.

Can anyone suggest me how can I combine these 3 queries.

Please see the attached file for all queries.

Attachment: Query.sql
(Size: 4.38KB, Downloaded 1771 times)

Report message to a moderator

[Message index]

		Combining 3 queries into 1 By: ssyr on Wed, 05 June 2019 01:31
		Re: Combining 3 queries into 1 By: John Watson on Wed, 05 June 2019 01:48
		Re: Combining 3 queries into 1 By: ssyr on Wed, 05 June 2019 01:59
		Re: Combining 3 queries into 1 By: John Watson on Wed, 05 June 2019 02:26
		Re: Combining 3 queries into 1 By: cookiemonster on Wed, 05 June 2019 03:15
		Re: Combining 3 queries into 1 By: Bill B on Wed, 05 June 2019 11:15

Previous Topic:	Approximate 50MB files per day to be saved in Oracle Database
Next Topic:	PLS-00306: wrong number or types of arguments in call to 'FOPEN' (CM merged 2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 05:18:43 CDT 2024