Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

RETRIVE RECORDS FROM 2 FIELDS.

former_member147217
Participant
0 Kudos
94

Hello everyone i have n issue regarding data dictionary objects. I want to know that i have created 2 tables and inserted values in it .Now i have created a new table and i want the same fields that r there in the 2 tables along with their records . Is that possible.

1 ACCEPTED SOLUTION

FredericGirod
Active Contributor
0 Kudos
71

Hi,

no, you can't use the option of the oracle database, you have to code yourself in all the program that insert data into the two first tables.

regards

Fred

5 REPLIES 5

FredericGirod
Active Contributor
0 Kudos
72

Hi,

no, you can't use the option of the oracle database, you have to code yourself in all the program that insert data into the two first tables.

regards

Fred

former_member188827
Active Contributor
0 Kudos
71

Why dont you create a view on the two table if a relation exists between the two tables?

Regards

0 Kudos
71

But will this view help me to extract records from 2 fields of 2 tables or should i use the concept of clusting or pooling the 2 tables..

0 Kudos
71

You will be able to extract data from view. Define a database view on the two tables

Regards

Former Member
0 Kudos
71

Hi,

You can create a Database view on your tow tables...there is a join condition which you need to paas while you create a view...

Thanks,

Prarthan Shah