I have two tables

```
create table p
(
  x number,
  y number,
  z number
);

create table q 
(
  a number,
  b number,
  c number,
  d  varchar2(20)
);

```

I have inserted 

```
insert into p values('1','2','3');

```

now i need to insert into q selecting values from p with last field getting name like Table \_name in table q 

values such that table q contains

```
a  b  c  d
1  2  3   table_name

```

plz help as soon as possible