It's Oracle syntax.

It won't work in my SQL i believe.

but it does in oracle .

Yes we can disable the primary key which is when referred by foreign keys, using the following command:

ALTER TABLE employee DISABLE CONSTRAINT emp_id CASCADE;

this will disable the primary key...