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.