No, you can't use an expression in a primary key.
What i think you are looking for here is a primary key defined on ...
(INSTANCE_NAME,DB_DATE)
...and a separate check constraint on db_date to say ...
db_date=trunc(db_date)
View Poll Results: Expressin in Primary Field
Results 1 to 2 of 2
Thread: Expression in Primary Key
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote