-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|