Date calculation in insert statement : INSERT with Functions « Insert Delete Update « Oracle PL / SQL






Date calculation in insert statement

 
SQL>
SQL>
SQL>  create table old_log(
  2      activity long,
  3      completed date
  4    )
  5    /

Table created.

SQL>
SQL>  insert into old_log values ('Completed chapter 1', sysdate - 60 );

1 row created.

SQL>
SQL>  insert into old_log values ('Completed chapter 2', sysdate - 30 );

1 row created.

SQL>
SQL>  create table author_log(
  2      activity clob,
  3      completed date
  4    );

Table created.

SQL>
SQL>  insert into author_log select to_lob( activity ), completed from old_log;

2 rows created.

SQL>
SQL>   select * from author_log;
ACTIVITY
--------------------------------------------------------------------------------
COMPLETED
--------------------
Completed chapter 1
17-APR-2008 17:29:01

Completed chapter 2
17-MAY-2008 17:29:01


2 rows selected.

SQL>
SQL> drop table old_log;

Table dropped.

SQL> drop table author_log;

Table dropped.

SQL> --

 








Related examples in the same category

1.You can use variables such as SYSDATE and USER in your INSERT statements
2.Inserting values using System function: SYSDATE
3.Use Trunc in insert statement