![]() ![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |