0 Replies Latest reply on Mar 19, 2020 3:43 PM by raj2k8mca

    Table creation in select statement

    raj2k8mca

      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)