Hello,
I am new to this forum, and I am a newbit in Oracle, I do have a background in MS Access, VBA, SQL server development and some Oracle backend development work.
I have been giving a task to dynamically create tables through code based on parameters in existing tables.
I will try to keep this short and to the point
The goal is to extract values from existing tables I will give an example of two tables to keep it simple
Table 1
Name: Obj_Type
Columns
obj_type Id obj_type_nm
1 Data_Design_Spec
2 Logical_Data_Model
3 Entity
Table 2
Name: Property
Columns
prpt_id prprt_nm
1 Source
2 Discoverable
3 Required
The parameters and logic for this is to use a where clause where 1 = would return Data_Design Spec as the NEW Table name and extract data from Table 2 and extract 1 = would be the property name in the new table which would be Source from Table 2
This has to be in some type of routine, I cannot manually use CREATE TABLE statement this has to be done in a SQL statement, also this routine will generate new tables based on values from EXISTING to inlcude data types and attributes. I will GLADLY pay someone through pay pal for the results or who can help me with this....thanks so much
Nana