12-04-2007
concat strings
Hello,
I have a list of tablespaces in oracle and I want to concatenate 'drop tablespace' on the left of each line and 'INCLUDING CONTENTS AND DATAFILES' on the right of each line.
Any idea how to do that?
many thanks.
PS: I tried to use excel and copy/paste it to vi. But I noticed many \240 between strings
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
HI all,
How to concat two strings in Shell scrpits
suppose
x=a
y=b
i want to display it as
ab
How to do it ?
Thanks.. (1 Reply)
Discussion started by: dhananjaysk
1 Replies
2. Shell Programming and Scripting
hey,
I want to concat whole bunch of strings together but somehow they don't turn out the way I want them to
a="HELLO "
b="WORLD "
c=$a$b
I was expecting c to be "HELLO WORLD " but it... (1 Reply)
Discussion started by: mpang_
1 Replies
3. Shell Programming and Scripting
hi
I have a file, I need to concatenate depening on the no of columns i need to concatenate.
for example i need to concatenate field1,filed34,field2( no of columns is not always 3, it can be any number of fields)
concat.ksh field1 field34 field2
how to achieve this, is there any argv ,argc... (10 Replies)
Discussion started by: markjason
10 Replies
4. Solaris
Hi I am using solaris 10
#!/bin/ksh
today=`date`
GrepDate=`echo $today | awk '{print $1,$2,$3}'`
echo $GrepDate
output is "Mon Mar 8"
But i need to get output like "Mon Mar 8"(two spaces b/w Mar & 8)
Please help
Regards
Arun (6 Replies)
Discussion started by: annyarun
6 Replies
5. Shell Programming and Scripting
Hello Unix gurus,
how to concat 3 files content side by side .
i have 3 files
more report1.txt
select *from tab1 A JOIN tab1 B ON
more report2.txt
A.PK1=B.PK1 where
more report3.txt
A.AAA <> B.AAA or
A.BBB <> B.BBB or
A.CCC<> B.CCCC or
..
..
..
A.ZZZ <> B.ZZZ;
if i concatinate... (3 Replies)
Discussion started by: kanakaraju
3 Replies
6. Shell Programming and Scripting
Hi All,
My Input file contains:
Input.txt
Name|Marks
ABC|10
GHI|10
JKL|20
MNO|20
PQR|30
Output.txt
MARKS|NAME
10|ABC,GHI
20|JKL,MNO
30|PQR
Thanks in advance (4 Replies)
Discussion started by: kmsekhar
4 Replies
7. Shell Programming and Scripting
Hi Folks
The below is code is giving me value 30.
cal | sed '/^$/d' | tail -1 | awk '{printf $NF-1}'
Actually the text is like below.
echo "you should reply on 30-Jan-2013 evening EST.
Here how should i con-cat above logic in that text? (1 Reply)
Discussion started by: coolboy98699
1 Replies
8. Shell Programming and Scripting
Hello All,
I have a file with following data.
1365787116 3.0 contracts/Procs_Val_Req_forContrct_Amnd_BPEL
1348791394 2.0 contracts/Procs_Val_toTerm_Ret_Contrct_BPEL
1348791394 2.0 contracts/Qualfy_BP_forNew_Ret_Contrct_BPEL
1348791394 2.0 ... (8 Replies)
Discussion started by: Vikram_Tanwar12
8 Replies
9. Shell Programming and Scripting
Hello,
I have a very travial question....when i run the below script...how can i change my script that will give me an output pf "this is log_vp1" ....i dont want any spaces between log_vp and 1 or any other character...i know i can set a variable for 1(lets say num is the var) and then do... (2 Replies)
Discussion started by: crazy_max
2 Replies
10. Shell Programming and Scripting
Hi,
I need help to combine the first 7 character of firstname if it is longer than 7and combine with the first character of lastname.
ex: username lastname => usernaml
user lastname => userl
Thanks in advance. (10 Replies)
Discussion started by: xitrum
10 Replies
LEARN ABOUT SUSE
alter_tablespace
ALTER
TABLESPACE(7) SQL Commands ALTER TABLESPACE(7)
NAME
ALTER TABLESPACE - change the definition of a tablespace
SYNOPSIS
ALTER TABLESPACE name RENAME TO newname
ALTER TABLESPACE name OWNER TO newowner
DESCRIPTION
ALTER TABLESPACE changes the definition of a tablespace.
You must own the tablespace to use ALTER TABLESPACE. To alter the owner, you must also be a direct or indirect member of the new owning
role. (Note that superusers have these privileges automatically.)
PARAMETERS
name The name of an existing tablespace.
newname
The new name of the tablespace. The new name cannot begin with pg_, as such names are reserved for system tablespaces.
newowner
The new owner of the tablespace.
EXAMPLES
Rename tablespace index_space to fast_raid:
ALTER TABLESPACE index_space RENAME TO fast_raid;
Change the owner of tablespace index_space:
ALTER TABLESPACE index_space OWNER TO mary;
COMPATIBILITY
There is no ALTER TABLESPACE statement in the SQL standard.
SEE ALSO
CREATE TABLESPACE [create_tablespace(7)], DROP TABLESPACE [drop_tablespace(7)]
SQL - Language Statements 2010-05-14 ALTER TABLESPACE(7)