Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
How to alter the or drop the default constraint in oracle sql
This is a discussion on How to alter the or drop the default constraint in oracle sql within the Oracle forums, part of the Databases category; How to alter or drop the default constraint in oracle sql?...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
11-07-2008
|
|||
|
|||
|
How to alter the or drop the default constraint in oracle sql
How to alter or drop the default constraint in oracle sql?
|
| Sponsored Links |
|
11-08-2008
|
|||
|
|||
|
Re: How to alter the or drop the default constraint in oracle sql
find the na,me of the constraing from user_constraints. then use the same for alter process.
|
|
11-08-2008
|
|||
|
|||
|
Re: How to alter the or drop the default constraint in oracle sql
How to set default constraint and constraint_name in oracle.
for ex using primary constraint syn for: create table table_name (eid number(5) constraint constraint_py primary key); like wise how to assign the constraint_name in default constraint.
|
|
11-09-2008
|
|||
|
|||
|
Re: How to alter the or drop the default constraint in oracle sql
if you assign a name ,from where comes the default constraint ?
|
|
05-10-2009
|
|||
|
|||
|
Re: How to alter the or drop the default constraint in oracle sql
While specifying a constraint you can give the constraint a name.
but if you do not specify any name for the constraint Oracle will generate a constraint name of the format SYS_Cn were n is a unique number generated by oracle server.
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to alter a type in SQL | Geek_Guest | SQL | 8 | 02-06-2008 03:51 AM |
| Not null constraint | Geek_Guest | SQL Server | 2 | 10-17-2007 07:05 AM |
| Constraint based loading and incremental aggretation | Geek_Guest | Data Warehousing | 0 | 04-06-2007 04:46 AM |
| Default username/password for Oracle 8i | JobHelper | Oracle | 4 | 02-14-2007 02:51 AM |
| Check Constraint | christia | SQL | 2 | 07-30-2006 07:16 PM |
All times are GMT -4. The time now is 11:58 AM.
