11gR1 beta "smartfile" syntax
ExaGridDba May 31st, 2017 68 Never
- Obsolete 11gR1 beta syntax still works in 12c
- SQL*Plus: Release 220.127.116.11.0 Production on Wed May 31 22:24:29 2017
- Copyright (c) 1982, 2014, Oracle. All rights reserved.
- SQL> create table tl ( b blob ) lob ( b ) store as smartfile;
- Table created.
- SQL> select securefile from user_lobs where table_name = 'TL' and column_name = 'B';
RAW Paste Data