We would like to create a view on a table by concatenating the columns in the table as single column in the view.
Table T1 has the below structure:
Col1 CHAR (3) Col2 CHAR (4) Col3 CHAR (5) Col4 CHAR (3) Col5 CHAR (2)
We would like to create a view v1 on Table T1 whose structure is as follows:
where colx is defined as col1 ]] col2 ]] col3 ]] col4 ]] col5
in the Create View DDL statement.
So the columns in T1 are concatenated to form one column Colx in the view.
This view creation will work only if all columns in the Table T1 are defined as character datatype as given in the above example.
Is there a way to create a view by concatenating all columns from a Table, where the table structure looks as below:
Col1 CHAR (3) Col2 CHAR (4) Col3 CHAR (5) Col4 DECIMAL Col5 CHAR (2)