Table 1 describes the Oracle keywords and features supported by DSC.

• The Version column lists the earliest version that supports a keyword or feature.
• The Remarks column describes how to configure the migration of a keyword or feature.

  Table 1 Oracle keywords and features supported by DSC

  Section	Object and Keyword/Feature		Version	Remarks
  Schema Objects	Table	CREATE TABLE	V100R003C10	-
  		ALTER TABLE	V100R003C10	-
  		PRIMARY KEY	18.2.0	-
  		INDEX	18.2.0	-
  		PARTITION	18.2.0, 6.5.1	Configured by setting RemoveHashPartition, RemoveHashSubPartition, RemoveListPartition, RemoveListSubPartition, and RemoveRangeSubPartition
  		SEGMENT CREATION	18.2.0, 6.5.1,8.0.0	-
  		STORAGE	18.2.0	-
  		STORE	18.2.0	-
  		PCTINCREASE	6.5.2	-
  		FOREIGN KEY	V100R003C20	Configured by setting foreignKeyHandler
  		LONG data type	6.5.1	-
  	Temporary table		18.1.0	-
  	Global temporary tables		18.2.0	-
  	Index	Index	18.2.0	-
  	View		18.2.0, 6.5.1	-
  	Sequence	Sequence	18.2.0, 6.5.1	Configured by setting MigSupportSequence
  		Sequence with NOCACHE	v1r3	-
  		CREATE SEQUENCE with schema name	18.2.0,6.5.1	-
  		CREATE SEQUENCE with default values	18.2.0,6.5.1	-
  		NEXTVAL	18.2.0,6.5.1	Configured by custom DB scripts
  	PURGE		18.1.0, 18.2.0, 6.5.1	-
  	Keyword	Gauss keywords (NAME, VERSION, LABEL, POSITION)	18.2.0	-
  		NAME and LIMIT	18.2.0	-
  		OWNER	18.2.0	-
  		KEY	18.2.0	-
  DML	SELECT	1	V100R003C30	-
  		2	V100R003C30	-
  		3	18.0.0	-
  		4	18.2.0	-
  	INSERT	1	V100R003C10	-
  		2	V100R003C10	-
  		3	V100R003C30	-
  	MERGE		V100R003C10	-
  Pseudo Columns	ROWID		V100R003C10	-
  	ROWNUM		V100R003C10	-
  Outer Join			V100R003C10	-
  OUTER QUERY (+)			18.2.0	-
  CONNECT BY			18.2.0	-
  System Functions	Date functions	ADD_MONTHS	V100R003C10	Configured by custom functions in the MIG_ORA_EXT schema
  		DATE_TRUNC	V100R003C10	-
  		LAST_DAY	V100R003C20	Configured by custom functions in the MIG_ORA_EXT schema
  		MONTHS_BETWEEN	V100R003C20	Configured by custom functions in the MIG_ORA_EXT schema
  		SYSTIMESTAMP	V100R003C10	-
  		TO_DATE with SYYYY in year format	8.0.0	-
  		TO_DATE with third parameter	8.0.0	-
  	LOB functions	DBMS_LOB.APPEND	V100R003C20	-
  		DBMS_LOB.COMPARE	V100R003C20	Configured by custom functions in the MIG_ORA_EXT schema
  		DBMS_LOB.CREATETEMPORARY	V100R003C20	-
  		DBMS_LOB.FREETEMPORARY	V100R003C20	-
  		DBMS_LOB.INSTR	V100R003C10	-
  		DBMS_LOB.SUBSTR	V100R003C10	-
  	String functions	LISTAGG	V100R003C10	-
  		STRAGG	V100R003C10	-
  		WM_CONCAT	V100R003C10	-
  		NVL2 and REPLACE	V100R003C10	-
  		QUOTE	V100R003C10	-
  	Analytical functions	RATIO_TO_REPORT	V100R003C20	-
  	Regular expression functions	REGEXP_INSTR	V100R003C30	Configured by custom functions in the MIG_ORA_EXT schema
  		REGEXP_SUBSTR	V100R003C30	Configured by custom functions in the MIG_ORA_EXT schema
  		REGEXP_REPLACE	V100R003C30	Configured by custom functions in the MIG_ORA_EXT schema
  		LISTAGG/regexp_replace/regexp_instr	18.2.0	-
  	Other functions	Type casting function	V100R003C10	-
  		Use environment function	V100R003C30	Configured by custom functions in the MIG_ORA_EXT schema
  PL/SQL	EDITIONABLE		18.2.0	-
  	Variable Assignment		V100R003C10	-
  	END		18.1.0	-
  	EXCEPTION Handling		V100R003C10	Configured by setting exceptionHandler
  	Subtransaction Handling		V100R003C10	Configured by setting TxHandler
  	STRING		V100R003C10	-
  	LONG		V100R003C20	-
  	RESULT_CACHE		V100R003C10	-
  	Relational Operators with Spaces		V100R003C10	-
  	Substitution Variables		V100R003C10	-
  	PARALLEL_ENABLE		V100R003C20	-
  	TRUNCATE TABLE		V100R003C30	-
  	ALTER SESSION		V100R003C30	-
  	AUTONOMOUS		18.2.0	-
  PL/SQL Collections (Using User-Defined Types)	UDT TABLE		V100R003C10	-
  	UDT VArray		V100R003C10	-
  	UDT COUNT		V100R003C10	-
  	UDT RECORD		V100R003C10	-
  	Enhancement of user-defined types		V100R003C20	-
  	EXTEND		18.2.0	-
  	RECORD		18.2.0	-
  PL/SQL Packages	Package		V100R003C20	-
  	Package variable		V100R003C30	Configured by custom functions in the MIG_ORA_EXT schema
  	PACKAGE1.FUNC1		18.2.0	-
  	REF CURSOR		V100R003C20	-
  	Creating a Schema for Package		18.2.0	-