sqlfiddle - INSERT..SELECT in Oracle always fails with "SQL command not properly ended" -

i proficient in sql-server , other forms of sql, trying learn oracle sql. reason cannot simplest form of insert .. select .. work, fails "sql command not ended."

here current example:

create table table1 (year int, id int, dat date, categ varchar(99));  insert table1 (year, id, dat, categ) select year, id, dat, categ table1 id=5000 , year=2013; 

here's sqlfiddle of it: http://sqlfiddle.com/#!4/c4d34/1

i cannot seem figure out what's wrong here. have checked dozen other related question here @ , more dozen on google of answers either don't apply, or don't work. have tried million variations of commands above, nothing seems work.

any greatly appreciated.

---

fwiw, think sqlfiddle problem, many had contended.

the oracle user reported problem me code, of course using full sql statement, before had stripped down try isolate problem. that query had different problem happened report same error in sqlfiddle. specifically, its problem was using as table aliases, apparently invalid in oracle (or perhaps, in query had written).

in event, sincere tried me.

create table table1 (year int, id int, dat date, categ varchar(99)) /  insert table1 (year, id, dat, categ) select year, id, dat, categ table1 id=5000 , year=2013 

this works, is, if paste both statements in left (schema) window in sql fiddle. dont' think sql fiddle allows insert..select in sql window @ all.