Inserting a column from two concatenated columns

[Mindy Haukom]

I want to add a column to my table that includes the data of two concatenated columns (first_name || ' ' || last_name "FULL NAME") and am totally at a loss. Any help?

[Rabbit]

Don't do it. There's no need. You can just calculate the column when you need it.

[parwez1602]

select first_name ||' '|| last_name as FULL_NAME from <Table_NAME>;