Skip to Main Content

Integration

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!

Table creation in select statement

raj2k8mcaMar 19 2020

Hi Experts,

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

 

Table_namecolumn_name
create table(REGIONSCOUNTRY_ID
COUNTRY_NAME)
create table(COUNTRIESREGION_ID
LOCATION_ID
STREET_ADDRESS)
create table(LOCATIONSPOSTAL_CODE
CITY
STATE_PROVINCE
COUNTRY_ID
REGION_ID
REGION_NAME)
create table(DEPARTMENTSDEPARTMENT_ID
DEPARTMENT_NAME
MANAGER_ID
LOCATION_ID)
create table(EMPLOYEESEMPLOYEE_ID
EMPLOYEE_ID
START_DATE
END_DATE)
Comments
Post Details
Added on Mar 19 2020
0 comments
178 views