i need create two foreing keys in one table, for example in table PROFILE (id_user1, id_user2) add relations from table USER (id_user). i have a problem: reference name must be unique.

I am building a datamodel for Oracle 11g engine. I need to define a column type as xmltype that Oracle engine very well supports, but It is showing an error message saying 'the engine you chooses does not support the datatype you defined'.

Please assist.

Trying to delete a duplicate user but it is greyed out telling me I cannot because there are documents assigned.

I can't find any feature that allows me to remove documents from the user so I can delete them.

Please advise.

I study at Igor Sikorsky Kyiv Polytechnic Institute (Ukraine) and we have no university domain as such, we use ukr.net domain for all the university communication though.

How do I create and academic account?

If I modify a column of a table to allow NULL, the migration script generate this :

ALTER TABLE "myTable"

ALTER "myColumn" SET NOT NULL;

Instead of :

ALTER TABLE "myTable"

ALTER "myColumn" DROP NOT NULL;

How i can check db. Check for normal form. Do you have templates of normal forms?

Hi, I had vertabelo account with mailid: mayur.17892@yahoo.com and i have laerned SQL queries course till Correlation Sub queries. Today i tried to open my account but couldn't open and it said that there is no account with my Mail id.

Why isn't there a "U" on the right side next to type like there is a graphical representation for private and foreign keys? I know you can set a variable as unique but it doesn't show in the diagram.

I am attempting to import a number of new tables into an existing model, but when I do so (using the SQL Script Option) everything that was in the model previously is erased. Is there way to "merge" in these new tables and not have them simply overwrite what is in place?

Actually it was working before new year and now is broken.

Steps to reproduce:

1) Add 2 tables

2) Add reference between then

3) Select reference

4) Press "SQL Preview" button.

Result:

Empty preview (no SQL code except for comments).