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 "Schema Script Generator for" "time_date_table1" table.
Click NEXT
In "options" tab, include options:"Generate the create" and "Include insert statements for table data"
Click NEXT
In generated insert statements,NULL is displayed for "INTERVAL YEAR TO MONTH" and "INTERVAL DAY TO SECOND" datatypes of Oracle 12C.
added oracle interval type handling