08-04-2016
not matching my requirement ,
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 SUSE
tracker-search
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)