Finding tables without primery keys, and non null unique keys

1

I have a requirement to find out tables without primary key or Not-NULL unique constraints. How do I do that in Oracle ?

I also want to find out any primary key column which has datatype as TIMESTAMP

Thanks for your help in adavance

DBPlayer

Posted 2019-05-30T05:36:49.100

Reputation: 11

Question was closed 2019-05-30T07:23:33.780

Can you program? – Mawg says reinstate Monica – 2019-05-30T06:35:23.180

http://www.dba-oracle.com/concepts/data_dictionary.htm – Sathyajith Bhat – 2019-05-30T07:24:30.073

No answers

Asked: 2019-05-30T05:36:49.100

Viewed: 16 times

Active: 2019-05-30T05:36:49.100