Michael Maramzin
Member²
PL/SQL Developer Version 6.0.0.840
Code:
-- SQL*Plus --
SQL> conn dryer@m
Enter password: *********
Connected.
SQL> desc fmmg_owners
Name Null? Type
------------------------- -------- ------------
OWNER_ID NOT NULL NUMBER(38)
OKPO NOT NULL VARCHAR2(10)
CUST_OWN NOT NULL CHAR(1)
CUST_ID NUMBER(38)
OWNER_ADD DATE
ZIP VARCHAR2(10)
COUNTRY VARCHAR2(50)
STATE VARCHAR2(50)
REGION VARCHAR2(50)
CITY VARCHAR2(50)
STREET VARCHAR2(50)
BUILDING VARCHAR2(20)
OFFICE VARCHAR2(20)
SQL> conn dryer@f1
Enter password: *********
Connected.
SQL> desc fmmg_owners
Name Null? Type
------------------------- -------- ------------
OWNER_ID NOT NULL NUMBER(38)
OKPO NOT NULL VARCHAR2(10)
CUST_OWN NOT NULL CHAR(1)
CUST_ID NUMBER(38)
ZIP VARCHAR2(10)
COUNTRY VARCHAR2(50)
STATE VARCHAR2(50)
REGION VARCHAR2(50)
CITY VARCHAR2(50)
STREET VARCHAR2(50)
BUILDING VARCHAR2(20)
OFFICE VARCHAR2(20)
OWNER_ADD DATE
-- PL/SQL Developer Compare User Objects output: --
rem Differences between DRYER@M and DRYER@F1, created on 25.08.2004
rem Press Apply button, or run in Command Window or SQL*Plus, connected as DRYER@F1
---------------------------------
-- Changed table fmmg_owners --
---------------------------------
-- Add/modify columns
alter table FMMG_OWNERS rename column STATE to COUNTRY;
alter table FMMG_OWNERS rename column REGION to STATE;
alter table FMMG_OWNERS rename column CITY to REGION;
alter table FMMG_OWNERS rename column STREET to CITY;
alter table FMMG_OWNERS rename column OFFICE to BUILDING;
