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