Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How insert new field in between?
On 23 Aug 2001, danielcloutier_at_web.de wrote:
> I have quite a problem with one of my tables in my Oracle db. I
> wanted to insert a new field into my table using the ALTER sql
> command. Now, this command appends the desired field at the end
> of the table.
So, when you do a "desc table" you see the new column?
> The last field in this table is of type LONG and somehow, I
> cannot acces the appended field(VARCHAR2(1).
First, why did you use varchar2 for a single character length field? char(1).
Second, if you do "select new_column from table" do you get an error or to you get no data?
-- Galen Boyer It seems to me, I remember every single thing I know.Received on Thu Aug 23 2001 - 09:25:15 CDT