SQL & PL/SQL :: Single Excel File For Emp Table Department Wise In Different Sheets Of Excel

Mar 30, 2012

I need to generate a single excel file which each department details in seperate sheets of the excel file, each sheet should ne named with department no (ex :Dept_10, Dept_20,Dept_30) and the main excel should be named as Emp_details.

Header row and total row should be in bold.I have created 3 individual excels thru toad and moved them to single excel and renamed the sheets.

Can we programatically do this thru SQL or PL/SQL, does Oracle provide any build packages for excel.As excel files cannot be uploaded,I am unable to upload the excel file I generated manually.

select to_char(empno) empno,ename,job,mgr,hiredate,
nvl(sal,0) sal,nvl(comm,0) comm,nvl(sal,0) + nvl(comm,0) "Total Income" ,deptno
from emp
where deptno = 10
union all
select 'Total',null,null,null,null,sum(nvl(sal,0)),sum(nvl(comm,0)),sum(nvl(sal,0))+sum(nvl(comm,0)),null
from emp
where deptno = 10;

View 1 Replies


ADVERTISEMENT

How To Read Multiple Sheets Of Excel Spreadsheet

Dec 11, 2012

I have a requirement from a customer that i have to read an excel file contains data in Multiple sheets of the same excel sheet.

how to read the multiple sheets of an excel sheet in Oracle?

View 1 Replies View Related

SQL & PL/SQL :: Removing Leading Single Quote In Excel File?

Feb 20, 2013

This package is generating excel file which contains cursor result.In excel data is populated like below.Column name is Zip_code .My concern is how to remove that single quote from excel file.

eg:

Zip_
'01234
'12567
'23432
'00234

create or replace
PACKAGE BODY PKG_MONTH_END_AUTOMATION AS
PROCEDURE PROC_ZIP_CODE_MONTHEND (directoryOrPath IN VARCHAR2 default 'LOC_PHASE1_WHOUSE_SALES_ADMIN')

[code]...

-- main body

BEGIN
-- Generating Zip Files
SELECT last_day(add_months(sysdate,-1))
INTO v_last_date

[code]...

View 6 Replies View Related

SQL & PL/SQL :: Import Excel File To Table

Jan 10, 2013

I have two columns in excel which i need to import in oracle table , but the problem is one column is of type date , i want the same date format to be maintained in table too.

View 8 Replies View Related

Client Tools :: Import Of Data From Excel File Into Table?

May 28, 2012

We have a table partymast. we want to import the data into this table using excel file having extension .csv. I am explaining all the things below:

select *from partymast

partyid partyname accountname aacname
aa aa 10014000023367 Ashish

select * from master

masterid mname
10014000023367 Ashish

aacname column in partymast table is fetching from master table mname column.

We have third table name IMPEXP

Iename iedesc ietype iedef
import party master import party master imp {ImportStart}
[Transid]=party
[ImportFile]=:
[FileType]=excel
PartyID=col_1
PartyCat=col_2
AccountName=col_3
{ImportEnd}

Sir, I am enclosing the Excel file. what will be the next step that we should filllow.

View 3 Replies View Related

SQL & PL/SQL :: Procedure To Load Data In Oracle Table Into Excel File

Dec 29, 2010

send me the procedure for loading the data in an oracle table into an excel file.

View 5 Replies View Related

Client Tools :: Import Excel File To Database Table Using TOAD?

Jan 16, 2011

want to load data from an excel file to a database table in Oracle. I am using Oracle 11 and the excel file has 3 columns as compared to 5 columns in the destination table. I want to generate sequential nos also for the table.

View 7 Replies View Related

SQL & PL/SQL :: How To Get Department Wise Effective Rate

Oct 26, 2013

1) First Table

Id , Name , Eff_date
10 I1 15-APR-2013
20 I2 30-APR-2013
30 I3 26-May-2013
20 I4 10-SEP-2013
40 I5 10-sep-2013
40 I6 10-Oct-2013

