Modify a constraint in Oracle

Can we modify constraints using "MODIFY" keyword in SQL?

Solution

No. Create a new constraint first and then drop the old one.

ORA-01840: input value not long enough for date format SQL Oracle
How to see all weeks and months by number
do a select from a potentiel non existing table
Retrieve result of StoredProcedure that has NO out parameter
Oracle retrieve only number in string
in Oracle database, how do I create a table of varchar2 type without length
How to create a comment to an oracle database view
How can I confirm a database is Oracle & what version it is using SQL?
Oracle - junction tables and connect to prior
Cannot stop/drop job in DBMS_SCHEDULER
CHECK constraint on date of birth?
Select without a FROM clause in Oracle
Resetting the Last_NUMBER in sequence by looking up a value from a table
Orcale SQL select next and previous 3 rows of a specific row in groups
Oracle SQL developer error: could not install some modules
How to exit sqlplus when error happens
What is the difference between -Xss and -XX:ThreadStackSize?
EF query to Oracle throwing "ORA-12704: character set mismatch"
Load data to remote DB using sqlldr
Oracle ORDERED hint cost vs speed
Oracle Merge Statement Raises "ORA-02012: missing USING keyword" Error
How to debug a SP response in Quarkus using EntityManager
How to avoid variable substitution in Oracle SQL Developer
How to use Function inside of MERGE USING clause in Oracle?
ORA-01861 Error When Trying to Create WHERE Date is 6 Months From Current Date
Identify the content type within a BLOB field
Does Connection pool also closes associated Session on the Database?
Is it possible to use GROUP BY with bind variables?
How to insert an "Optimizer hint" to Hibernate criteria api query
Spring boot with Oracle AQ and Universal Connection Pool