以下の例では、UPPERを使って値を格納します。
INSERT INTO names SELECT UPPER(last_name),UPPER(first_name) FROM newnames;
または
USING (last_name CHAR(20),first_name CHAR(20)) INSERT INTO names (UPPER(:last_name), UPPER(:first_name));
以下の例では、UPPERを使って値を格納します。
INSERT INTO names SELECT UPPER(last_name),UPPER(first_name) FROM newnames;
または
USING (last_name CHAR(20),first_name CHAR(20)) INSERT INTO names (UPPER(:last_name), UPPER(:first_name));