Create table Employee
(
Employee_Id varchar2(8) Constraint emp_id_pk primary key,
FirstName varchar2(50),
LastName varchar2(50),
DeptID Number(5)
Constraint dept_id_fk Foreign Key(DeptId)
References Department(DeptId)
)
Error I am getting: Constraint specification are not
allowed here
Answer Posted / durgarao k
Create table Employee
(
Employee_Id varchar2(8) Constraint emp_id_pk primary key,
FirstName varchar2(50),
LastName varchar2(50),
DeptID Number(5),
Constraint dept_id_fk Foreign Key(DeptId)
References Department(DeptId)
)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is an oracle database table?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is procedure overloading in oracle?
How to pass a cursor variable to a procedure?
How to create a server parameter file?
How to create a stored procedure in oracle?
How to invoke the data pump export utility?
How to add another datafile to a tablespace?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to unlock the sample user account in oracle?
Can I create users through internet explorer in oracle 10g?
How to rename a tablespace in oracle?
How to export several tables together?
How to check the server version in oracle?
What are the components of logical database structure in oracle database?