Posted By: BigFoot (In Your Room) on 'CZdatabases' Title: Oracle newbie Q2 Date: Mon Dec 11 14:52:40 2000 Zdar Snazim se dostat do Oracla z textaku nejaky "data" (ucim se, takze to neni nic zavazneho :). Takhle vypada tabulka, do ktere to sypu: Name Null? Type ----------------------------------------------------- -------- ------------- ALBUM_ID NOT NULL NUMBER(3) FILENAME NOT NULL VARCHAR2(255) TITLE NOT NULL VARCHAR2(100) IMAGE_0 VARCHAR2(255) IMAGE_1 VARCHAR2(255) IMAGE_2 VARCHAR2(255) IMAGE_3 VARCHAR2(255) Album_id je PRIMARY KEY. Tohle je muj albums.ctl: LOAD DATA INFILE * INTO TABLE albums REPLACE FIELDS TERMINATED BY 't' TRAILING NULLCOLS (album_id CHAR, filename CHAR, title CHAR) BEGINDATA 0 t Antiloop @ Fastlane People.m3u t Fastlane People 1 t ATB @ Movin' Melodies.m3u t Movin' Melodies 2 t Beastie Boys @ Ill Communication.m3u t Ill Communication ... Tam, kde vidite "t", MAM v souboru samozrejme TAB; misto "CHAR" u album_id jsem zkousel i "INTEGER EXTERNAL", "NUMBER(3). Nic se "samozrejme" nevlozi a tohle je kousek z logu: Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- --------------------- ALBUM_ID FIRST * t CHARACTER FILENAME NEXT * t CHARACTER TITLE NEXT * t CHARACTER Record 1: Rejected - Error on table ALBUMS, column ALBUM_ID. ORA-01722: invalid number Help PLZ. BigFoot, aka Yaroukh; yaroukh@email.cz "Budiz svetlo", rekl Booh - a bylo svetlo ... "Budiz k nicemu", rekl Booh - and here I am ! 8}__ __ _