SHARE
TWEET

11gR1 beta "smartfile" syntax

ExaGridDba May 31st, 2017 72 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top