daily pastebin goal
33%
SHARE
TWEET

Untitled

a guest Feb 13th, 2018 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SQL> alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss';
  2.  
  3. Session altered.
  4.  
  5. SQL> create table test
  6.   2    (isbn varchar2(30),
  7.   3     date_entered date default sysdate
  8.   4    );
  9.  
  10. Table created.
  11.  
  12. SQL> insert into test (isbn) values ('1234');
  13.  
  14. 1 row created.
  15.  
  16. SQL> select * From test;
  17.  
  18. ISBN                           DATE_ENTERED
  19. ------------------------------ -------------------
  20. 1234                           13.02.2018 19:45:34
  21.  
  22. SQL>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top