DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SQL*plus

Hybrid View

  1. 12-12-2005, 09:57 PM #1
    new dba
    new dba is offline Junior Member
    Join Date
    Dec 2005
    Posts
    7

    SQL*plus

    I am new oracle learner . I inserted a new column into a table . I am trying to insert value into only that column for specific row. Can anybody give me syntax for this.
    Reply With Quote Reply With Quote
  2. 12-13-2005, 05:23 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    If you added a new column and you want to add data to that column, you need to use the update command to edit the rows already there
    Code:
    update xxx set new_column = 'YYY' where
    Reply With Quote Reply With Quote
  3. 12-13-2005, 02:49 PM #3
    new dba
    new dba is offline Junior Member
    Join Date
    Dec 2005
    Posts
    7
    thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width