2) Second Table

Eff date Rate
15-APR-2013 900
30-APR-2013 500
16-Sep-2013 400
05-Oct-2013 200

Q. How to get department wise effective rate?

View 3 Replies View Related

Export/Import/SQL Loader :: How To Import Data From Excel File To Table Through Procedure

Jul 2, 2012

How to import data from excel(.xls) file to data base table

I have excel sheet(.xls) data details, I neet to upload details to data base table using procedure

excel sheet is not CSV file, so SQL Loader is not using

any alternative solution for this issue

View 3 Replies View Related

Forms :: D2k 6i And Excel File?

Jun 23, 2010

I have generate a excel file through oracle developer 2000 6iwith password protect using OLE2 but autofilter,sort and format column options are not working.

PROCEDURE UnProtectCell(r NUMBER,c NUMBER) IS
BEGIN
args:= ole2.create_arglist;
ole2.add_arg(args, NumToRange(r, c));
XLRange:= ole2.get_obj_property worksheet, 'Range', args); ole2.destroy_arglist(args);

[code]...

View 6 Replies View Related

SQL & PL/SQL :: Reading From A Excel File

Dec 1, 2011

I am looking for a code/script to read values from excel file and perform PLSQL script.

Now i have the PLSQL script to generate report which takes two value which i have to change all the time to generate new report .All i wanna do create a script to read from a excel file and perform the other script.

I have been searching from a long time and only found UTL_file Package which use CREATE OR REPLACE FUNCTION and create some virtual table.

The problem is i don't have create authorization in database so i m not able to use UTL_File command . Is there any simple way to read value from excel file?

View 16 Replies View Related

SQL & PL/SQL :: Excel File Can't Open

Aug 17, 2010

im sending email with attachment of report output in xml format. file was attached but cant opened.

it show me error at the time of opening that

