var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to create domain?
Does anyone know how to convert the following SQL CREATE DOMAIN statements to equivalent Oracle10g sql:
SQL> create domain GenderDomain char(2) constraint GD check ( value in('f','m'));
You'll have to create a table:
Now, use this table in your application and reference gender from other tables (this is why 'gender_domain' has a primary key constraint - without it, you wouldn't be able to create a referential integrity constraint).
CREATE TABLE gender_domain
(gender VARCHAR2(1) PRIMARY KEY,
CONSTRAINT ch_gen CHECK (gender IN ('M', 'F')));
so in oracle, we can not create a domanin. isn't right?
As far as I can tell, yes: there's no DOMAIN as such in Oracle. However, Designer *knows* domains (but that's a different story).
That's right. CREATE DOMAIN is (I believe) part of ANSI standard SQL, but it os not supported by Oracle.