Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How do I include "$" in a string
Top Forums Shell Programming and Scripting How do I include "$" in a string Post 302075940 by beilstwh on Wednesday 7th of June 2006 04:49:36 PM
Old 06-07-2006
How do I include "$" in a string
I have the following code.

Code:
sqlString="CREATE USER $1 IDENTIFIED BY $3
           DEFAULT TABLESPACE TEMPTABS
           TEMPORARY TABLESPACE TEMPSEGS
           QUOTA UNLIMITED ON TEMPTABS
           PROFILE DEFAULT
           ACCOUNT UNLOCK;

           GRANT xxxxxx_ROLE TO $1;
           ALTER USER $1 DEFAULT ROLE xxxxxx_ROLE;

           CREATE USER $2 IDENTIFIED EXTERNALLY
           DEFAULT TABLESPACE TEMPTABS
           TEMPORARY TABLESPACE TEMPSEGS
           QUOTA UNLIMITED ON TEMPTABS
           PROFILE DEFAULT
           ACCOUNT UNLOCK;

           GRANT xxxxxx_ROLE TO $2;
           GRANT yyyyyy_ROLE TO $2;
           ALTER USER $2 DEFAULT ROLE xxxxxx_ROLE,yyyyyy_ROLE;
           
           exit;"

           echo "$sqlString" > $APP_HOME/test/EMPMC.$$

sqlplus system/xxxxx @$APP_HOME/test/EMPMC.$$

rm $APP_HOME/test/EMPMC.$$

when I invoke the script test.sh APPLE OPS$APPLE PEAR

I get an error message that the APPLE variable is not defined. How do I pass the argument without unix interperting the "$APPLE" as a variable.

Any help would be appreciated. I should know this, but it has been a while since I did scripting.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

input string="3MMTQSZ348GGMZRQWMJM4SD6M";output string="3MMTQ-SZ348-GGMZR-QWMJM-4SD6

input string="3MMTQSZ348GGMZRQWMJM4SD6M" output string="3MMTQ-SZ348-GGMZR-QWMJM-4SD6M" using linux shell script (4 Replies)
Discussion started by: pankajd
4 Replies

2. Shell Programming and Scripting

Compare file names and select correct elements to include in "for each loop"

Hi everyone, I`ll try to be most clear I can explaining my help request. I have 2 folders Folder A-->This folder receives files through FTP constantly Folder B-->The files from Folder A are unzipped and then processed in Folder B Sometimes Folder A doesn`t contain all... (2 Replies)
Discussion started by: cgkmal
2 Replies

3. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

4. Shell Programming and Scripting

Using sed to find text between a "string " and character ","

Hello everyone Sorry I have to add another sed question. I am searching a log file and need only the first 2 occurances of text which comes after (note the space) "string " and before a ",". I have tried sed -n 's/.*string \(*\),.*/\1/p' filewith some, but limited success. This gives out all... (10 Replies)
Discussion started by: haggismn
10 Replies

5. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz (8 Replies)
Discussion started by: timmywong
8 Replies

6. Shell Programming and Scripting

AWK "make a new column that include increasing numbers"

please help!!!!!! I have a file .txt that has only one column like that: 34.1 35.5 35.6 45.6 ... Now, i want to add a column in the left in which the values of this column increase by 0.4 , for example: 0.0 34.1 0.4 35.5 0.8 35.6 1.2 45.6 How can i do with awk instructions??? ... (2 Replies)
Discussion started by: tienete
2 Replies

7. Shell Programming and Scripting

tcsh - understanding difference between "echo string" and "echo string > /dev/stdout"

I came across and unexpected behavior with redirections in tcsh. I know, csh is not best for redirections, but I'd like to understand what is happening here. I have following script (called out_to_streams.csh): #!/bin/tcsh -f echo Redirected to STDOUT > /dev/stdout echo Redirected to... (2 Replies)
Discussion started by: marcink
2 Replies

8. Emergency UNIX and Linux Support

Accidentally Changed File Ownership to Include a "Comment" [AIX]

Hi. I've had a little mishap. To cut a long story short, I've accidentally recursively ran chown on a directory (actually a bunch of 'em). Not a problem in itself, but I had a slight error in the code I used to get the list of directories and ended up with a comment in the file ownership. ... (15 Replies)
Discussion started by: Scott
15 Replies

9. Shell Programming and Scripting

grep with "[" and "]" and "dot" within the search string

Hello. Following recommendations for one of my threads, this is working perfectly : #!/bin/bash CNT=$( grep -c -e "some text 1" -e "some text 2" -e "some text 3" "/tmp/log_file.txt" ) Now I need a grep success for some thing like : #!/bin/bash CNT=$( grep -c -e "some text_1... (4 Replies)
Discussion started by: jcdole
4 Replies

10. Shell Programming and Scripting

Delete all log files older than 10 day and whose first string of the first line is "MSH" or "<?xml"

Dear Ladies & Gents, I have a requirement to delete all the log files in /var/log/test directory that are older than 10 days and their first line begin with "MSH" or "<?xml" or "FHS". I've put together the following BASH script, but it's erroring out: for filename in $(find /var/log/test... (2 Replies)
Discussion started by: Hiroshi
2 Replies

LEARN ABOUT OSX

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