Need help in creating oracle tables

Hello all,

I am fairly new to Oracle & am still trying to learn the pl/sql syntax. I have no formal training but I need to use Oracle tables to extract data. I do have have some SQL under my wings.

Currently, I am using this syntax to create a table but I am getting a insufficient privileges error. Need grant syntax.

create table temp
(linenbr number (2,0) not null,
descript varchar2(50) not null,
temp1 varchar2(20) null,
temp2 varchar2(20) null,
temp3 varchar2(20) null,
temp4 varchar2(20) null,
temp5 varchar2(20) null,
primary key (linenbr));
create or replace view NM_Maps
as
select l.linenbr, l.descript, l.pinnbr from linc.propdb_lfile l
where l.pinnbr = '2068176385400M00009107';
select * from NM_Maps;

I don't know if it is possible but I get 4 rows that I need to stuff into one row. Table linc.probdb_file l returns the following:

Title 1 Title2 Title 3
---------- ------------------ ----------
1 result1a a
2 result2a a
3 result3a a
4 result4a a

What I need to happen is:

Title 1 Title 2 Title 3 Title 4 Title 5
------- -------- -------- -------- --------
xxxx Result1a Result2a Result3a Result4a

Also, I don't neccesarily know how many records I will get from linc.propdb_file l. So, the number of columns that I need to create in the second table is unkown.

Any help is appreciated.

Here is a particular favourite of mine that describes the syntax of Oracle commands.
http://www.ss64.com
As a dbadmin user (or similar) you can do things like:
grant create table to user