Changing the data type of a column in Oracle

oracle oracle10g oracle11g
user1232622 picture user1232622 · Apr 25, 2012 · Viewed 65.7k times · Source

I created the following table

CREATE TABLE PLACE(
  POSTCODE VARCHAR(10) PRIMARY KEY,
  STREET_NAME VARCHAR(10),
  COUNTY VARCHAR(10),
  CITY VARCHAR(10));

I want to change the name, county and city from varchar(10) to varchar(20). How do I do that?

Answer

Justin Cave picture Justin Cave · Apr 25, 2012 
ALTER TABLE place
  MODIFY( street_name VARCHAR2(20),
          county      VARCHAR2(20),
          city        VARCHAR2(20) )

Note that I am also changing the data type from VARCHAR to VARCHAR2 to be more conventional. There is no functional difference at present between the two though the behavior of VARCHAR may change in the future to match the SQL standard.

Related questions

ORA-28000: the account is locked error getting frequently

I am getting the error : ORA-28000: the account is locked Is this a DB Issue? When I unlock user account using the command ALTER USER username ACCOUNT UNLOCK temporarily it will be OK. Then after some time the same account …

Read More
Oracle PL/SQL string compare issue

I have the following Oracle PL/SQL codes that may be rusty from you guys perspective: DECLARE str1 varchar2(4000); str2 varchar2(4000); BEGIN str1:=''; str2:='sdd'; IF(str1<>str2) THEN dbms_output.put_line('The two strings is …

Read More
When should I use 'for update nowait' in cursors?

In which case do we need to use for update nowait in cursors.

Read More