Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

11gR1 beta "smartfile" syntax

ExaGridDba May 31st, 2017 68 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  1. Obsolete 11gR1 beta syntax still works in 12c
  2. =============================================
  3.  
  4. SQL*Plus: Release 12.1.0.2.0 Production on Wed May 31 22:24:29 2017
  5.  
  6. Copyright (c) 1982, 2014, Oracle.  All rights reserved.
  7.  
  8. Connected.
  9.  
  10. SQL> create table tl ( b blob ) lob ( b ) store as smartfile;
  11.  
  12. Table created.
  13.  
  14. SQL> select securefile from user_lobs where table_name = 'TL' and column_name = 'B';
  15.  
  16. SEC
  17. ---
  18. YES
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