How to add a primary key to a table that is not having any primary key?How to display the Date of birth from a table in the dd-mm-yyyy format?

Showing Answers 1 - 3 of 3 Answers

Waseem Mehmood
Profile Answers by Waseem Mehmood

Nov 20th, 2007

ALTER TABLE table_name
ADD CONSTRAINT table_column_pk PRIMARY KEY (column_name);

It is a table level primary key constraint applied on an existing table.

SELECT TO_CHAR(DOB, 'DD-MM-YYYY')
FROM table_name;