adding new column in TABLE using sql

[anggwaponi]

---

hi all

i have follow some tutorial lessons in sql and i arrived in a stage when my curiosity invigorates my enthusiasms to farther hone my skills but not just practicing but also inquiring


in the table i created (which i name PRACTICE_SQL101) ... i want to add a column between an already existing 2-columns


how can i possibly do it [i want it to be between the column City and Country to be names as Zip Code] ... what sort of commands or syntax in sql will i use then?

likewise, i want the Zip Code to accept only numbers only


the header of my table looks like this:


P_Id LName FName Address City Country


thanks a lot of any valuable suggestions


cheers!

[demonyito]

I am not sure if pwede mu add in between existing columns..
maypa i modify nalng ang column to the new one then add it again

[digitalsuperman]

recreate the table..

[Tin_Tin]

recreate the table..

mao ni pinakadali nga solution...

[ChaosOrb]

try using the ALTER TABLE command

Spoiler: try this 

ALTER TABLE <table name> ADD <column name> <data type>(length) AFTER <column name>;

[dlanyer77]

hi all

i have follow some tutorial lessons in sql and i arrived in a stage when my curiosity invigorates my enthusiasms to farther hone my skills but not just practicing but also inquiring


in the table i created (which i name PRACTICE_SQL101) ... i want to add a column between an already existing 2-columns


how can i possibly do it [i want it to be between the column City and Country to be names as Zip Code] ... what sort of commands or syntax in sql will i use then?

likewise, i want the Zip Code to accept only numbers only


the header of my table looks like this:


P_Id LName FName Address City Country


thanks a lot of any valuable suggestions


cheers!

--RECREATE THE TABLE and here's the simple script that might help you.

drop table PRACTICE_SQL101;

create table PRACTICE_SQL101
(
P_ID NUMBER(10) NOT NULL,
LNAME VARCHAR2(15),
FNAME VARCHAR2(15),
CITY VARCHAR2(10),
ZIP_CODE NUMBER(10),
COUNTRY VARCHAR2(10)
);

[weblizzer]

you can simply alter table then column name after column name

[ChaosOrb]

hay naku, gusto jud ug pahungit sa solutions oi, naay ALTER TABLE command, mag.recreate pa jud sa TABLE. Basa pud intawn mo ug manual oi.

[moz_k2]

^^
hehehe
kalma lang gud, nahan na sila ug lisod.
Ok na ang ALTER kay wla ka kabalo if naa nba data ang table
And considering also the foreign key references.

[dlanyer77]

hay naku, gusto jud ug pahungit sa solutions oi, naay ALTER TABLE command, mag.recreate pa jud sa TABLE. Basa pud intawn mo ug manual oi.

i think we all know DDL and how to use DDL but the thread starter wants to know any work around and please read the post clearly. if you think we are not reading, you're definitely wrong, i even spend my whole life for my career and this made me very profitable. i hope i made myself very very clear.