answersLogoWhite

0


Best Answer

The UTL_FILE package provides that support in Oracle 9i. Oracle 11g supports a new feature known as Oracle External Tables (OET), which has many advantages over UTL_FILE, though OET can't replace all the functionality in UTL_FILE (yet).

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the syntax that can be use to get a text file from a directory using oracle 9i?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the right syntax for copying a file from a directory to another?

Do man cp from shell $ man cp


What is the rm command in Unix?

The rm command is used to delete a file or directory. Its syntax isrm file or rm -r directoryExample:rm myfilerm -r /home/user/mystuff


Is Oracle Report 6.1 supported?

I AM USING ORACLE 8i ,D2K 6i how to output file txt file to pdf automaticall generated please helpme xx


What is Fgetc and fputc in c?

fgetc gets a character from a file using a file pointer.the syntax is fget(fp) where fp is a pointer to the file


How do you change the permission modes of a file and directory in Linux?

use the chmod command syntax: chmod #### -option1 -option2 filename man chmod (for more information)


How do you create dummy file in unix?

using touch command of UNIX. syntax touch <filename> will create dummy regular file.


How do you read image in matlab?

Mat lab has got a predefined command for this purpose. The command is 'imread'. Syntax: A = IMREAD(FILENAME,FMT) It reads a grayscale or color image from the file specified by the string FILENAME. If the file is not in the current directory, or in a directory on the MATLAB path, specify the full pathname.


Will the java compiler translate a source file that contains syntax errors?

No it will not. Any java source file that has syntax errors will not be translated fully. The compiler will spit out errors based on the syntax problems in your code.


Which command is used to see the content of file?

You can get a list of all the files in the current directory with the "ls -a" command.


How do you export database in oracle?

To export the entire database to a single file dba.dmp in the current directory. - Login to server exp SYSTEM/password FULL=y FILE=dba.dmp LOG=dba.log CONSISTENT=y


What is the mv command in Unix?

The mv command is used to move a file or directory to another location. Its syntax ismv target destinationFor example:mv myfile /home/user/mystuff


How to upload to wordpress base directory?

You can upload the file using FTP software such FileZilla