Home » RDBMS Server » Server Administration » Create a table....
Create a table.... [message #371223] Wed, 20 September 2000 05:33 Go to next message
Samuel
Messages: 17
Registered: September 2000
Junior Member
I am working with oracle7 workgroup server.
I must create a table in witch there are three colums:
the first is a varchar2, the second is Nvarchar2 and the third is Nclob.
I wroto so:
CREATE TABLE XXX (NAME VARCHAR2(34), XYZ NVARCHAR2, YYYY NCLOB);
but oracle give me an error ora - 00902 (invalid type).
why? How can I to create a table similar?
I'm sorry for my bad english and I thank you for the answer
Re: Create a table.... [message #371227 is a reply to message #371223] Wed, 20 September 2000 07:01 Go to previous message
Mahesh Pednekar
Messages: 28
Registered: August 2000
Junior Member
This datatye exist only in oracle 8 and above.

(Nvarchar2 and Nclob.)
Previous Topic: INPUT BOX COMMAND
Next Topic: Searching for string with multiple spaces
Goto Forum:
  


Current Time: Thu Mar 28 17:38:26 CDT 2024