How to retrieve file name and path of an excel spreadsheet imported into Oracle Database
I imported an excel spreadsheet using sql developer into my Oracle database and I want to know how to retrieve the path of the file?
The original spreadsheets on my computer are not all located in the same folders as they are divided into many subfolders. I am currently just creating external table for each spreadsheet but I want to obtain the path and filename of each of the spreadsheets imported (so I would know the location of the original source file on my computer) and have it within a new column in the tables or make a new table for just the path and filename.
Is there a way to do this using PL/SQL?
View Answers
Ads
Related Tutorials/Questions & Answers:
Advertisements
write excel file into the oracle database
write
excel file into the
oracle database dear sir,
i need the jsp code that reads the
excel file and stores it into the
oracle database table..and also i need the code to connect
oracle database?
thank u in advance
Import Excel file(date) into mysql database in php
Import
Excel file(date) into mysql
database in php I try to import
excel file which contains data date(yyyy-mm-dd) into mysql
database in php...);
echo"<script>alert('
File $
path Imported Successfully')</script>
Getting path name of uploading file in struts 2.8.1
Getting
path name of uploading
file in struts 2.8.1 Hai! I am using struts 2.8.1. I want to upload
file into
database with the
path name.
How can I can get the original
path name of the
file in struts 2.8.1? It only display
Constructing a File Name path
Constructing a
File Name path
... construct a
file name path. By using the constructing
filename
path it is possible to set dynamic
path, which is helpful for mapping
local
file name
Dropdown code to retrieve result from oracle database
Dropdown code to
retrieve result from
oracle database Hi Friends,
I...
retrieve the result from
Oracle database.We have procedures created already.Just... that will
retrieve values from the
database into dropdown. As the user choose any option
How to retrieve the file status?
How to
retrieve the
file status? Hi all,
I did a project which........ it checks the entire
database
and retrieves the result that the
file is at customs dept if the
file is with customs.
Please provide me a code using JSP on
how
insert values from excel file into database
the following link:
Insert values from
excel file to
database...insert values from
excel file into database hi i want to insert values from
Excel file into database.Whatever field and contents are there in
excel
How to retrieve image from database
How to
retrieve image from database hi........
How to
retrieve image from
database when it is stored.
I have stored image in postgresql and want to
retrieve in java form.
Can u tel me hw to do?
I am trying n able to do also
how to store and retrieve image from database
how to store and
retrieve image from database
how to store and
retrieve images into
database(
oracle) and
how to retrive images from
database using jsp
Here is a jsp code that insert and
retrieve image from mysql