File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
OCM Java EE 6 Enterprise Architect Exam Guide
this week in the
How to delete foreign key without name in Oracle
Joined: Nov 18, 2013
Jan 19, 2014 10:56:43
I forgot to give name of foreign key constraint.
I added Foreign key constraint in the following way:
ALTER TABLE Result1
ADD foreign key (stud_id) references Student(stud_id);
How I can drop the above foreign key constraint...???
Joined: Dec 25, 2013
Jan 19, 2014 12:37:24
Query the user_constraints table to get the constraint_name.
Then run an alter table query that will drop that constraint.
subject: How to delete foreign key without name in Oracle
error: Parameter index out of range (3 > number of parameters, which is 2).
Need clarification in Many to one Mapping- Please help.
complex table column type
a different object with the same identifier value was already associated with the session: [ValueObj
Syntax error for Access Database
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014