| how do I....? [message #371229] |
Wed, 20 September 2000 10:31  |
Samuel
Messages: 17
Registered: September 2000
|
Junior Member |
|
|
i must declare in a table in oracle7 workgroup server, more one field with extension long, long raw, clob and nvarchar2.
I know that this is supported only by oralce8 but I have need of this declaration in oracle7.
At end i would like have a table with one more colums declare as long.
Eg: CREATE TABLE XXX (NAME LONG, NICKNAME LONG, ADRESS NVARCHAR2);
Help me please, i must to do this work for friday!
|
|
|
|
| Re: how do I....? [message #371236 is a reply to message #371229] |
Fri, 22 September 2000 00:48  |
Raghavendra M.K.
Messages: 10
Registered: September 2000
|
Junior Member |
|
|
You can't have 2 longs in a single table.
instead you can create 2 tables with one - one relation.
ex.
create table xxx1( id number constraint xxx1_pk primary key ,
nickname long
);
create table xxx2(id number constraint xxx2_pk primary key constraint xxx_fk references xxx1(id) ,
name long);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
