building table but get “missing right parenthesis”

I try to build this table

 CREATE TABLE OFFICER 
(
ID int(8) PRIMARY KEY,
FIRST_NAME varchar2(20) NOT NULL,
LAST_NAME varchar2(20) NOT NULL,
HIRE_DATE date NOT NULL,
UNHIRE_DATE date,
SALARY int(7),
PHONE_NUMBER int(10),
TYPE varchar2(15) NOT NULL
);

Do I have to use any constraint, reference? and What I lack for this code?

Answers


INT data type doesn't allow scale specification. Try either ID int primary key or Id NUMBER(8) primary key.


Try this,

CREATE TABLE OFFICER 
(
ID NUMBER(8) PRIMARY KEY,
FIRST_NAME varchar2(20) NOT NULL,
LAST_NAME varchar2(20) NOT NULL,
HIRE_DATE date NOT NULL,
UNHIRE_DATE date,
SALARY NUMBER(7),
PHONE_NUMBER NUMBER(10),
TYPE varchar2(15) NOT NULL
);

Need Your Help

Widget for listview

android android-widget

I'm not sure if this is possible, but here is the brief:

Touch action on a Sprite in cocos2d

ios ipad cocos2d-iphone css-sprites

I want to make an action in my sprites when they get touched, this is the action method:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.