Add a Column in Oracle9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Add a Column in Oracle9i

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    Add a Column in Oracle9i

    Hello all

    I have a table 'QT_Process' already created with 6 cols. now i need to add another Column 'QT_NAME'.


    How do i add this Col to the existing Tabel ?...Any Syntax help will be Great.

    Thanks...appreciate it

    Ron

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    RTFM

    Code:
    e.g.
    
    ALTER TABLE QT_PROCESS
        ADD (QT_NAME VARCHAR2(10) NOT NULL)
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

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


Click Here to Expand Forum to Full Width