CREATE TABLE DSS.TAB1
(
PROFILE_TYPE VARCHAR2(10 BYTE) NOT NULL,
PROFILE VARCHAR2(12 BYTE) NOT NULL,
DESCRIPTION VARCHAR2(60 BYTE),
ACTIVE VARCHAR2(1 BYTE) NOT NULL
)
SET DEFINE OFF;
Insert into DSS.TAB1
(PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE)
Values
('CONFIGATR', 'AD', ' Config Attr AD', 'Y');
Insert into DSS.TAB1
(PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE)
Values
('CONFIGATR', 'EO', ' Config Attr EO', 'Y');
Insert into DSS.TAB1
(PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE)
Values
('CONFIGATR', 'MOD', ' Config Attr MOD', 'Y');
Insert into DSS.TAB1
(PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE)
Values
('CONFIGATR', 'REV', ' Config Attr REV', 'Y');
Insert into DSS.TAB1
(PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE)
Values
('CONFIGATR', 'SB', ' Config Attr SB', 'Y');
Insert into DSS.TAB1
(PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE)
Values
('CONFIGATR', 'SIL', ' Config Attr SIL', 'Y');
COMMIT;
CREATE TABLE DSS.TAB2
(
PROFILE_TYPE VARCHAR2(10 BYTE) NOT NULL,
PROFILE VARCHAR2(12 BYTE) NOT NULL,
DESCRIPTION VARCHAR2(60 BYTE),
ACTIVE VARCHAR2(1 BYTE) NOT NULL,
PROFILE_ATTRIBUTE VARCHAR2(60 BYTE)
)
SET DEFINE OFF;
Insert into DSS.TAB2
(PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE, PROFILE_ATTRIBUTE)
Values
('CONFIGVAL', '100', 'Config Val M for AD', 'Y', 'AD');
Insert into DSS.TAB2
(PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE, PROFILE_ATTRIBUTE)
Values
('CONFIGVAL', '101', 'Config Val M for AD', 'Y', 'AD');
Insert into DSS.TAB2
(PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE, PROFILE_ATTRIBUTE)
Values
('CONFIGVAL', '102', 'Config Val M for AD', 'Y', 'AD');
Insert into DSS.TAB2
(PROFILE_TYPE, PROFILE, DESCRIPTION, ACTIVE, PROFILE_ATTRIBUTE)
Values
('CONFIGVAL', '200', 'Config Val O for EO', 'Y', 'EO');
COMMIT;
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.