Basic PL/SQL Syntax

**Table 4** CASE expressions
No.	Oracle	GaussDB
1	simple CASE	Supported.
2	searched CASE	Supported.

**Table 5** Parameters related to variable declaration
No.	Oracle	GaussDB	Difference
1	%TYPE	Supported, with differences.	GaussDB does not support record%type. GaussDB does not support pkg.record%type and schema.pkg.record%type as the input and output parameter types. In GaussDB, Table/View.column.column%type or schema.Table/View.column.column%type cannot be nested with one or more layers as variable types or input/output parameter type. In GaussDB, record.column.column%type and pkg.record.column.column%TYPE cannot be nested with a column type of records at one or more layers as the variable type or input/output parameter type.
2	%ROWTYPE	Supported, with differences.	When GaussDB has multiple CNs, the %ROWTYPE and %TYPE attributes of the temporary table cannot be declared in a stored procedure. The temporary table is valid only in the current session. During compilation, other CNs cannot view the temporary table of the current CN. Therefore, if there are multiple CNs, the system displays a message indicating that the temporary table does not exist. GaussDB does not support view%rowtype and schema.view%rowtype as the input and output parameter types. GaussDB does not support the package.cursor%rowtype as the input and output parameter types.