oracle11g - Oracle SQL Develop: inserting txt file to sql table by cursor -

oracle11g - Oracle SQL Develop: inserting txt file to sql table by cursor -

i start larn oracle sql develop.

i thinking write cursor read text file line line , insert sql table.

however, not sure folder need set text file.

where should set text file ?

and

i started larn cursor... can give me simple illustration cursor?

thanks

a cursor way handle results of queries whithin plsql, basically, reading file cursor doesn't create sense...

there ways how read text file plsql , insert table. in cases should start with:

put file in specific directory in file system create directory db object references file scheme directory.

now can utilize utl_file, or (imho, nicer) external tables.

sql oracle11g cursor oracle-sqldeveloper