Looking for any advise from a DBA/DA. When should you use CHAR and when should you use VARCHAR when designing a table. From my readings seems like VARCHAR will accept any length string even though you define a length to it, so I setup gadget VARCHAR(10) I could actually put something with 20... (1 Reply)
Hi ,
I need to sort a file based on multiple columns All the columns are of varchar type
can any one give me the command to sort for varchar columns?
Thanks (3 Replies)
Hi
I have a file in the following format:
4135 f4135acc: 39798 rmtdb: 0 /t1/data/f4135acc.dta
4135 f4135pdb: 39795 rmtdb: 0 /bb/data/f4135pdb.dta
4135 p4135eng: 0 rmtdb: 0 /bb/bin/p4135eng
4135 r4135eng: 14142 rmtdb: 0 ... (6 Replies)
hi , i am very new to perl . scriptting.. pllease can any one help me ...pleaseeeeeee
i ll have a file which look likes
123 |something |567
456 |welcome |789
457 |inboxpost |790
.
.
123 |something |567
i have to execute all the lines in the file except the first and the... (14 Replies)
I am familiar with using tar and exclude/include files:
tar zcf backup.dirs.tgz --files-from=include.mydirs --exclude-from=exclude.mydirs --no-recursion
but was wondering if I could use find in the same way. I know that you can just specify the directories to exclude but my list is... (2 Replies)
Hi Gurus.
I have a directory and i receive many files with extension .log. I processed the file as i get it. i want to process all the files except one which i know i don't want to process.
cd /backup/temp/rajesh/PACS #--- directory , under this i have below files... (1 Reply)
hi,
i am trying to use a exclude file to exclude some file directories while making a tar archive. This is my command:
tar -pcvf orahome10gR2.tar.gz db_1 -X /home/oracle/excludeFile.txt /home/oracle/
when i execute it, it seem to be tar-ing. But once is done, i cd to /home/oracle and could... (2 Replies)
Hello,
I have a list of patterns which I'd like to exclude from a file. I tried to do
while read line
do
grep -v $line file >> new.file
done < mylist
But obviously it won't work. It only works for just grep. I know I can do:
grep -Ev 'pattern1|pattern2|...' myfile
but my... (7 Replies)
Hello everyone,
I try to find folders older than 3 years and display them, but excluding some directories, the below code does NOT exclude listed directories:
find . -maxdepth 3 -mtime +1095 -type d -exec ls -l {} \; | grep -vFf oldExclude >> older
oldExclude
Folder1/
Folder2/... (7 Replies)
Discussion started by: Abu Rayane
7 Replies
LEARN ABOUT XFREE86
zgrep
ZGREP(1) General Commands Manual ZGREP(1)NAME
zgrep - search possibly compressed files for a regular expression
SYNOPSIS
zgrep [ grep_options ] [ -e ] pattern filename...
DESCRIPTION
Zgrep invokes grep on compressed or gzipped files. These grep options will cause zgrep to terminate with an error code:
(-[drRzZ]|--di*|--exc*|--inc*|--rec*|--nu*). All other options specified are passed directly to grep. If no file is specified, then the
standard input is decompressed if necessary and fed to grep. Otherwise the given files are uncompressed if necessary and fed to grep.
If the GREP environment variable is set, zgrep uses it as the grep program to be invoked.
EXIT CODE
2 - An option that is not supported was specified.
AUTHOR
Charles Levert (charles@comm.polymtl.ca)
SEE ALSO grep(1), gzexe(1), gzip(1), zdiff(1), zforce(1), zmore(1), znew(1)ZGREP(1)