# Create Directory
1 | create directory EDI_TEST as '/usr/tmp/edi/test'; |
OWNER | DIRECTORY_NAME | DIRECTORY_PATH |
---|---|---|
SYS | EDI_TEST | /usr/tmp/edi/test |
Set Directory Access Permissions
1 | [testmgr@erptest edi]$ ls -l |
# Put Content to File
1 | declare |
hello.txt
1 | put_line: hello world! |
# Get Content from File
1 | declare |
# Put Table Content to File
1 | declare |
# Put Cursor Content to File
1 | declare |
# Put Content use Bulk Collect
1 | declare |
1 | declare |
# Copy
1 | begin |
# Remove
1 | begin |
# Rename
1 | begin |
# File Attribute
1 | declare |
# Get CSV Content from File to Table
1 | declare |
emp.csv
1 | 7369,SMITH,CLERK,17-DEC-80 |
1 | declare |
EMPNO | ENAME | JOB | HIREDATE |
---|---|---|---|
7369 | SMITH | CLERK | 1980-12-17 |
7499 | ALLEN | SALESMAN | 1981-02-20 |
7521 | WARD | SALESMAN | 1981-02-22 |
7566 | JONES | MANAGER | 1981-04-02 |
7654 | MARTIN | SALESMAN | 1981-09-28 |
7698 | BLAKE | MANAGER | 1981-05-01 |
7782 | CLARK | MANAGER | 1981-06-09 |
7788 | SCOTT | ANALYST | 1982-12-09 |
7839 | KING | PRESIDENT | 1981-11-17 |
7844 | TURNER | SALESMAN | 1981-09-08 |
7876 | ADAMS | CLERK | 1983-01-12 |
7900 | JAMES | CLERK | 1981-12-03 |
7902 | FORD | ANALYST | 1981-12-03 |
7934 | MILLER | CLERK | 1982-01-23 |