28 Apr
2008
28 Apr
'08
8:50 p.m.
That's why I *very dislike Oracle* and I can't understand why people using
it, they just don't stick with the standard.
I'm not sure what it is in your case, but maybe it's because:
- VARCHAR is limited and Oracle invented VARCHAR2
- CHAR and VARCHAR don't accept empty values if NOT NULL constraint is set
(in that case the attribut has to be defined as NULL and has to be checked
with the Oracle special function NVL() )
- Names of object is limited to 30 chars
Other nice things invented by Oracle:
- no BOOLEAN
- no info tables
- no limit => you have to write a procedure!
- division of an integer 99'999'999 typ NUMERIC(10) with an integer 1'000
equals a rounded result 100'000 (!)
- and more...Oracle is a typical lock-in application...but managers love it
anyway.. ;-)
Cheers,
Squirrel
On Mon, Apr 28, 2008 at 1:28 PM, Glenn Everitt <Glenn.Everitt(a)compuware.com>
wrote:
This page describes how to create indexes for a MySQL 4 or 5 database
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration…
and I can create indexes on Oracle 10 with the exception of:
create index xwl_value on xwikilargestrings (xwl_value(50));
create index xwd_parent on xwikidoc (xwd_parent(50));
create index xwd_class_xml on xwikidoc (xwd_class_xml(20));
which are clob and varchar columns.
xwd_class_xml CLOB(4000)
xwd_parent VARCHAR(1533)
xwl_value CLOB(4000)
Does anyone know how indexes should be created for these columns in
Oracle?
Thanks for any help
Glenn Everitt
--
View this message in context:
http://www.nabble.com/Oracle-Database-Index-tp16945142p16945142.html
Sent from the XWiki- Dev mailing list archive at Nabble.com.
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs