RETRIVE RECORDS FROM 2 FIELDS.

[former_member147217]

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.

[FredericGirod]

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]

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

Regards

[former_member147217]

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..

[former_member188827]

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

Regards

[Former Member]

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