I’m not sure, how we can do this in a direct way. But we can do by following way.
Create table test_ram(userID NUMBER
, firstName VARCHAR2(25)
, lastName VARCHAR2(25));
Now we decide to include a middle_name column
Example:
CREATE TABLE temp_ram AS (
SELECT * FROM test_ram);
DROP TABLE test_ram;
CREATE TABLE test_ram (
userID NUMBER
, firstName VARCAHR2(25)
, middlename VARCHAR2(1)
, lastName VARCHAR2(25));
INSERT INTO test_ram(userID, firstName, lastName)
(SELECT userID
, firstName
, lastName
FROM temp_ram);
DROP TABLE temp_ram;
I’m not saying this is the only way. This is one of the way to do, if anybody have better solns please post it.
Happy Coding
Ram