OraFAQ Forum: SQL & PL/SQL » How to fetch data from multiple table based on a input date

Home » SQL & PL/SQL » SQL & PL/SQL » How to fetch data from multiple table based on a input date (Oracle 11g)

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

How to fetch data from multiple table based on a input date [message #646079]

Sat, 19 December 2015 04:01

suvijyo
Messages: 1
Registered: June 2009
Location: Hyderabad

Junior Member

Transaction data was stored in few backup tables and in running table. how to fetch the data from all the tables that satisfies the given date range. The date range my fall in more than one table.

[Updated on: Sat, 19 December 2015 04:05]

Report message to a moderator

Re: How to fetch data from multiple table based on a input date [message #646080 is a reply to message #646079]

Sat, 19 December 2015 04:13

John Watson
Messages: 9002
Registered: January 2010
Location: Global Village

Senior Member

Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

For a question like this, you need to provide the descriptions of the tables, and show what SQL you have tried so far. Give examples of what the data looks like, and what the query result should be be.

Report message to a moderator

Re: How to fetch data from multiple table based on a input date [message #646087 is a reply to message #646079]

Sat, 19 December 2015 04:54

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

UNION ALL is the idea that comes.

Report message to a moderator

Re: How to fetch data from multiple table based on a input date [message #646122 is a reply to message #646087]

Sun, 20 December 2015 05:10

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Alternatively (where this "alternative" is based on Michel's suggestion), you could create a VIEW (which would utilize UNION ALL) so you'd - finally - write somewhat simpler query to fetch data you're interested in.

Report message to a moderator

Previous Topic:	Kind help with a pl sql for the below link I had posted
Next Topic:	dbms_ldap.simple_bind_s doesn't work with PW containing "!"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 25 13:05:01 CDT 2026