XML ERROR in Unknown
REASON: Illegal Tag
FILE: C:Documents and SettingsTxisDesktopAR_AGING_DETAILS_1186958_1(3).XML
VALUE: ?B/to{??C

i face this problem when i send mail on yahoo and from outlook. but it opened in gmail, from incredimail

View 1 Replies View Related

SQL & PL/SQL :: Convert Excel File Into Text?

Aug 2, 2010

i want to convert an excel file into text and then into oracle table.

View 6 Replies View Related

SQL & PL/SQL :: Procedure To Convert Excel File To XML?

Mar 21, 2012

I need a PL/SQL code to convert an excel file to xml file.

View 3 Replies View Related

SQL & PL/SQL :: Image In XML To Generate Excel File

Jul 8, 2010

how to attach an IMAGE in XML and that will be used in PL SQL procedure to generate the Excel file with the IMAGE. I cannot able to save the xml as excel with the image

View 3 Replies View Related

SQL & PL/SQL :: Export BLOB File In Excel?

Dec 5, 2012

I want to export the data from oracle with BLOB column in excel file.

BLOB file contains the Image (jpg)

View 5 Replies View Related

Forms :: How To Generate Excel File

Jun 12, 2012

I want to gerate the excel(Office 2010)file using oracle forms 6i. How we can achieve this with forms 6i?

View 4 Replies View Related

SQL & PL/SQL :: Create Report In Excel File?

Dec 22, 2010

I want to create a excel report by joining 2 tables.

Is there any stabdard package which i can use for creating this report.

View 3 Replies View Related

Forms :: How To Export Data In 10g To Excel File

Mar 15, 2011

I need the code to export the data from the form to the excel directly.

View 1 Replies View Related

Forms :: Uploading An Excel File Using Webutil In AIX

Apr 18, 2013

When i am uploading data in an excel file to my Forms(Windows) the screen works fine but when i am uploading the same excel file to my forms in AIX(Where the application is running) the data is uploaded with decimal points.

The field is a char type and no format mask is set.

E.g. :
Actual data: In Form(Windows) In Form (AIX)
4080026 4080026 4080026.0

View 5 Replies View Related

Forms :: Data Export To Excel File

Jul 14, 2009

i want to add one button in the form like "save as" and save the displayed data into excel file.

View 20 Replies View Related

SQL & PL/SQL :: Read Excel File Using UTL_FILE Package

Jul 23, 2010

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE 11.1.0.6.0 Production"

Is there a way to read Excel file using UTL_FILE package ?

Like our usual method:
l_utlfile := utl_file.fopen(p_dir, p_filename, 'R',2000);
p_filename is event.xls

Or do we need to convert that file to .csv or .txt ?

View 5 Replies View Related

Forms :: Uploading Excel File Using Webutil In AIX

May 28, 2013

When i am uploading data in an excel file to my Forms(Windows) the screen works fine . But when i am uploading the same excel file to my forms in AIX(Where the application is running) the data is wrongly uploaded . The field is a number type and no format mask is set.

E.g. :
Actual data:---------- In Form(Windows)------In Form (AIX)
3101513480750030000 3101513480750030000 3101513480750029800

I am using below code to copy the value

cell_value :=Client_OLE2.get_num_property(cell, 'Value');
COPY(cell_value,'data.field'||k);

View 3 Replies View Related

Forms :: OLE2 Updating Excel File From 6i

Dec 12, 2011

I am using OLE2 to update an excel spreadsheet from Oracle Forms 6i. If the excel spreadsheet is already open, the code runs through fine, and even asks if you want to replace the file when running the lines: OLE2.INVOKE(worksheet, 'Save');

OLE2.INVOKE(workbook, 'Save');

However, the file never gets updated. There is no error that appears. I would like to have the program check if the file is open before running the program;

View 1 Replies View Related

Forms :: Unable To Read Excel File?

Nov 1, 2011

I am trying to create excel file thru form....in form i create button Excel

WHEN -BUTTON - PRESSED :

Quote:
DECLARE
CURSOR C1 IS
SELECT DEPTNO,DNAME,LOC FROM DEPT;
filename varchAr2(256);

[Code].....

My excel file opened but it shows unable to read file

My excel version is 2003..

View 6 Replies View Related

PL/SQL :: Oracle Query Export Into Excel File

May 29, 2013

How can i automatically export oracle query result into the excel file in oracle?

View 2 Replies View Related

PL/SQL :: Generate Excel File And Send It As Attachment

Apr 10, 2013

I have a requirement to send email with attachment using PL/SQL procedure of 10g database. We will be querying data from database, generating excel(csv) file and attaching to email. How can I achieve this goal.

I have a procedure that will send email as HTML but it has limitations of sending 32K data.

CREATE OR REPLACE procedure send_email(
p_to            in varchar2,
p_from          in varchar2,
p_subject       in varchar2,
p_text          in varchar2 default null,
[code]........   

View 21 Replies View Related

Forms :: 10g - Upload And Download Excel File

Oct 29, 2010

I want to create a form in oracle 10 g . In this form i want download & upload any excel file.

View 2 Replies View Related

Heterogeneous Connectivity :: Configure HS For Excel File

Jul 19, 2012

I am trying to configure HS for Excel file. I am getting following error:

SQL> select table_name from all_tables@ODBCEXCEL;
select table_name from all_tables@ODBCEXCEL
*
ERROR at line 1:
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from ODBCEXCELHeres my setup:
[code]....

View 6 Replies View Related

Connect To Oracle DB And Write SQL Results Into Excel File

Sep 27, 2013

I would like to connect to oracle database and would like to execute series of SQLs and write those SQL results into Excel file (sheet1).

my requirement is simple :
------------------------
db_user_id scott
db_user_pwd tiger
db_sid orcl

select count(*) from emp;
select count(*) from dept;

print the same SQLs in A column and result should be in B column in excel file.

column A column B
select count(*) from emp; 14
select count(*) from dept; 4

thats it.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved