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

Thread: column position

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    column position

    hi friends,

    I thought column positioning is immaterial in oracle tables.
    Why did i get "values too long" with the ff. commands;

    desc emp;

    empno varchar2(10)
    empname varchar2(50)

    desc emp2;

    empname varchar2(50)
    empno varchar2(10)


    sql> insert into emp select * from emp2;
    error: value too large

    sql> insert into emp(empname,empno) select * from emp2;
    100 rows inserted.

    Any comments pls.... did i misunderstood what column positioning
    means? i like column position 69 though
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I don't know what to add ... you seem to have already found out that Oracle won't automagically reorder column names to make that work. It is very bad practice IMHO to code without listing column names, and if you have any kind of a decent development platform it's trivial to do so.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    thanks dear....Its just that i read something about it...that in a
    relational database u can place any columns to any position
    and it does not matter, something like that...

    davey....just one more question, the server time 12:50 am
    I'm curious what country has this time? Our time is 8:50am so we
    are ahead 8 hrs. And we are ahead 7hrs in UK.

    thanks
    Last edited by yxez; 10-25-2006 at 08:59 PM.
    Behind The Success And Failure Of A Man Is A Woman

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