Help with pivoting table shell script Post: 302978814

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading a table in a shell script

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...

2. Shell Programming and Scripting

Alter Table Shell Script

I want to add some columns to a existing tables through a shell script. Please help.

3. Shell Programming and Scripting

To update a column in a table through shell script

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...

4. Shell Programming and Scripting

Truncating table from a shell script

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...

5. Shell Programming and Scripting

Create DB table through shell script

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. Shell Programming and Scripting

Shell script to query Oracle table

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

7. Shell Programming and Scripting

Transposing rows and columns (pivoting) using shell 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...

8. Shell Programming and Scripting

Shell Script Table

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...

9. Shell Programming and Scripting

Pivoting using shell scripts

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 ...

10. Shell Programming and Scripting

Download a db table through UNIX shell script

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. @@@@@@@@@@ ...

LEARN ABOUT OSX

ppi::token::quotelike

PPI::Token::QuoteLike(3)				User Contributed Perl Documentation				  PPI::Token::QuoteLike(3)

NAME

       PPI::Token::QuoteLike - Quote-like operator abstract base class

INHERITANCE

	 PPI::Token::QuoteLike
	 isa PPI::Token
	     isa PPI::Element

DESCRIPTION

       The "PPI::Token::QuoteLike" class is never instantiated, and simply provides a common abstract base class for the five quote-like operator
       classes. In PPI, a "quote-like" is the set of quote-like things that exclude the string quotes and regular expressions.

       The subclasses of "PPI::Token::QuoteLike" are:

       qw{} - PPI::Token::QuoteLike::Words
       `` - PPI::Token::QuoteLike::Backtick
       qx{} - PPI::Token::QuoteLike::Command
       qr// - PPI::Token::QuoteLike::Regexp
       <FOO> - PPI::Token::QuoteLike::Readline

       The names are hopefully obvious enough not to have to explain what each class is. See their pages for more details.

       You may note that the backtick and command quote-like are treated separately, even though they do the same thing. This is intentional, as
       the inherit from and are processed by two different parts of the PPI's quote engine.

SUPPORT

       See the support section in the main module.

AUTHOR

       Adam Kennedy <adamk@cpan.org>

COPYRIGHT

       Copyright 2001 - 2011 Adam Kennedy.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

       The full text of the license can be found in the LICENSE file included with this module.

perl v5.16.2							    2011-02-25						  PPI::Token::QuoteLike(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading a table in a shell script

Discussion started by: luiscarvalheiro

2. Shell Programming and Scripting

Alter Table Shell Script

Discussion started by: ankitgupta

3. Shell Programming and Scripting

To update a column in a table through shell script

Discussion started by: shilpa_acc

4. Shell Programming and Scripting

Truncating table from a shell script

Discussion started by: gunaah