Results 1 to 4 of 4

Thread: Alter Table

  1. #1
    Join Date
    Aug 2003
    Location
    Vicenza(I)
    Posts
    21

    Red face Unanswered: Alter Table

    Hello I have another problem.
    I write this line of code:
    alter table film modify casting personaggi varchar2(500)
    but when I execute the result is
    Error: ORA-01735: invalid ALTER TABLE option
    what's the problem??
    Thank you Elisa

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Question table stucture

    Hello,

    can I see the table structure ?

    Best regards
    Manfred Peter
    Alligator Company Software GmbH
    http://www.alligatorsql.com

  3. #3
    Join Date
    Aug 2003
    Location
    Vicenza(I)
    Posts
    21

    Re: table stucture

    the structure of the table is:

    CREATE TABLE Film
    (IdFilm number(10) PRIMARY KEY,
    Titolo VARCHAR2(20) NOT NULL,
    Regista VARCHAR2(20) NOT NULL,
    Casting VARCHAR2(500) NOT NULL,
    Nazione VARCHAR2(20) NOT NULL,
    Durata NUMBER(3) NOT NULL,
    Genere VARCHAR2(10) NOT NULL,
    Trama VARCHAR2(500) NOT NULL,
    Novità VARCHAR2(10) NOT NULL,
    Locandina VARCHAR2(20) NOT NULL,
    Note VARCHAR2(100) NOT NULL,
    anno number(4))
    Thank you, Elisa

  4. #4
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    44

    Re: table stucture

    If you want to rename a column and you are on Oracle 9i use:

    ALTER TABLE film RENAME COLUMN casting TO personaggi;

    On previous versions of Oracle you have to drop old and create new column.

    Hope it helps,
    Jacek

    Originally posted by trilly
    the structure of the table is:

    CREATE TABLE Film
    (IdFilm number(10) PRIMARY KEY,
    Titolo VARCHAR2(20) NOT NULL,
    Regista VARCHAR2(20) NOT NULL,
    Casting VARCHAR2(500) NOT NULL,
    Nazione VARCHAR2(20) NOT NULL,
    Durata NUMBER(3) NOT NULL,
    Genere VARCHAR2(10) NOT NULL,
    Trama VARCHAR2(500) NOT NULL,
    Novità VARCHAR2(10) NOT NULL,
    Locandina VARCHAR2(20) NOT NULL,
    Note VARCHAR2(100) NOT NULL,
    anno number(4))
    Thank you, Elisa

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •