Read text file from specified range usins pl/sql
This blogs will helps you to read text file from the specified range. you have a text file like this: 103 smith 20 32000 new jersy 105 Anderson 30 32000 new jersy 108 jack 40 37000 capetown 107 jackie 30 24000 melborn 128 saudi 20 17000 auckland 131 ramesh 40 30000 ghaziabad 123 kalki 50 20000 noida 153 ashish 50 20000 noida First of you should create directory: CREATE OR REPLACE DIRECTORY DATA_FETCH AS '/usr/bin/bfile_dir'; then provide grant previllage to user: GRANT read, write ON DIRECTORY DATA_FETCH TO user; then use following source code: DECLARE l_fileID_r ...