Sponsored Content
Homework and Emergencies Homework & Coursework Questions Help with pivoting table shell script Post 302978811 by senmatrix on Thursday 4th of August 2016 08:16:36 AM
Old 08-04-2016
not matching my requirement ,
 

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... (13 Replies)
Discussion started by: luiscarvalheiro
13 Replies

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. (2 Replies)
Discussion started by: ankitgupta
2 Replies

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... (3 Replies)
Discussion started by: shilpa_acc
3 Replies

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... (2 Replies)
Discussion started by: gunaah
2 Replies

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 Replies)
Discussion started by: Poonamol
6 Replies

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 (2 Replies)
Discussion started by: ken002
2 Replies

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... (9 Replies)
Discussion started by: ksatish89
9 Replies

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... (3 Replies)
Discussion started by: scruffytramp
3 Replies

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 ... (3 Replies)
Discussion started by: mohan705
3 Replies

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. @@@@@@@@@@ ... (7 Replies)
Discussion started by: arunpvp
7 Replies
tracker-search(1)						   User Commands						 tracker-search(1)

NAME
tracker-search - Search all content for keywords SYNOPSIS
tracker-search [OPTION...] EXPRESSION [EXPRESSION...] DESCRIPTION
tracker-search searches all indexed content for EXPRESSION. The resource in which EXPRESSION matches must exist (see --all for more infor- mation). All results are returned in ascending order. In all cases, if no EXPRESSION is given for an argument (like --folders for example) then ALL items in that category are returned instead. EXPRESSION One or more terms to search. The default operation is a logical AND. For logical OR operations, see -r. OPTIONS
-?, --help Give a short help message. -l, --limit=N Limit search to N results. The default is 512. -o, --offset=N Offset the search results by N. For example, start at item number 10 in the results. The default is 0. -r, --or-operator Use OR for search terms instead of AND (the default) -d, --detailed Show the unique URN associated with each search result. This does not apply to --music-albums and --music-artists. -a, --all Show results which might not be available. This might bebecause a removable media is not mounted for example. Without this option, resources are only shown if they exist. This option applies to all command line switches except --music-albums and --music-artists. -f, --files=EXPRESSION Search for files of any type matching EXPRESSION (optional). -e, --folders=EXPRESSION Search for folders matching EXPRESSION (optional). -m, --music=EXPRESSION Search for music files matching EXPRESSION (optional). --music-albums=ALBUM Search for music albums matching ALBUM (optional). --music-artists=ARTIST Search for music artists matching ARTIST (optional). -l, --images=EXPRESSION Search for images matching EXPRESSION (optional). -v, --videos=EXPRESSION Search for videos matching EXPRESSION (optional). -t, --documents=EXPRESSION Search for documents matching EXPRESSION (optional). -e, --emails=EXPRESSION Search for emails matching EXPRESSION (optional). Returns a list of subjects for emails found. -c, --contacts=EXPRESSION Search for contacts matching EXPRESSION (optional). Returns a list of names and email addresses found. -V, --version Print version. SEE ALSO
tracker-store(1), tracker-stats(1), tracker-tag(1), tracker-info(1). GNU
July 2009 tracker-search(1)
All times are GMT -4. The time now is 02:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy