Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: how to put quotes ina .sql file
Top Forums UNIX for Advanced & Expert Users how to put quotes ina .sql file Post 302120872 by agarwalniru on Friday 8th of June 2007 09:32:15 PM
Old 06-08-2007
Quote:
Originally Posted by porter
How are you composing the file?

If you edit the file on the UNIX box with vi does the problem go away?

thats the whole problem......i m trying to edit it via Vi editor on unix and it doesnt let me edit.
so i making the changes ona notepad and FTP on unix....it still gives special characters in place of quotes
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

put double quotes for a column

Hi, I have a file which looks like this, I have stripped most of the columns: 2006,UCA,"02452","NM","1","M","84",123,aa 2006,UCA,"02452","NM","1","L","84",123,bb 2006,UCA,"02452","NM","1","L","84",432,cc 2006,UCA,"02452","NM","1","L","33",213,dd 2006,UCA,"02452","NM","1","L","33",124,ee... (3 Replies)
Discussion started by: sumeet
3 Replies

2. Shell Programming and Scripting

Retreive content between specific lines ina file

Hi I have a text file which has two sets of lines repeating for "n" number of times.Some data is printed between the two lines.I want to retrieve all the data thats there in between those two set of lines.I have the string value of those two set of lines. To be much more clearer ... (4 Replies)
Discussion started by: chennaitomcruis
4 Replies

3. Shell Programming and Scripting

Replacing the last data of each line ina file

Hi, I ahve a file where the format is as given below: qqq dfsf gdfjkg gjdosjg jkflsjd 21 fdksdlf fsdnkfl lkdfsgjld 45 laefsdl fsdlfksl fsdklflk gfsdl 56 I need to replace the last number by space or delete the last number in each line. (by using... (6 Replies)
Discussion started by: jisha
6 Replies

4. Shell Programming and Scripting

put value of multiple sql statements into unix variables

i want to use multple sql count statements and store these count values in unix variable but in one connection only i.e. in only 1 time database should be hit ,which is the main requirement. (1 Reply)
Discussion started by: sw@pnil
1 Replies

5. Shell Programming and Scripting

How can i use single quotes for SQL command in shell script

Hi. please help me to write the following query in a shell script. the Query is :select no,salary from emp_info where name='$var_name' the following is my code. #! /bin/sh var_name=$1 sqlplus -s user/pwd@DB << EOF select no,salary from emp_info where name="'$var_name'";... (4 Replies)
Discussion started by: little_wonder
4 Replies

6. Programming

How to put variable date from SQL Script

Hi Guys, Can someone please help me on adding/inserting a variable to an sql scipt? Basically I want to assign today's date. As shown below.. set head off; set linesize 300; set pagesize 200; spool /opt/oracle/temp/output.txt select value,count(*) as totalcount from pmowner.pinpebasev... (11 Replies)
Discussion started by: pinpe
11 Replies

7. Programming

Macro to put single quotes around character

Dear Mates, I am trying to write a macro to replace with its arguments with singles quotes around each argument. #define DECR(a,b,c,d,e) decr('a','b','c','d','e') if the usage is DECR(k,e,y,s,\0) I want it to be replaced with the following decr('k','e','y','s','\0') However it... (2 Replies)
Discussion started by: tamil.pamaran
2 Replies

8. Shell Programming and Scripting

Put double quotes around numbers

Hi, consider a file which has data such as "random text",912345,"54","finish" "random text",9991236745,"9954","finish" I want to replace the numbers that don't have double quotes around them with ones that do; so the output should be "random text","912345","54","finish" "random... (4 Replies)
Discussion started by: Storms
4 Replies

9. Shell Programming and Scripting

Issue with quotes when running SQL command from within su -c

RHEL 6.2/Bash shell root user will be executing the below script. It switches to oracle user logs in using sqlplus and tries to run the below UPDATE statement. All the commands after su -c are enclosed in a single quote delimited by semicolon. The execution has failed because the quotes... (3 Replies)
Discussion started by: omega3
3 Replies

10. Shell Programming and Scripting

Remove pipe(|) symbol ina file, except the ones which are enclosed in double quotes

I have file with are delimited by pipe(|) symbol, I wanted those to be removed except the ones which are enclosed in double quotes. If your quote file is: |Life is |Beautiful"|"Indeed life |is beautiful too|"|"But unix is fun| is not"|" It should return: Life is Beautiful"|"Indeed life is... (1 Reply)
Discussion started by: Sathyapts
1 Replies

LEARN ABOUT XFREE86

edit-patch

EDIT-PATCH(1)						      General Commands Manual						     EDIT-PATCH(1)

NAME

       edit-patch, add-patch - tool for preparing patches for Debian source packages

SYNOPSIS

       edit-patch path/to/patch

       add-patch path/to/patch

DESCRIPTION

       edit-patch is a wrapper script around the Quilt, CDBS, and dpatch patch systems. It simplifies the process of preparing and editing patches
       to Debian source packages and allows the user to not have to be concerned with which patch system is in use.   Run  from  inside  the  root
       directory of the source package, edit-patch can be used to edit existing patches located in debian/patches.

       It can also be used to incorporate new patches.	If pointed at a patch not already present, it will copy the patch to debian/patches in the
       correct format for the patch system in use.  Next, the patch is applied and a subshell is opened in order to edit the patch.   Typing  exit
       or pressing Ctrl-d will close the subshell and launch an editor to record the debian/changelog entry.

       edit-patch  is  integrated  with  the  Bazaar  and Git version control systems.	The patch will be automatically added to the tree, and the
       debian/changelog entry will be used as the commit message.

       If no patch system is present, the patch is applied inline, and a copy is stored in debian/patches-applied.

       add-patch is the non-interactive version of edit-patch.	The patch will be incorporated but no editor or subshell will be spawned.

AUTHORS

       edit-patch was written by Daniel Holbach <daniel.holbach@canonical.com>,  Michael  Vogt	<michael.vogt@canonical.com>,  and  David  Futcher
       <bobbo@ubuntu.com>.

       This manual page was written by Andrew Starr-Bochicchio <a.starr.b@gmail.com>.

       Both are released under the terms of the GNU General Public License, version 3.

DEBIAN
								 Debian Utilities						     EDIT-PATCH(1)
All times are GMT -4. The time now is 11:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy