Results 1 to 2 of 2

Thread: syntax ??

  1. #1
    Join Date
    Jan 2004
    Posts
    67

    Unanswered: syntax ??

    ALTER TABLE web_investor_cash_flow

    ADD COLUMN (SPOUSE_RETIRE_SAME_YN char(1), School_type_id number, tax_status_is number, profile_yn char(1))

    tells me an error (Invalid identifier)

    I am trying to add 4 columns to the existing table

    Can anyone tell me whats the problem

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    ALTER TABLE <table_name> ADD (
    col1 <data type>.
    col2 <datatype>,
    . .
    . .
    . . );

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

Posting Permissions

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