Sponsored Content
Top Forums Programming Sql developer how to upload the excel sheet in Oracle table Post 302925660 by durden_tyler on Tuesday 18th of November 2014 12:08:16 PM
Old 11-18-2014
Quote:
Originally Posted by ramkumar15
I have some records to be updated in oracle table. I am using sql developer tool. could any one tell me how to update those records in oracle table. I am having excel sheet with those records.
Connect to the schema where you have your table to be populated.
Click on the connection name, then Tables in the left pane.
Right click on the table which you intend to populate.
Left click on Import Data... (Doing this opens up a file explorer window.)
Navigate to your Excel spreadsheet, select it and click Open.

This opens up the Data Import Wizard. Keep selecting the options you want (depending on what you have in your Excel file and what you want in the table), and clicking Next till you reach the last page.
Then click Finish.
It will then load the data from Excel spreadsheet to your database table.
This User Gave Thanks to durden_tyler For This Post:
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl sql table upload variable problem

Hi, I wrote a perl script to create and upload data to a mysql data base. Please see the script as shown below, #!/usr/bin/perl -w #Defenetion of modules use in this scrpt use CGI qw(:standard); use DBI ; my $datetable1 = `date +%Y%m%d`; my $datetable = $datetable1 ; print... (2 Replies)
Discussion started by: maheshsri
2 Replies

2. HP-UX

upload oracle table

am on HP-Unix and want to upload table on windows oracle from HP-Unix Thanx Swapnil (2 Replies)
Discussion started by: swapnil286
2 Replies

3. Shell Programming and Scripting

HOWTO create in UNIX a Microsoft Excel-Sheet (with data from Oracle)

Hi HOWTO create in UNIX a Microsoft Excel sheet (with data from Oracle). At the moment I am making CSV files (using SQL statemens with || ';'), but search for more advanced formatting. Don't wish to use Perl. cheers (4 Replies)
Discussion started by: slashdotweenie
4 Replies

4. Programming

Help with Oracle SQL Developer - Subquery & Join will not work.

Greetings all, Hopefully there is someone out there on this forum who can help with this Oracle SQL Developer issue I have. Here is the code: CREATE OR REPLACE VIEW SALES_OVER_30000_WITH_TOTAL AS SELECT E.FIRST_NAME || ' ' || E.LAST_NAME AS EMPLOYEE_NAME, ... (2 Replies)
Discussion started by: U_C_Dispatj
2 Replies

5. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

Hi Guys.. Need your help to format the output of my shell script. I am using spool command to take out put in csv file. below is my code. (for example) col USERNAME for a15 col EMAIL for a30 col FULL_NAME for a20 col LAST_LOGIN for a40 col DATE_CREATED for a40 SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies

6. Programming

converting data from excel sheet to oracle using toad

guys i have data in excel sheet , how do i convert that data to database table (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies

7. Shell Programming and Scripting

Perl : to get all the hyperlinks from the xlsx sheet(hyperlinks not visible in excel sheet directly)

Hi folks, I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx). Spreadsheet contains few lines of hyperlink data (pic attached). P.S. Hyperlink is behind the data and not visible in excel sheet directly. Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies

8. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

Hi Folks, Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are 1excel.xslx 2excel.xslx 3excel.xslx now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
Excel::Template::Plus::TT(3pm)				User Contributed Perl Documentation			    Excel::Template::Plus::TT(3pm)

NAME
Excel::Template::Plus::TT - Extension of Excel::Template to use TT SYNOPSIS
use Excel::Template::Plus::TT; # this is most commonly used through # the Excel::Template::Plus factory my $template = Excel::Template::Plus::TT->new( template => 'greeting.tmpl', config => { INCLUDE => [ '/templates' ] }, params => { greeting => 'Hello' } ); $template->param(location => 'World'); $template->write_file('greeting.xls'); DESCRIPTION
This is an engine for Excel::Template::Plus which replaces the standard Excel::Template template features with TT. See the Excel::Template::Plus docs for more information. METHODS
Accessors config template template_class params Excel::Template compat methods params ($name | $name = $value)> This provides access to getting and setting the parameters, it behaves exactly like the standard CGI.pm-style param method. output Returns the generated excel file. write_file ($filename) Writes the generated excel file to $filename. Housekeeping DEMOLISH This will cleanup any temp files generated in the process. meta Returns the metaclass. BUGS
All complex software has bugs lurking in it, and this module is no exception. If you find a bug please either email me, or add the bug to cpan-RT. ACKNOWLEDGEMENTS
This module was inspired by Excel::Template::TT. AUTHOR
Stevan Little <stevan@iinteractive.com> COPYRIGHT AND LICENSE
Copyright 2007-2010 by Infinity Interactive, Inc. <http://www.iinteractive.com> This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2012-05-06 Excel::Template::Plus::TT(3pm)
All times are GMT -4. The time now is 11:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy