Advertisement
ExaGridDba

11gR1 beta "smartfile" syntax

May 31st, 2017
257
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement