 | |
9i: Check- constraint Upper(Column)
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
9i: Check- constraint Upper(Column) -
04-02-2008
, 04:19 AM
#2
| |||
| |||
|
|
Hi newsgroup, Is it possible to build a constraint, that ensures, that there are not more entries in a column, that look like 'Abc * ' -> trim(upper(..))='ABC' 'ABC' * *-> trim(upper(..))='ABC' 'aBC ' * -> trim(upper(..))='ABC' ? Alternativ I could build a shadow column filled by a trigger that containes trim(upper(..)) and a check constraint on this, but it seems to me that there is a better way. Thank you in advance Andreas Mosmann -- wenn email, dann AndreasMosmann <bei> web <punkt> de |
Index on (trim(upper(column))) may do the trick...
HTH.
Cheers.
Carlos.
#3
| |||
| |||
|
|
Hi newsgroup, Is it possible to build a constraint, that ensures, that there are not more entries in a column, that look like 'Abc * ' -> trim(upper(..))='ABC' 'ABC' * *-> trim(upper(..))='ABC' 'aBC ' * -> trim(upper(..))='ABC' ? Alternativ I could build a shadow column filled by a trigger that containes trim(upper(..)) and a check constraint on this, but it seems to me that there is a better way. Thank you in advance Andreas Mosmann -- wenn email, dann AndreasMosmann <bei> web <punkt> de |
Index on (trim(upper(column))) may do the trick...
HTH.
Cheers.
Carlos.
#4
| |||
| |||
|
|
Hi newsgroup, Is it possible to build a constraint, that ensures, that there are not more entries in a column, that look like 'Abc * ' -> trim(upper(..))='ABC' 'ABC' * *-> trim(upper(..))='ABC' 'aBC ' * -> trim(upper(..))='ABC' ? Alternativ I could build a shadow column filled by a trigger that containes trim(upper(..)) and a check constraint on this, but it seems to me that there is a better way. Thank you in advance Andreas Mosmann -- wenn email, dann AndreasMosmann <bei> web <punkt> de |
Index on (trim(upper(column))) may do the trick...
HTH.
Cheers.
Carlos.
#5
| |||
| |||
|
|
Hi newsgroup, Is it possible to build a constraint, that ensures, that there are not more entries in a column, that look like 'Abc * ' -> trim(upper(..))='ABC' 'ABC' * *-> trim(upper(..))='ABC' 'aBC ' * -> trim(upper(..))='ABC' ? Alternativ I could build a shadow column filled by a trigger that containes trim(upper(..)) and a check constraint on this, but it seems to me that there is a better way. Thank you in advance Andreas Mosmann -- wenn email, dann AndreasMosmann <bei> web <punkt> de |
Index on (trim(upper(column))) may do the trick...
HTH.
Cheers.
Carlos.
#6
| |||
| |||
|
|
On 2 abr, 11:19, Andreas Mosmann <mosm... (AT) expires-30-04-2008 (DOT) news- group.org> wrote: Hi newsgroup, Is it possible to build a constraint, that ensures, that there are not more entries in a column, that look like 'Abc * ' -> trim(upper(..))='ABC' 'ABC' * *-> trim(upper(..))='ABC' 'aBC ' * -> trim(upper(..))='ABC' ? Alternativ I could build a shadow column filled by a trigger that containes trim(upper(..)) and a check constraint on this, but it seems to me that there is a better way. Thank you in advance Andreas Mosmann -- wenn email, dann AndreasMosmann <bei> web <punkt> de Not sure about what you're trying to do, but a Function Based Unique Index on (trim(upper(column))) may do the trick... HTH. Cheers. Carlos.- Hide quoted text - - Show quoted text - |
done that before and it works without issue.
David Fitzjarrell
#7
| |||
| |||
|
|
On 2 abr, 11:19, Andreas Mosmann <mosm... (AT) expires-30-04-2008 (DOT) news- group.org> wrote: Hi newsgroup, Is it possible to build a constraint, that ensures, that there are not more entries in a column, that look like 'Abc * ' -> trim(upper(..))='ABC' 'ABC' * *-> trim(upper(..))='ABC' 'aBC ' * -> trim(upper(..))='ABC' ? Alternativ I could build a shadow column filled by a trigger that containes trim(upper(..)) and a check constraint on this, but it seems to me that there is a better way. Thank you in advance Andreas Mosmann -- wenn email, dann AndreasMosmann <bei> web <punkt> de Not sure about what you're trying to do, but a Function Based Unique Index on (trim(upper(column))) may do the trick... HTH. Cheers. Carlos.- Hide quoted text - - Show quoted text - |
done that before and it works without issue.
David Fitzjarrell
#8
| |||
| |||
|
|
On 2 abr, 11:19, Andreas Mosmann <mosm... (AT) expires-30-04-2008 (DOT) news- group.org> wrote: Hi newsgroup, Is it possible to build a constraint, that ensures, that there are not more entries in a column, that look like 'Abc * ' -> trim(upper(..))='ABC' 'ABC' * *-> trim(upper(..))='ABC' 'aBC ' * -> trim(upper(..))='ABC' ? Alternativ I could build a shadow column filled by a trigger that containes trim(upper(..)) and a check constraint on this, but it seems to me that there is a better way. Thank you in advance Andreas Mosmann -- wenn email, dann AndreasMosmann <bei> web <punkt> de Not sure about what you're trying to do, but a Function Based Unique Index on (trim(upper(column))) may do the trick... HTH. Cheers. Carlos.- Hide quoted text - - Show quoted text - |
done that before and it works without issue.
David Fitzjarrell
#9
| |||
| |||
|
|
On 2 abr, 11:19, Andreas Mosmann <mosm... (AT) expires-30-04-2008 (DOT) news- group.org> wrote: Hi newsgroup, Is it possible to build a constraint, that ensures, that there are not more entries in a column, that look like 'Abc * ' -> trim(upper(..))='ABC' 'ABC' * *-> trim(upper(..))='ABC' 'aBC ' * -> trim(upper(..))='ABC' ? Alternativ I could build a shadow column filled by a trigger that containes trim(upper(..)) and a check constraint on this, but it seems to me that there is a better way. Thank you in advance Andreas Mosmann -- wenn email, dann AndreasMosmann <bei> web <punkt> de Not sure about what you're trying to do, but a Function Based Unique Index on (trim(upper(column))) may do the trick... HTH. Cheers. Carlos.- Hide quoted text - - Show quoted text - |
done that before and it works without issue.
David Fitzjarrell
#10
| |||
| |||
|
|
Not sure about what you're trying to do, but a Function Based Unique Index on (trim(upper(column))) may do the trick... I try to ensure, that it is impossible to insert/update records in the |
BIG/little - Letters and the number of spaces
example:
CMyColumn
----------
TeSt EnTrY
It should be impossible to insert a record with CMyColumn =
'TEST ENTRY' or 'test entry' or ' test entry ' ...
Quote:
|
HTH. I tried it out: |
ON MySchema.MyTable upper(trim((CLOGINNAME)))
TABLESPACE MyIndexTableSpace LOGGING;
No Problem to create that index, but, after it, still no problem to
insert f.e. 'TEST ENTRY'
Any more idea?
Quote:
|
Cheers. Thanks Carlos. Andreas |
--
wenn email, dann AndreasMosmann <bei> web <punkt> de
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.