( patient_id number(6) not null,
room varchar2(10),
admin_date date default sysdate,
release_date date,
release_desc varchar2(4000),
constraint emphistory_pk
primary key (patient_id, admin_date)
)
/
| Create_Drop_Table1.htm |
| Oracle10g_iSQL : |
| create table patient_history ( patient_id number(6) not null, room varchar2(10), admin_date date default sysdate, release_date date, release_desc varchar2(4000), constraint emphistory_pk primary key (patient_id, admin_date) ) / |
| Creating Table
|
|