Sponsored Content
Top Forums Shell Programming and Scripting Compare a content of variable to a database column Post 302398084 by barani75 on Tuesday 23rd of February 2010 10:10:43 PM
Old 02-23-2010
oracle database

its oracle database.
yes i want to check the table field contains the cahracter or may be a value.

thanks.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Compare the content of a variable with a string

Hello all: I'm new in Unix and here and I'am spanish so my english isn't so good to explain my doubt. Here it is. Very urgent: I need to compare the value of a variable with a string. Example is this. Imagine that the variable x1 contains the path and a file text and I need to compare... (2 Replies)
Discussion started by: robdai
2 Replies

2. Shell Programming and Scripting

Change file content 4 column to one Column using script

Hi Gurus, I have file content sample: ,5113955056,,TAgent-Suspend ,5119418233,,TAgent-Suspend ,5102119078,,TAgent-Suspend filenames 120229H5_suspend, 120229H6_unsuspend I receive those files one of directory /home/temp/ I need following: 1. Backup first /home/temp/ file to... (5 Replies)
Discussion started by: thepurple
5 Replies

3. Shell Programming and Scripting

awk arrays - compare value in second column to variable

Hello, I am trying to redirect files to a directory by using a config file. The config files is as such: xxxxxx,ID,PathToDirectory xxxxxx,ID2,PathToDirectory2 and so on... I have a variable that should match one of these IDs. I want to load this config file into an awk array, and... (2 Replies)
Discussion started by: jrfiol
2 Replies

4. Shell Programming and Scripting

Take values from a column and put it in a variable and compare

Hi, I have a table in unix from which i want to read the contents line by line, then filter out the values from 6th column one by one and compare it a fixed value. How to do this? (7 Replies)
Discussion started by: arijitsaha
7 Replies

5. Shell Programming and Scripting

Problem in sending mail with database content

Hi All, I want to fetch records from Oracle DB table and send it in a mail to a set of users. i.e, I have a query which returns a set of records. I want to send mail with below content: Hi , PFB the details: <first database record> <Second database record> ……………. ………………..... (3 Replies)
Discussion started by: anil029
3 Replies

6. Shell Programming and Scripting

Pass column number as variable to awk and compare with a string.

Hi All, I have a file test.txt. Content of test.txt : 1 vinay se 2 kumar sse 4 kishore tl I am extracting the content of file with below command. awk '$2 ~ "vinay" {print $0}' test.txt Now instead of hardcoding $2 is there any way pass $2 as variable and compare with a... (7 Replies)
Discussion started by: Girish19
7 Replies

7. UNIX for Dummies Questions & Answers

Compare data - Match first column and compare second

Hi guys, looking for some help with a way to compare data in two files but with some conditions. example, File 1 consists of site1,10.1.1.1 site2,20.2.2.2 site3,30.3.3.3 File 2 contains site1,l0.1.1.1 site2,50.1.1.1 site3,30.3.3.3 site4,40.1.1.1 I want to be able to match the... (1 Reply)
Discussion started by: mutley2202
1 Replies

8. Shell Programming and Scripting

Help with compare 2 column content and corrected/replaced word

Input File CGGCGCCTCGCNNNCGAGCG CGGCGCGCCGAATCCGTGCG TCGCNGC GCGCCGC ACGGCNNNNN ACGGCCTCGCG CGGCNGCCCGCCC CGGCGCGCCGTCC Desired Output File CGGCGCCTCGCNNNCGAGCG CGGCGCGCCGAATCCGTGCG CGGCGCCTCGCATCCGAGCG TCGCNGC GCGCCGC TCGCCGC ACGGCNNNNN ACGGCCTCGCG ACGGCTCGCG... (6 Replies)
Discussion started by: perl_beginner
6 Replies

9. Shell Programming and Scripting

Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche

Example: I have files in below format file 1: zxc,133,joe@example.com cst,222,xyz@example1.com File 2 Contains: hxd hcd jws zxc cst File 1 has 50000 lines and file 2 has around 30000 lines : Expected Output has to be : hxd hcd jws (5 Replies)
Discussion started by: TestPractice
5 Replies

