Sponsored Content
Full Discussion: Setting Col size
Top Forums Shell Programming and Scripting Setting Col size Post 60440 by yerra on Monday 17th of January 2005 11:48:59 AM
Old 01-17-2005
Setting Col size

I have a variable in a shell script which is more than 80 characters.
1) I log into SQL plus and populate a variable using 3 queries appended by ,' comma'.
ORAINFO=`sqlplus -s << !
/ as sysdba
set feedback off
set heading off
select LOG_MODE ||','||(select substr(VALUE,instr(VALUE,'=')+1) from V\\$PARAMETER where NAME='log_archive_dest_1')
||','||(select max(BYTES) from V\\$LOG ||','||(select VALUE from V\\$PARAMETER where NAME='background_dump_dest')
from V\\$DATABASE;
exit
!`

2) It gives a value ArchiveLOG,46464545434,/u05/app/oracle/product/8.1.6/admin/FCCLIVE/bdump. However it displays a space after FCCLIVE/, so effectively it becomes FCCLIVE/ bdump instead of FCCLIVE/dump.


Request your help;...
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

setting max log file size...

Hello all! I have found a new home, this place is great! I have been searching for days to find a way to set a max size for a log.txt file using a cron job exicuting a shell script. Is it possible for a script to remove older entries in a log file to maintain a limited file size? If so,... (5 Replies)
Discussion started by: v-rod
5 Replies

2. UNIX for Advanced & Expert Users

Help On col command

Hello Can Any1 tell me the difference between the col command and the col command with the -f option. I tried running both of them but i can't see any difference. Please guide me. (1 Reply)
Discussion started by: rahulrathod
1 Replies

3. UNIX for Dummies Questions & Answers

Info about col command

Hello every1. Can any1 help me with the col command. Wat is a reverse line feed. Which kind of files u need to use the col command. (2 Replies)
Discussion started by: rahulrathod
2 Replies

4. Solaris

File size setting

There is a file in my Unix Server whose size will be constant. But every day when the sheduled jobs run in the server, that file gets updated but the size does not change. Upon doing file filename It is dispalyed as a binary file. Can anyone please explain how that file is created. How is... (3 Replies)
Discussion started by: exterminator
3 Replies

5. AIX

setting default PP size

Does anyone know how to set PP (Physical Partition) size on rootvg when installing AIX OS from scratch (via CD or NIM installation)? (7 Replies)
Discussion started by: pdtak
7 Replies

6. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Hello, I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file. For example: File 1 has 1411 rows, I ignore how many columns it has (thousands) File 2 has 311 rows, 1 column Would like to... (7 Replies)
Discussion started by: sogi
7 Replies

7. Shell Programming and Scripting

i can't cut the third col

SW_dist_intr false Enable SW distribution of interrupts True autorestart true Automatically REBOOT OS after a crash True boottype disk N/A False capacity_inc 1.00 ... (7 Replies)
Discussion started by: maxim42
7 Replies

8. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

9. Shell Programming and Scripting

Printing from col x to end of line, except last col

Hello, I have some tab delimited data and I need to move the last col. I could hard code it, awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile but it would be nice to know the syntax to print a range cols. I know in cut you can do, cut -f 1,4-8,11- to print fields 1,... (8 Replies)
Discussion started by: LMHmedchem
8 Replies

10. Shell Programming and Scripting

Modifying col values based on another col

Hi, Please help with this. I have several excel files (with and .xlsx format) with 10-15 columns each. They all have the same type of data but the columns are not ordered in the same way. Here is a 3 column example. What I want to do add the alphabet from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies
GIT-FMT-MERGE-MSG(1)						    Git Manual						      GIT-FMT-MERGE-MSG(1)

NAME
git-fmt-merge-msg - Produce a merge commit message SYNOPSIS
git fmt-merge-msg [-m <message>] [--log[=<n>] | --no-log] <$GIT_DIR/FETCH_HEAD git fmt-merge-msg [-m <message>] [--log[=<n>] | --no-log] -F <file> DESCRIPTION
Takes the list of merged objects on stdin and produces a suitable commit message to be used for the merge commit, usually to be passed as the <merge-message> argument of git merge. This command is intended mostly for internal use by scripts automatically invoking git merge. OPTIONS
--log[=<n>] In addition to branch names, populate the log message with one-line descriptions from the actual commits that are being merged. At most <n> commits from each merge parent will be used (20 if <n> is omitted). This overrides the merge.log configuration variable. --no-log Do not list one-line descriptions from the actual commits being merged. --[no-]summary Synonyms to --log and --no-log; these are deprecated and will be removed in the future. -m <message>, --message <message> Use <message> instead of the branch names for the first line of the log message. For use with --log. -F <file>, --file <file> Take the list of merged objects from <file> instead of stdin. CONFIGURATION
merge.branchdesc In addition to branch names, populate the log message with the branch description text associated with them. Defaults to false. merge.log In addition to branch names, populate the log message with at most the specified number of one-line descriptions from the actual commits that are being merged. Defaults to false, and true is a synonym for 20. merge.summary Synonym to merge.log; this is deprecated and will be removed in the future. SEE ALSO
git-merge(1) GIT
Part of the git(1) suite Git 1.8.5.3 01/14/2014 GIT-FMT-MERGE-MSG(1)
All times are GMT -4. The time now is 10:23 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy