Forming Matrix Of Data Using PL/SQL

May 15, 2013

I've got a requirement for building a 5000 X 5000 matrix using PL/SQL. My original data tables have 5000 rows each and I need to do a correlation analysis using this data and need to store in a physical table and not in-memory. Is this feat achievable using mere PL/SQL? I understand that Oracle DB has a limitation of 1000 columns(but not sure) and hence I'd like to know whether there is any work-around for such scenarios. If not, what are the other alternative method(s) to achieve this feat? Do I need to use any 3rd party tools to get this done?

View 3 Replies


ADVERTISEMENT

PL/SQL :: Forming Number Type List In A Cursor?

Jul 12, 2013

we use oracle 11g. 11.2. I have a situation where in a pl-sql package, there is a modification needs to be done . Every User is associated with destination codes. For eg, user1==>0101,0104  There is a  destination_number and country field in the table1.Each of the destination number is associated with a country code and this combination is unique. for eg: 

dest_code   country_code 0101 CHINA 0202 UK 0101 Mexico 0104   Mexico 

For example, if user1 logs in to the system, then pl sql logic will look if that dest_code is in a table1,If the dest_code is present in the table1, then that dest_code number wont be added to the dest_code list formed for that user. For example,if user1 got dest_codes  0101,0104  associated with him.IF 0101 is in exception table then 0101 and 0104wont be used to form dest_code list. If NOT, a dest_code list will formed like 0101||0104. I am able to form the logic like I have a cursor that loops for each dest_code.For each dest_code , it will get that dest_code  into v_dest_code_no number type variable. open cursor fetch dest_code  no into v_dest_code  v_dummy number:=0;v_dest_code_list number:=0; LOOP v_dest_code_list:=v_dest_code ||v_dest_code ;  v_dest_code :=0; END LOOP:  How to make sure that for each dest_code set, if one of them is in table1, then the next number also will not be added to the list.

View 1 Replies View Related

SQL & PL/SQL :: Convert Data Into Matrix Report?

Nov 4, 2011

I have the following data.

COURSE_SEQ_NO INSTRUCTOR_ID SE SEMESTER_CODE SEMESTER_YEAR QNO ANS ANS_COUNT
------------- ------------- -- ------------- ------------- ---------- --- ----------
74 10225 A 3 2011 1 E 3
74 10225 A 3 2011 1 VG 1
74 10225 A 3 2011 2 E 3
74 10225 A 3 2011 2 VG 1

[code]....

How can I convert it into matrix report like below

QNO E VG
1 3 1
2 3 1
3 3 1
. . .
. . .
. . .
17 3 1

View 5 Replies View Related

Reports & Discoverer :: Matrix Report Cell If No Data Then Display (A)

Apr 7, 2011

Report 6i. I created Matrix Report . it is working fine.

I would like to know that it is possible If Matrix Report Cell do not have data then display any words like 'A'\

View 1 Replies View Related

SQL & PL/SQL :: Matrix Query

Oct 24, 2010

i want to write a query in the below format

score days days days
0-20 20-40 40-60

0-200 * * *
200-400 * * *
400-above * * *

* --> no: of matches

test_1 and test_2 are two tables , and in test_1, "score" and "matchno:" are columns and in test_2, "days" is column. in score values are 0 to 1000 and in days values are 0-100

View 3 Replies View Related

SQL & PL/SQL :: Showing Rows As A Matrix

Sep 15, 2010

I want a sql query to transform my output..Also number of rows are not limited

Current Output

Col_A
1
2
3
4
5
6
7
8
9
10

however i need data as

COL_A COL_BCOL_C COL_D
1 2 3 4
5 6 7 8

View 6 Replies View Related

SQL & PL/SQL :: All Types Of Matrix Report With PDF

Jan 23, 2011

Send all type of matrix report with examples.

View 1 Replies View Related

PL/SQL :: Matrix Type Report

Aug 15, 2012

Writing a query based on this data:

Each row is based on a row of a student.

Grade stands for the school grade, K=> Kindergarten

Tabl is a table the student is assigned to.

Bev stands for beverage, 1c=> White Milk , 2c=> Chocolate Milk, 3c => Orange Juice.

GRADE      TABL      BEV
K      1      1c
K      2      3c
K      3      1c
K      4      3c
K      1      1c
K      2      2c
K      3      3c

I need to generate a summary report that looks like this:

Grade/Tabl           White              Chocolate              Orange
K-1                   2                   
K-2                                           1                    1
K-3                   1                                            1
K4                                                                 1

Is there a way in which I can write a query to display this type of matrix report.

View 4 Replies View Related

Forms :: Matrix Form In Oracle

May 20, 2013

Is there any possibilities to make matrix form just like matrix report.

one is the month column which increase horizontally other is emp_name column which increase vertically and sal column which show the salary of each employee in each month.

View 1 Replies View Related

Dynamic Matrix Format In Sql / Plsql

Dec 14, 2012

how can i display the out in matrx format.

example;

select country_code
, item_number
, sum(quantity)
FROM item_table it

[Code]...

output format:

--------- country_code1 country_code2 country_code3 country_code4
item1 10 77 99 87
item2 30 67 56 76
item3 35 45 66 66
item4 50 33 56 67

FOR my case PIVOT_ won't work. I am using 10g database.

View 1 Replies View Related

Reports & Discoverer :: Matrix Report With 2 Column?

May 7, 2010

I want to create matrix report with 2 column

we can assign one column in matrix report my req is to assign 2 column .

example
Row Is FND
columns are Cdate & Ldate
Cells are Crate & Lrate

CDATE CDATE CDATE CDATE LDATE LDATE LDATE
FND 01-MAR 02-MAR 03-MAR 04 MAR 28-FEB 31-JAN 31-DEC
-------------------------------------
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
ABC CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE
XYZ CRATE CRATE CRATE CRATE LRATE LRATE LRATE

View 1 Replies View Related

Reports & Discoverer :: How To Display Matrix Report

Dec 22, 2010

I am using oracle Dev 10g R2 in windows Xp. I have a matrix report and it will produce result correctly as the attachment1. Now I want to display this report as a same format. I would like to display 0 for those that does not exist in the query.

View 2 Replies View Related

JDeveloper, Java & XML :: Matrix Report Creation

Feb 3, 2012

I have Developed the Normal Reports. This is the First time I have to Develop the Matrix Report in XML Format. The Attached file Contain the XML File.

View 5 Replies View Related

Reports & Discoverer :: Convert Matrix Report Into XLS

Nov 5, 2011

i have convert many report's in xls, but that report's are not group field's

but this report is group by field, so the data can not be fitted in correct position

View 1 Replies View Related

Reports & Discoverer :: Fake Columns In Matrix?

Aug 17, 2011

I have done a matrix group report which displays the department codes as columns and main account as rows for a month my problem is there are two groups and in one group there is data for 5 departments and in other group there is data for 4 departments and in display if there is no data for one department it should come as fixed columns in order to make it more readable

.Is there any way where i can fake some null data and bring it as column or any other way.

View 5 Replies View Related

How To Create Cross-tab / Matrix Style Output In Forms

Sep 16, 2011

I am essentially trying to reproduce an extremely complex spread-sheet with an engineering mathematical model in it and that has been in use for 5 years now. The Excel spreadsheet was a good environment for tuning the model, but now I have been asked to design an Oracle Form that incorporates their mathematical model and shows their final and intermediate data so they can validate my app against their proven spreadsheet.

To do that I have to create a matrix style table for use as a child data-block in my Oracle Form.

View 4 Replies View Related

Reports & Discoverer :: Order In Matrix Report Column

May 20, 2010

I have to set a matrix report as follow:

- in the rows the machine_id.
- in the column the material_lib.

Table material ( material_id,material_lib,ordre)
- in the cells quantity.

I get successfully my matrix through the wizard of report, but i should display the columns sorted with the field ordre.

how to get the columns of the matrix sorted.

View 5 Replies View Related

Reports & Discoverer :: Order Matrix By Cell Content?

May 30, 2013

I have a matrix report that shows production per year(horizontal) and per country(vertical). The customer's willing to see the data ordered by production, and not per country. I tried to add a CF containing the production in the country group and order by that one, but I'm getting a message saying that the field object cannot be contained into the frame. Both the field and the containing frame are set to Variable. how to get rid of the error or how to achieve the main goal of ordering by the cell content?

View 11 Replies View Related

Reports & Discoverer :: Matrix Report And NULL Values

Feb 25, 2011

I want to Fix Null values as 0 in Matrix Report. But i am not able to Do it...

let it be there is one item NUM1

what Sequencing and triggers(format trigger or else) should i follow on it with what code?

View 2 Replies View Related

Sort Ascending Or Descending Of Last Total Column Of Matrix Report R6i

Nov 3, 2010

How can I Sort Ascending or Descending of Last Total Column of Matrix Report R6i i.e. F_SumsalPerempno, summing total salary of each empno at end of each row.

I need the employee paid highest amount of total salary during the year to appear on first row, while months to display as per original order.

View 2 Replies View Related

Reports & Discoverer :: Show 1 Record Per Page In Matrix Report?

Nov 11, 2010

I want to show 1 record per page in matrix report. I set Main section orientation as landscape and width is 14. but it show multiple records on single page.

View 2 Replies View Related

Reports & Discoverer :: Ordering Columns And Rows In A Matrix Report

Jun 20, 2012

I am having a matrix report, which has its column cells from table A and row cells from table B when I run the report the columns and rows are not ordered I wrote the order by statement in the report query but there was no defference.

I also wrot a subquery like

select column1, column2, (select column3 from table1 order by code)
from .... but it seems I can not order in a subquery

Is there any way to do that

View 5 Replies View Related

Reports & Discoverer :: Matrix Report For Showing Calendar Events

Feb 8, 2012

I have to create the matrix report which shows calender. Looks Like this.

View 14 Replies View Related

Reports & Discoverer :: Develop A Simple Matrix Report Manually

Nov 3, 2010

I have developed simple matrix report using wizard. But now I want to do it manually.

View 3 Replies View Related

Reports & Discoverer :: Rotate Text Inside Matrix Cell?

Jul 28, 2010

how could i rotate the text inside a matrix cell ??like

.......c....c....c
.......o....o....o
........l.....l.....l
.......#....#....#
.......1....2....3
----------------------
row#1
.......
row#2
.......
row#3

View 7 Replies View Related

Reports & Discoverer :: How To Generate Matrix Report To Excel File

Aug 22, 2007

how to generate matrix report to excel file. i have done this . but the exact layout is not getting displayed in the excel file. I have attache the layout i ma trying to export to excel.

View 8 Replies View Related

Reports & Discoverer :: REP-1813 / Object F_2 Too Large To Fit In Matrix Cell

Jan 1, 2011

I got this error when try to run a matrix report

REP-1813 :Object F_2 too large to fit in matrix cell

how can i deal with this.N.B the report was working fine with no problems and suddenly happened this.

View 1 Replies View Related

Reports & Discoverer :: MATRIX Report / Bold Value With Highest Value In Numeric Field?

Nov 11, 2010

I want to Bold the value with highest value in Numeric field. how can i do this.

View 12 Replies View Related

Reports & Discoverer :: Oracle 10g Report Printing On Line Matrix Printer?

Apr 15, 2011

1) I am able to view the oracle report in PDF format in my Web Application, but when I tried to print this PDF on Line matrix printer, the characters are not printing rightly.

2) Can I take report output as a text file and and print it through DOS mode printing.

View 2 Replies View Related

Reports & Discoverer :: Select Weeks Number Per Months And Year As 1 To 52 On Matrix Report 6i?

Aug 27, 2010

wanna to make matrix report retrieve months year and the number of weeks from dual table it supposes to the weeks number is 52 or 53 week months and weeks on the rows please find attach pic it show what i need to do for exmple

month name: January February March April May June July August September Nov October December
no of week : 1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-20-21-22....... TO 52 week

View 5 Replies View Related







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