how to run this coding

[sathynryn]

hi !....plz help me to run this coding.....
[code=oracle]

create type browse as object(vs varchar 2(700));
create type visite as table of browse;
create table inms(us varchar2(25), visdin visite) nested table visidin store as inmsd;
insert into inms values('&n',vis ite(browse('&s' ));

create type rfdv as object(rf varchar 2(700));
create type rfds as table of rfdv;
create table rfd(us varchar2(25), rf rfds) nested table rf store as rfdsv;
insert into rfd values('&n',rfd s(rfdv('&s'));
[/code]

plz..... tell me the database form for this coding....

[debasisdas]

Are you getting any error with this code ?

[amitpatel66]

What exactly you are looking at when you say "Database form of this coding??

[sathynryn]

Are you getting any error with this code ?

no error...
it shows warning: type created with compilation error.


if i insert values , it shows table or type does not exist....

[sathynryn]

What exactly you are looking at when you say "Database form of this coding??

im not familiar with oracle ....
i just get this coding from my friend ....
so i want the table design for this coding ...

[amitpatel66]

im not familiar with oracle ....
i just get this coding from my friend ....
so i want the table design for this coding ...

Well, if you check your piece of code, the tables are already created.

[sathynryn]

Well, if you check your piece of code, the tables are already created.

thanks......
but is shows that table or view does not exist .....
wat to do?

[amitpatel66]

thanks......
but is shows that table or view does not exist .....
wat to do?

[code=oracle]

Select * from inms;


Select * from rfd;

[/code]

You run the piece of code that you have one by one and then run the above two sql statements.

[sathynryn]

ya i tried it ......
but as i told u already ,,
its shows error that view or table does not exist

[sathynryn]

for the additional information ,

it doesn't displays table created when i run( CREATE TABLE inms(us VARCHAR2(25), visdin visite) nested TABLE visidin store AS inmsd;)

instead , the line is continuing.....

then i come out of that by giving /...

and i insert the values fo n and s...

after that when i gave select * from inms ,
it shows the error table or view does not exist

[shreya alle]

for the additional information ,

it doesn't displays table created when i run( CREATE TABLE inms(us VARCHAR2(25), visdin visite) nested TABLE visidin store AS inmsd;)

instead , the line is continuing.....

then i come out of that by giving /...

and i insert the values fo n and s...

after that when i gave select * from inms ,
it shows the error table or view does not exist

Hi
This is working fine... check this...

CREATE TYPE browse AS object(vs VARCHAR2(700));
CREATE TYPE visite AS TABLE OF browse;
CREATE TABLE inms(us VARCHAR2(25), visdin visite) nested TABLE visdin store AS inmsd;
INSERT INTO inms VALUES('&n',visite(browse('&s'));
 
CREATE TYPE rfdv AS object(rf VARCHAR2(700));
CREATE TYPE rfds AS TABLE OF rfdv;
CREATE TABLE rfd(us VARCHAR2(25), rf rfds) nested TABLE rf store AS rfdsv;
INSERT INTO rfd VALUES('&n',rfds(rfdv('&s'));