SQL & PL/SQL :: Use Value Of One Column In Other In Same Table

I have two table country and state.Columns are given below

SQL> DESC Country

Name Null? Type
----------------- -------- --------------
PRIMARY_KEY NOT NULL NUMBER
DISPLAY_ORDER NOT NULL NUMBER
NAME NOT NULL VARCHAR2(50)
TREE_POSITION NOT NULL VARCHAR2(250)
PARENT_ID NUMBER

SQL> desc state
Name Null? Type
----------------- -------- -------------------------
PRIMARY_KEY NOT NULL NUMBER
DISPLAY_ORDER NOT NULL NUMBER
NAME NOT NULL VARCHAR2(50 CHAR)
VALUE NOT NULL VARCHAR2(50 CHAR)
TREE_POSITION NOT NULL VARCHAR2(250 CHAR)
PARENT_ID NUMBER

Now I have to insert the values in the state table taking from the country table.

EXAMPLE :

INSERT INTO STATE (PRIMARY_KEY, DISPLAY_ORDER, NAME, VALUE, PARENT_ID, TREE_POSITION) VALUES (251, 1, 'Alaska', 'AK', 233, 'STAT_USUS_AKAK');

but here the tree position is static it can be anything at the client side so I want to make it dynamic. So to make dynamic what I have used is mentioned below:

INSERT INTO STATE
(PRIMARY_KEY,DISPLAY_ORDER,NAME, VALUE,
PARENT_ID,
TREE_POSITION)
VALUES

[code].....

Now I want that Quote: select tree_position from L_STATE_ITEM where name ='United States')||'_ALAL' which i have used in the state table to put value in the tree_position, I want to make the other half part after the concatenation operator "_ALAL" also dynamic.

So I was just wondering If I can pic that value from the "VALUE COLUMN" of the same table.