Posted By: Ray (Keep on the sunny side) on 'CZdatabases'
Title:     Re: Oracle newbie Q2
Date:      Mon Dec 11 17:59:05 2000

> Name                                                  Null?    Type
> ----------------------------------------------------- -------- -------------
> ALBUM_ID                                              NOT NULL NUMBER(3)

> FIELDS TERMINATED BY 't' TRAILING NULLCOLS
> (album_id CHAR,

> Record 1: Rejected - Error on table ALBUMS, column ALBUM_ID.
> ORA-01722: invalid number

Rekl bych, ze je to tim, ze cpes do NUMBERovyho sloupce CHAR.

  Ray

-- 
Kompilator je kancelarska aplikace.

Search the boards