04-15-2011
Remember that in SQL, string literals are in ' and " is, by default, to making reserved words not recognized, like a column alias AS "Table". Sometimes, session or RDBMS options can make " work as an alternate to ' in matched pairs for string literals. Now, your PERL string literals are in ", so you have to escape any " in there. If you Oracle string data is presented using ', you need to escape any ' in there. Escapes are usually \ or doubling. You did not give a release, is this applicable:
quoting string literals in 10g
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hey
I was stuck in middle of writing this script Can any one help me out of this
I am writing this script to delete the log files certain days old
and everything fine but when I run the script I always see error at the bottom
./PurgeOneParameter.ksh: no closing quote
and for the last if... (4 Replies)
Discussion started by: pinky
4 Replies
2. Shell Programming and Scripting
I have input file like
RDBMS FALIURE UTY8703 'USER_WORK.TEST' .HIghest return code '12'
I want to parse data which comed between first quote till next quote
USER_WORK.TEST
can you please suggest how to do that (4 Replies)
Discussion started by: scorp_rahul23
4 Replies
3. UNIX for Dummies Questions & Answers
Hi
I am trying to connect to oracle using shell script with username/pwd@constring
The password is having special character . I have to ignore the special character else i am getting invalid username or password. How to achieve that
My password is having $ , but the... (5 Replies)
Discussion started by: ssuresh1999
5 Replies
4. Shell Programming and Scripting
Hi,
I've been trying to write a regex to use in egrep (in a shell script) that'll fetch the names of all the files that match a particular pattern. I expect to match the following line in a file:
Name = "abc"
The regex I'm using to match the same is:
egrep -l '(^) *= *" ** *"$' /PATH_TO_SEARCH... (6 Replies)
Discussion started by: NanJ
6 Replies
5. Shell Programming and Scripting
i want to replace mistaken quotes in line starting with tag 300 and relocate the quote in the correct position so the input is
223;25
224;20100428064823;1;0;0;0;0;0;0;0;8;1;3;9697;18744;;;;;;;;;;;;
300;X;Event:... (3 Replies)
Discussion started by: wradwan
3 Replies
6. Shell Programming and Scripting
How do you print out a single quote character in AWK? Using the escape character does not seem to work.
{printf "%1$s %2$s%3$s%2$s\n" , "INCLUDE", " \' ", "THIS" }
does not work. Any suggestions? (6 Replies)
Discussion started by: cold_Que
6 Replies
7. Shell Programming and Scripting
I need to check whether first character of variable is single quote.
I tried the below constructions but they are all not working (always return true)
if (test `echo "$REGEXP" |cut -c1` != "'"); then echo "TRUE"; fi
if (test `echo "$REGEXP" |cut -c1` != '\''); then echo "TRUE"; fi
if (test... (5 Replies)
Discussion started by: urello
5 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I am fetching oracle query result in shell variable. As columns numbers are more the output wraps in unix terminal .i.e one complete record in db gets store in multiple lines. with each line ends with $ character. I want to remove these unnecessary $ character but to keep required $... (8 Replies)
Discussion started by: Harshal22
8 Replies
9. Shell Programming and Scripting
Hi All ,
We have source data file as csv file and since data could contain commas ,each attribute is quoted into double quotes.However problem is that some of the attributa data also contain double quotes which is converted to double double quote while creating csv file
XLs data :
... (2 Replies)
Discussion started by: Shalini Badal
2 Replies
10. Shell Programming and Scripting
From:
1,2,3,4,5,This is a test
6,7,8,9,0,"This, is a test"
1,9,2,8,3,"This is a ""test"""
4,7,3,1,8,""""
To:
1,2,3,4,5,This is a test
6,7,8,9,0,"This; is a test"
1,9,2,8,3,"This is a ''test''"
4,7,3,1,8,"''"Is there an easy syntax I'm overlooking? There will always be an odd number... (5 Replies)
Discussion started by: Michael Stora
5 Replies
LEARN ABOUT HPUX
mrmfetchsetvalues
MrmFetchSetValues(library call) MrmFetchSetValues(library call)
NAME
MrmFetchSetValues -- Fetches the values to be set from literals stored in UID files
SYNOPSIS
#include <Mrm/MrmPublic.h>
Cardinal MrmFetchSetValues(
MrmHierarchy hierarchy_id,
Widget widget,
ArgList args,
Cardinal num_args);
DESCRIPTION
The MrmFetchSetValues function is similar to XtSetValues, except that the values to be set are defined by the UIL named values that are
stored in the UID hierarchy. MrmFetchSetValues fetches the values to be set from literals stored in UID files.
hierarchy_id
Specifies the ID of the UID hierarchy that contains the specified literal. The value of hierarchy_id was returned in a previous
call to MrmOpenHierarchyPerDisplay.
widget Specifies the widget that is modified.
args Specifies an argument list that identifies the widget arguments to be modified as well as the index (UIL name) of the literal
that defines the value for that argument. The name part of each argument (args[n].name) must begin with the string XmN followed
by the name that uniquely identifies this attribute tag. For example, XmNwidth is the attribute name associated with the core
argument width. The value part (args[n].value) must be a string that gives the index (UIL name) of the literal. You must define
all literals in UIL as exported values.
num_args Specifies the number of entries in args.
This function sets the values on a widget, evaluating the values as public literal resource references resolvable from a UID hierarchy.
Each literal is fetched from the hierarchy, and its value is modified and converted as required. This value is then placed in the argument
list and used as the actual value for an XtSetValues call. MrmFetchSetValues allows a widget to be modified after creation using UID file
values the same way creation values are used in MrmFetchWidget.
As in MrmFetchWidget, each argument whose value can be evaluated from the UID hierarchy is set in the widget. Values that are not found or
values in which conversion errors occur are not modified.
Each entry in the argument list identifies an argument to be modified in the widget. The name part identifies the tag, which begins with
XmN. The value part must be a string whose value is the index of the literal. Thus, the following code would modify the label resource of
the widget to have the value of the literal accessed by the index OK_button_label in the hierarchy:
args[n].name = XmNlabel;
args[n].value = "OK_button_label";
RETURN VALUE
This function returns one of the following status return constants:
MrmSUCCESS
The function executed successfully.
MrmPARTIAL_SUCCESS
At least one literal was successfully fetched.
MrmBAD_HIERARCHY
The hierarchy ID was invalid.
MrmFAILURE
The function failed.
RELATED
MrmOpenHierarchyPerDisplay(3), XtSetValues(3).
MrmFetchSetValues(library call)