10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i am looking for a backup script to be run in ssh which can move all *.php files only to a archive
Eg. a folder has 5 sub folders with different file types, which can be mix of PDF, jpeg, gif etc etc.
but the archive generated should only include the *.php files without breaking the directory... (3 Replies)
Discussion started by: netatma
3 Replies
2. Shell Programming and Scripting
Hi All,
I need the variable to be set in both uppercase and lowercase in a single command
DATABASE=ORCL
something like the below which is absolutly wrong
find /ora/admin/11.1.0/diag/rdbms/{print tolower($0)}${DATABASE}/{print toupper($0)}${DATABASE}
The o/p should be as below:... (4 Replies)
Discussion started by: jjoy
4 Replies
3. Shell Programming and Scripting
I have the following file which at times can be quite large so can be difficult to read, I need a script that just extracts particular delimited data and outputs to alternate file
$cat fix1.log
FIX4.4|0=12|55=LIT.L|48=123456|32=5|52=20111107-10:52:22.128|38=100|10=200|
... (6 Replies)
Discussion started by: Buddyluv
6 Replies
4. Shell Programming and Scripting
Hi,
This is a vcd file.A vcd file may have 'n' modules.
1) I need to capture the data in bold,i.e. the module names (shown in bold)
2) Also i need to capture the data inside each individual module,say for tst_bench_top ,i need to capture data from line 4 to line 20 ...
I just want one... (2 Replies)
Discussion started by: veerabahu
2 Replies
5. Shell Programming and Scripting
Hello Unix Gurus :
It would be really appreciative if can find a solution for this .
I have records in a file .
I need to Capitalize the records based on condition .
For Example i tried the following Command
COMMAND -->
fgrep "2000YUYU" /export/home/oracle/TST/data.dat | tr '' ''... (12 Replies)
Discussion started by: tsbiju
12 Replies
6. Shell Programming and Scripting
Hello,
I have a text file which I need to check for presence of certain tags, and then copy a subsequent portion of text into another file. The tag matching canbe done with Grep but I do not know how to copy selective lines from one file to another. Is it possible do that?
I checked up some... (8 Replies)
Discussion started by: ajayram
8 Replies
7. Shell Programming and Scripting
Hi,
There's an xml file produced from a front-end tool as shown below:
<INPUT DATABASE ="ORACLE" DBNAME ="UNIX" NAME ="FACT_TABLE" OWNERNAME ="DIPS">
<INPUTFIELD DATATYPE ="double" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="STORE_KEY" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="15" SCALE... (6 Replies)
Discussion started by: dips_ag
6 Replies
8. UNIX for Dummies Questions & Answers
Hello,
I am using dircmp -d <folde1> <Folder2> to compare the files from two different foldes, but this command compares for all the files. Is there any option to select only some files for comparision. For example in
Folder1:
file1.txt
file2.txt
file3.txt
Folder2
file1.txt
file2.txt... (0 Replies)
Discussion started by: gmahesh2k
0 Replies
9. UNIX for Dummies Questions & Answers
Hello,
I have been trying all sorts of combinations and been royally screwing up my filesystem in the process :rolleyes: I have a bunch of .wav files in a hierarchical album/artist etc folder structure and each has a duplicate .w4a file next to it.
All I want to do is move all the .w4a... (7 Replies)
Discussion started by: dinalt
7 Replies
10. UNIX for Dummies Questions & Answers
How can convert a Lower case variable value to an upper case in the kron shell script. (3 Replies)
Discussion started by: dchalavadi
3 Replies
ALTER
CONVERSION(7) SQL Commands ALTER CONVERSION(7)
NAME
ALTER CONVERSION - change the definition of a conversion
SYNOPSIS
ALTER CONVERSION name RENAME TO newname
ALTER CONVERSION name OWNER TO newowner
DESCRIPTION
ALTER CONVERSION changes the definition of a conversion.
You must own the conversion to use ALTER CONVERSION. To alter the owner, you must also be a direct or indirect member of the new owning
role, and that role must have CREATE privilege on the conversion's schema. (These restrictions enforce that altering the owner doesn't do
anything you couldn't do by dropping and recreating the conversion. However, a superuser can alter ownership of any conversion anyway.)
PARAMETERS
name The name (optionally schema-qualified) of an existing conversion.
newname
The new name of the conversion.
newowner
The new owner of the conversion.
EXAMPLES
To rename the conversion iso_8859_1_to_utf8 to latin1_to_unicode:
ALTER CONVERSION iso_8859_1_to_utf8 RENAME TO latin1_to_unicode;
To change the owner of the conversion iso_8859_1_to_utf8 to joe:
ALTER CONVERSION iso_8859_1_to_utf8 OWNER TO joe;
COMPATIBILITY
There is no ALTER CONVERSION statement in the SQL standard.
SEE ALSO
CREATE CONVERSION [create_conversion(7)], DROP CONVERSION [drop_conversion(7)]
SQL - Language Statements 2010-05-14 ALTER CONVERSION(7)