![]() Use the %ROWTYPE attribute to set the data types to the composite data type for a row in a table or view. When creating schema objects such as columns, use the %TYPE attribute to set the data type of the object you are creating or altering, to the data type of a column in a table or view. DECLARE VARIABLE LIKE – You can use the %TYPE and %ROWTYPE attributes to define the data type(s) based on the data type of other objects.Unpivoting is useful for normalizing un-normalized data, such as several columns of similar data that must be joined with other data. Unpivot is a similar operation, but rotates row data into columns. Pivoting rotates column data into rows and aggregates data in a meaningful way for your business needs. PIVOT/UNPIVOT – You can now pivot and unpivot table data using two clauses, PIVOT and UNPIVOT, in the FROM clause of a query to create pivoted- or unpivoted-derived tables. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |