Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select dates between two dates
On Mon, 28 Dec 1998, Thomas Kyte wrote:
>
> Try this:
>
> SQL> create or replace type myTableType as table of date;
> 2 /
> Type created.
>
>
[...]
Thanks a lot for your examples they are very interesting. But I thing I don't have the right Oracle version to run them :((((
SQL*Plus: Release 8.0.5.0.0 - Production on Tue Dec 29 11:50:12 1998
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Connected to:
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
SQL> CREATE OR REPLACE TYPE myTableDate AS TABLE OF DATE;
/
2 CREATE OR REPLACE TYPE myTableDate AS TABLE OF DATE;
*
ERROR at line 1:
ORA-00439: feature not enabled: Objects
This is with the Linux developer version (still waiting for an official version available in France ...). I'm not sure but Objects is only available for Enterprise edition ??
Is there a workaround ? I would really much prefer a dynamic table like in your example.
Thanks.
---
Yann Doussot <doussot_at_gifrance.com>
Grey Interactive - France - http://www.gifrance.com/
Cell: +33 6 12 71 70 03 Work: + 33 1 46 84 85 00
Received on Tue Dec 29 1998 - 04:57:25 CST