APR Administrator's Guide FTP Directory Listing Form

Instructions and help about APR Administrator's Guide FTP Directory Listing

[Music] if i do a describe on the utl file package which is the facility we use to do file input and output on the oracle database i can close a file i can copy a file i can get attributes for the file the size etc i can open a file i can remove a file i can rename a file i can put outli output to the file it seems to have everything except the one thing i'd really like if i'm dealing with files what's the first thing you do when you're dealing with files you want to get a listing of what files are there and utl file does not offer that so here is my run directory command it's very simple i turn off echo and i say directory of i'm just going to do a listing of the oracle 19c binary directory where all the executables are stored you can see it simply does output typical windows output and i start listing out all the files in c oracle product 19 bin from a operating system point of view that works just fine now i'm going to hook it into an external table i create my table called director