The substring virtual column allows you to access either part of a column or a complete table record. For a substring virtual, you will need to specify the column from which you want to substring. A substring virtual can be based on:
a real column in the table
another virtual column in the table
the complete record contents of the table (indicated by *RECORD).