Tag: external table

Oracle Pro Members Standard Members

Using external tables to invoke Linux utilities and hold the data received

by

Using External Tables to Invoke Linux Utilities and Hold the Data Received By Yuli Vasiliev You might use external tables to query operating system data. As a preprocessor program to be used in your external table, you might create a shell script calling a Linux utility, such as ls, df, or ps. Moreover, you can pass arguments to the utility...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

External Table as a Data Loading Tool

by

External Table as a Data Loading Tool By Yuli Vasiliev The external tables feature can be used as a data loading tool – a good alternative to SQL Loader. You can create the external table with the SQL CREATE TABLE…ORGANIZATION EXTERNAL statement. Before you can do that, though, you have to set up a directory where the external table data...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →