08-04-2016
Have you searched the entire site for the word "pivot" using the "Search" pull down menu?
I guess not, because there are umpteen solutions on the theme.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear all:
I want to write a script capable of reading specific rows and collumns of a table, into a variable.
Just imagine i have a file named table.dat which contains:
GENERAL INFORMATION
Col 1 Col2 Col3
1 1
2 2
3 3
4 4
What i want to do... (13 Replies)
Discussion started by: luiscarvalheiro
13 Replies
2. Shell Programming and Scripting
I want to add some columns to a existing tables through a shell script.
Please help. (2 Replies)
Discussion started by: ankitgupta
2 Replies
3. Shell Programming and Scripting
Hi All,
I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking.
Something like this, through... (3 Replies)
Discussion started by: shilpa_acc
3 Replies
4. Shell Programming and Scripting
I am trying to truncate a table using below script. When I ran the script it runs fine but table was not truncated and the spool is empty. I am not sure what is wrong with pl/sql block.
#!/bin/ksh
# ----------------------------------------------------------------------
#
# Created by: XXXX... (2 Replies)
Discussion started by: gunaah
2 Replies
5. Shell Programming and Scripting
Hi,
Can anyone tell me that, How to create table in Oracle database through shell script(ksh).
Table contains 3 fields,
1] Emp ID, String, primary key
2] Name, String
3] B Date, date.
Thanks in advance. (6 Replies)
Discussion started by: Poonamol
6 Replies
6. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
7. Shell Programming and Scripting
Here is the contents of an input file.
A,1,2,3,4
10,aaa,bbb,ccc,ddd
11,eee,fff,ggg,hhh
12,iii,jjj,lll,mmm
13,nnn,ooo,ppp
I wanted the output to be
A
10 1 aaa
10 2 bbb
10 3 ccc
10 4 ddd
11 1 eee
11 2 fff
11 3 ggg
11 4 hhh .....
and so on How to do it in ksh... (9 Replies)
Discussion started by: ksatish89
9 Replies
8. Shell Programming and Scripting
Hi,
i need a bit help. I must write a script with shell- and sed-commands, which reads a table from stdin and writes a html-table on stdout (so i can open it with a web browser). The number of columns must be a parameter for the script, so i can start it for example with: "./htmltab.sh 3... (3 Replies)
Discussion started by: scruffytramp
3 Replies
9. Shell Programming and Scripting
Hi ,
Please any one help using shell scripts achieve the below output(pivoting on top_cd i mean type code values will come as individual columns and fixed amount is value for that .Any help would be greate
tx_id tx_amt typ_cd fixed_dis_amt
100 200 mc ... (3 Replies)
Discussion started by: mohan705
3 Replies
10. Shell Programming and Scripting
Hi,
I'm an amateur and need your help in figuring this out. I have been asked to connect to a prod db from non-prod env., and download a table from prod db to non-prod env.
I was able to connect to the prod db and then run a simple query as below.
@@@@@@@@@@
... (7 Replies)
Discussion started by: arunpvp
7 Replies
LEARN ABOUT REDHAT
zgetf2
ZGETF2(l) ) ZGETF2(l)
NAME
ZGETF2 - compute an LU factorization of a general m-by-n matrix A using partial pivoting with row interchanges
SYNOPSIS
SUBROUTINE ZGETF2( M, N, A, LDA, IPIV, INFO )
INTEGER INFO, LDA, M, N
INTEGER IPIV( * )
COMPLEX*16 A( LDA, * )
PURPOSE
ZGETF2 computes an LU factorization of a general m-by-n matrix A using partial pivoting with row interchanges. The factorization has the
form
A = P * L * U
where P is a permutation matrix, L is lower triangular with unit diagonal elements (lower trapezoidal if m > n), and U is upper triangular
(upper trapezoidal if m < n).
This is the right-looking Level 2 BLAS version of the algorithm.
ARGUMENTS
M (input) INTEGER
The number of rows of the matrix A. M >= 0.
N (input) INTEGER
The number of columns of the matrix A. N >= 0.
A (input/output) COMPLEX*16 array, dimension (LDA,N)
On entry, the m by n matrix to be factored. On exit, the factors L and U from the factorization A = P*L*U; the unit diagonal ele-
ments of L are not stored.
LDA (input) INTEGER
The leading dimension of the array A. LDA >= max(1,M).
IPIV (output) INTEGER array, dimension (min(M,N))
The pivot indices; for 1 <= i <= min(M,N), row i of the matrix was interchanged with row IPIV(i).
INFO (output) INTEGER
= 0: successful exit
< 0: if INFO = -k, the k-th argument had an illegal value
> 0: if INFO = k, U(k,k) is exactly zero. The factorization has been completed, but the factor U is exactly singular, and division
by zero will occur if it is used to solve a system of equations.
LAPACK version 3.0 15 June 2000 ZGETF2(l)