Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL> alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss';
- Session altered.
- SQL> create table test
- 2 (isbn varchar2(30),
- 3 date_entered date default sysdate
- 4 );
- Table created.
- SQL> insert into test (isbn) values ('1234');
- 1 row created.
- SQL> select * From test;
- ISBN DATE_ENTERED
- ------------------------------ -------------------
- 1234 13.02.2018 19:45:34
- SQL>
Add Comment
Please, Sign In to add comment