Sponsored Content
Top Forums Programming Quote character Unix to Oracle Post 302514254 by DGPickett on Friday 15th of April 2011 08:59:49 AM
Old 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

Error : no closing quote in unix

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

Capturing Data between first quote and next quote

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

Oracle Password having special character

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

Regex in grep to match all lines ending with a double quote (") OR a single quote (')

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

replacing a quote in some lines with multiple quote fields

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 a single quote character in AWK

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

How to match character with single quote?

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

Removing unnecessary eol ($) character from Oracle sql query output

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

Replacing Double Quote in Double Quote incsv file

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

Replacing all but the first and last double quote in a line with a single quote with awk

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
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)
All times are GMT -4. The time now is 08:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy