How to retrieve file name and path of an excel spreadsheet imported into Oracle Database

Ads

Share on Google+

Vanessa Yhap

How to retrieve file name and path of an excel spreadsheet imported into Oracle Database
0 Answer(s) 5 years and a month ago
Posted in : SQL

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?

Ads

View Answers

Ads

Related Tutorials/Questions & Answers:

How to retrieve file name and path of an excel spreadsheet imported into Oracle Database
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

How to insert rows from Excel spreadsheet into database by browsing the excel file?
How to insert rows from Excel spreadsheet into database by browsing the excel... the excel file using file browsing dialogue through form in JSP. How can i select excel file and insert rows into MSSQL database in JSP??? Have a look

Advertisements

How to Retrieve Data from the database and write into excel file using Java
How to Retrieve Data from the database and write into excel file using Java Hi, I am trying to develop an small application where i trying to retrieve Data from the database and store the details in excel file. Please can

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

how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database using jsp or oracle??? sir.. i have number of excel sheets which...://www.roseindia.net/answers/viewqa/JSP-Servlet/28123-write-excel-file-into-the-oracle

Retrieve Data from the database and write into excel file
Retrieve Data from the database and write into excel file. In this section, we are going to retrieve data from the database and write into the excel file..., we have inserted the database table values in the excel sheet. Here

how to display or retrive an image in jsp whose path is stored in oracle database
how to display or retrive an image in jsp whose path is stored in oracle database how to display or retrive an image in jsp whose path is stored in oracle database and the image is stored in my pictures folder

File insertion into oracle database
File insertion into oracle database How to Read and Insert a file (any format) into a Oracle database

how to upload multiple files in jsp and saving the path in database and the file in folder
how to upload multiple files in jsp and saving the path in database and the file in folder how to upload multiple files in jsp and saving the path in database and the file in folder I have created a form for the upload of files

Retrieve Data into JTable and export it to Excel File
Java Retrieve Data into JTable and export it to Excel File In this section, you will learn how to retrieve the data from the database in the table and then export it to the Excel file. For this, we have created a table

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

How to browse excel file and stored the contents into the database using jsp/servlet?
How to browse excel file and stored the contents into the database using jsp/servlet? Hi.. I want to browse excel file and stored the file data into the My-sql database using jsp/servlet

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

How to store user name,city,state,image path into database and image into folder using jsp
How to store user name,city,state,image path into database and image into folder using jsp How to store user name,city,state,image path into database and image into folder using jsp

connection of java file to excel file and put data from excel file into oracle db
connection of java file to excel file and put data from excel file into oracle... give action to that button excel sheet? how we connect excel file to java file as wellas to oracle db to insert excel data into database

How I Upload File and Store that file name in Database using JSP
How I Upload File and Store that file name in Database using JSP Hi All, I m the beginner in JSP and I want to upload the file and store that file and some other form data in MySQL database. Ex. There is one employee detail

How to Upload a file directly to Oracle database using JSP or Servlets?
How to Upload a file directly to Oracle database using JSP or Servlets? Hi I want to upload a file(csv or excel) to Oracle 10g Database using JSP...;Upload File to Oracle Database</h2> <form id="form1" enctype

Image name,image path into database and image into folder using jsp
Image name,image path into database and image into folder using jsp How to insert image path and image name into oracle database and image into folder using jsp

connect jdbc to an Excel spreadsheet
connect jdbc to an Excel spreadsheet hello, How can I connect to an Excel spreadsheet file using jdbc? Hello Friend, Follow... Excel Driver(*.xls) Select work book or excel file and Create the DSN name (e.g

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.1.8
Getting path name of uploading file in struts 2.1.8 In my question I used struts 2.8.1 instead of 2.1.8. Sorry

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 get java path name
How to write script in Java <html> <head> <script>alert('ok')</script> </head> </Html>

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

how to retrieve data from database ?????/
how to retrieve data from database ?????/ how to retrieve data from database

how to retrieve data from database ?????/
how to retrieve data from database ?????/ how to retrieve data from database

how to retrieve data from database ?????/
how to retrieve data from database ?????/ how to retrieve data from database

how to retrieve data from database ?????/
how to retrieve data from database ?????/ how to retrieve data from database

Constructing a File Name path in Java
is helpful for mapping local file name with the actual path of the file using the constructing filename path technique. As you have seen, how a file... Constructing a File Name path

how to retrieve data from database
how to retrieve data from database unable to retrieve data from database using mySQL by using jsp sessions and beans for editing

Retrieve database from the table dynamically in jsp from oracle using servlet
Retrieve database from the table dynamically in jsp from oracle using servlet Sir, I have created a table in oracle using eclipse, and added few columns dynamically. I want to retrieve the table with all columns dynamically

Ads

Advertisement null

Ads