11gR1 beta "smartfile" syntax
ExaGridDba May 31st, 2017 72 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- Obsolete 11gR1 beta syntax still works in 12c
- SQL*Plus: Release 22.214.171.124.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