Aqua Data Studio 15.0.0-dev-197
Build #: 36942
Built on: 2014-Mar-26 06:11:34 PM
Windows 7:64 bit
Database: Oracle 12C
1: Connect to Oracle 12C.
Open View log.
2: Create a table including "interval year to month" datatype.
Insert some records
Script:
CREATE TABLE "time_date_table1" (
"date_d" DATE NULL,
"interval_month_year" INTERVAL YEAR(2) TO MONTH NULL,
"interval_day_seconds" INTERVAL DAY(2) TO SECOND(6) NULL
)
TABLESPACE "PROJECT" COMPRESS PCTFREE 10 INITRANS 1 MAXTRANS 255
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL RECYCLE )
NOPARALLEL
LOGGING
NOCACHE
MONITORING
NOROWDEPENDENCIES
ENABLE ROW MOVEMENT
GO
INSERT INTO "time_date_table1"("date_d", "interval_month_year", "interval_day_seconds")
VALUES(SYSDATE, INTERVAL '4-2' YEAR TO MONTH, INTERVAL '4 5:12:10.222' DAY TO SECOND)
GO
INSERT INTO "time_date_table1"("date_d", "interval_month_year", "interval_day_seconds")
VALUES(SYSDATE, INTERVAL '5-3' YEAR TO MONTH, INTERVAL '4 5:17:10.222' DAY TO SECOND)
GO
INSERT INTO "time_date_table1"("date_d", "interval_month_year", "interval_day_seconds")
VALUES(SYSDATE, INTERVAL '4-2' YEAR TO MONTH, INTERVAL '4 5:42:10.222' DAY TO SECOND)
GO
3: Open export data tool for "time_date_table1" table.
Click NEXT
Select "Format: Insert statements"
Click NEXT
In exported insert statements,NULL is displayed for "INTERVAL YEAR TO MONTH" and "INTERVAL DAY TO SECOND" datatypes of Oracle 12C.
However, correct data is exported for "Format:Excel workbook" and "Format: Excel 2007 workbook".
