CREATE TABLE syntax error
I am working on a table design for class and it is required that we use a query to create it. My query is:
CREATE TABLE Cust (customer_number CHAR(3),
Each time I try to tun it I get:
Syntax error in CREATE TABLE statement.
I've replaced NUMBER with several other things like NUMERIC, INTEGER, CURRENCY etc. When I take off the 5 it accepts it. The book is asking for a numeric balance of five digits. Everything runs ok up until that point.
The exact question is:
Create a table called Cust with a customer number as a fixed-length character string of 3, an address with a variable-length character string of up to 20, and a numeric balance of five digits.
I've been up at school all day and I've even had tutors try to help me and they were unsuccessful! Any help would be greatly appreciated!