10. UNIX for Beginners Questions & Answers

UNIX script to compare 3rd column value with first column and display

Hello Team, My source data (INput) is like below EPIC1 router EPIC2 Targetdefinition Exp1 Expres rtr1 Router SQL SrcQual Exp1 Expres rtr1 Router EPIC1 Targetdefinition My output like SQL SrcQual Exp1 Expres Exp1 Expres rtr1 Router rtr1 Router EPIC1 Targetdefinition... (5 Replies)
Discussion started by: sekhar.lsb
5 Replies
elmalias(1)						      General Commands Manual						       elmalias(1)

NAME
elmalias - display and verify elm user and system aliases SYNOPSIS
format[alias-name-list] Remarks The former functionality of the command has been taken over by the command (see newalias(1)). DESCRIPTION
The command displays and verifies user and system aliases. The system database must have been created by the command (see newalias(1)). The user database must have been created by either the com- mand or the mail system (see elm(1)). If the same alias is in both databases, the user version is used. Missing database files are silently ignored. Each database entry can have the following fields, which are described in detail in newalias(1): alias-list A list of one or more aliases for the entry. address-list A list of one or more addresses for the entry. An address can be an alias from another entry's alias-list. comment An optional field containing information about the entry. This field is not included in outbound mail. firstname An optional field interpreted as the first name of the person or group. It is used in fullname. lastname An optional field interpreted as the last name of the person or group. It is used in fullname. fullname A combination value made up from the firstname and lastname fields, in the form: firstname lastname. recognizes three types of alias names: A database entry that has one address in address-list. assumes this address is a valid mailing address. A database entry that has two or more addresses in address-list. assumes initially that these addresses are aliases to or entries. An address in a entry or an alias in alias-name-list that is not an alias in the database. In both cases, the item is reported as both the alias name and its address. With no options or operands, displays the address-list field for each alias in the two databases. If an entry has more than one alias, the address-list field is displayed multiple times. With an alias-name-list and no options, displays the address-list field of each alias name in the list. If an alias name is not found in the databases, it is treated as without comment. Options recognizes the following options: Change the display to alias name followed by address-list field. Turn debugging on. Fully expand aliases. This option can be used only when an alias-name-list is given. If an address in a address list is an alias name, it is replaced by that alias entry. The process is recursive until the results are either or types. If a address is not an alias name, it is reported as both the alias name and the address, with type Duplicate alias names are reported only once. entries are not expanded, even if their addresses are actually aliases. Display the format string for each alias name in the file or in the alias-name-list. The following character pairs are replaced in the format by the corresponding value for each alias. The alias name. The comment field. The lastname field. The fullname value. The alias type: or The address-list field. Change the display to address-list followed by fullname, if any, in parentheses. Report an error if a name in alias-name-list does not correspond to an alias in the database. Display a message for each unknown name and exit with a nonzero status. Use the system alias database only, unless is also specified. Use the user alias database only, unless is also specified. Use a verbose output format. Change the display to alias name, followed by address-list, followed by fullname, if any, in parentheses. Use a very verbose, multiline output format with the following titles, corresponding to the format codes of the option. If a field is empty, the title is omitted. EXIT STATUS
sets the following exit status values: Normal completion. An error occurred. You may have specified: o An invalid option. o The option without an alias-name-list. o The option without a format. o The option with an unknown alias name in alias-name-list. EXAMPLES
Consider a user database that contains the following entries: Since and do not refer to alias entries, they are typed as with no options or operands produces the following output. produces the alias names, address, and full name, as follows: To expand a set of aliases and format them with field titles, use the and options, as in the following command: producing: AUTHOR
was developed by HP. FILES
User alias database data table User alias database directory table User alias database hash table User alias source text System alias database data table System alias database directory table System alias database hash table System alias source text SEE ALSO
elm(1), newalias(1). elmalias(1)
All times are GMT -4. The time now is 12:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy