SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Followers

4 Following

SQL Daily (@sqldaily) 's Twitter Profile Photo
SQL Daily
@sqldaily

2 months ago

External tables in Oracle Database are a great way to read server-side files with #SQL But what if you want to change which file you're accessing? Use EXTERNAL MODIFY ( LOCATION ( 'new_file' ) ) You can also use this to change the direction, reject limit and access parameters

External tables in Oracle Database are a great way to read server-side files with #SQL But what if you want to change which file you're accessing? Use EXTERNAL MODIFY ( LOCATION ( 'new_file' ) ) You can also use this to change the direction, reject limit and access parameters