Hi,
What is the Alter Table SQL commands to add a not null constraint to a pre-existing field of a pre-existing table. I want Oracle to create the constraint name automatically.
Thanks for your help
Frank
The following statement lists all indexes in the database:
select * from ALL_INDEXES
Is there a way to get the properties of a particular index vis SQL-PLUS. Basically I am looking for the create index statement to see the fields used in a particular index.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.