Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

bulk table creation using union

raj2k8mcaMar 19 2020 — edited Mar 20 2020

Hi Experts,

    please provide me  select query to create an table output like this?

 

Table_namecolumn_name
create tableREGIONS(COUNTRY_ID
COUNTRY_NAME)
create tableCOUNTRIES(REGION_ID
LOCATION_ID
STREET_ADDRESS)
create tableLOCATIONS(POSTAL_CODE
CITY
STATE_PROVINCE
COUNTRY_ID
REGION_ID
REGION_NAME
create tableDEPARTMENTS(DEPARTMENT_ID
DEPARTMENT_NAME
MANAGER_ID
LOCATION_ID
create tableEMPLOYEES(EMPLOYEE_ID
EMPLOYEE_ID
START_DATE
END_DATE)

Comments

Post Details

Added on Mar 19 2020
3 comments
163 views