Parallel Execution parameter; This is a session identifier of the
parallel coordinator
-----Original Message-----
From: sarojadevi
[mailto:oracledba-ezmlmshield-x29219233.[Email address protected]
Sent: 24 August 2006 16:05
To: LazyDBA Discussion
Subject: Qcsid??
Can anyone explain what is 'Qcsid' in v$px_session and how it is used??
Thanks,
Saroja Devi..
"Weston Stephen "
<oracledba-ezmlmshield-x19161158.[Email address protected]
08/24/2006 03:56 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: Query Needed
This will do it....
select decode(substr(DESCRIPTION,1,1),'"',null,substr(DESCRIPTION,1,1))
||substr(DESCRIPTION,2,length(DESCRIPTION)-2)
|| decode(substr(DESCRIPTION,-1),'"',null,substr(DESCRIPTION,-1)) from
errortext ;
Any solution will need to deal with, for example, ""This is a "valid"
example"" (ie two quotes together at start and/or end). If you want to
remove all " up to the first non-" and all " after the last non-" then
you can use ltrim(description,'"') and rtrim(description,'"').
My code above will translate ""This is a "valid" example"" into "This is
a "valid" example"
Using select ltrim(rtrim(DESCRIPTION,'"'),'"') from errortext ; will
give This is a "valid" example.
Regards
Stephen
-----Original Message-----
From: Pappas Dan
[mailto:oracledba-ezmlmshield-x47431930.[Email address protected]
Sent: 24 August 2006 15:30
To: LazyDBA Discussion
Subject: Query Needed
Hello All:
I have a DESCRIPTION column in a table (errortext). The DESCRIPTION
column is varchar2(120). I want to remove the " at the beginning of
each value and at the end of each value. The " is valid except for the
1st postion and the last (which is variable within the 120 postions).
For example, "This is a "valid" example" needs to be: This is a "valid"
example
Below is a sample of the values in this column. I have tried LTRIM,
TRIM, and some other things, but can't get it to work. So, I am hoping
someone on the board has got a query that the have created to do
something similar to my objective.
Thanks in advance
Dan
DESCRIPTION
------------------------------------------------------------
"savepoint '%s' never established"
"cannot start up ORACLE - currently logged on"
"cannot shut down ORACLE while active processes exist"
"immediate shutdown in progress - no operations are permitted"
"shutdown in progress - connection is not permitted"
"failure during startup force"
"ORACLE instance terminated. Disconnection forced"
"ALTER DATABASE CLOSE only permitted with no sessions connected"
"ALTER DATABASE CLOSE in progress. Connections not permitted"
"DML statement processed zero rows"
"program version (%s) incompatible with instance (%s)"
"cannot shutdown while in a transaction - commit or rollback first"
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
ForwardSourceID:NT00007122
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [Email address protected] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd unless otherwise expressly stated.
Oracle LazyDBA home page