Hi Guys !
I am new to unix and want to find out how we can make sql statement data to shell script variable?
Any help/suggestion is greatly appreciated
-Chandra (1 Reply)
Hi,
I'm quite new to scripting and I want to modify following line of an existing script:
MYVAR=`subst |grep 'L:\\\:' | sed -e 's/.*\\\//'`;
What I have to do is to use the content of a variable instead of the constant expression 'L:\\\:' as the grep string to be matched.
Assuming I already... (5 Replies)
Hi Friends...
Please assist me to assign the result of a SQL query that results two column, to two variables.
Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong..
#! /bin/sh
no='
sqlplus -s uname/password@DBname... (4 Replies)
Hi friends,
firstly, i can run following expression and i took 100 value.
sqlplus -s username/password@TTTEST @umt.sql
umt.sql exists "select t.deger from parametre t where t.id=30".
result of this query =100
i need to assign this value(100) to variable(for example x... (2 Replies)
I have the below script running for generating file from PL/SQL stored procedure. I need to declare a shell variable and then pass this to sqlplus command to pass the same as a INPUT parameter for the stored procedure. Please help to do this.
#!/bin/sh
minlimit=0
maxlimit=10
size=100
while... (0 Replies)
Hi,
I have the following command that lists all the .o files from all the directories except of vwin (which I don't want it)
for i in `ls -d */*.o|awk '$0 !~ "vwin"'`; do echo $i; done
The result is something like that
dir1/file1.o
dir1/file2.o
dir2/file3.o
etc.
So, I want to create a... (9 Replies)
Hello,
I have searched but failed to find what exactly im looking for,
I need to eliminate first "." in a output so i can use something like the following
echo "./abc/20141127" | nawk '{gsub("^.","");print}'
what i want is to use gsub result later on, how could i achieve it?
Let say... (4 Replies)
Hi
I am new to UNIX. I am trying the below and getting the error.
I am trying to assign the variable with the value of the query result. I want this value to use in the next steps.
Created UNIX file (Batch.sh) as below
#!/bin/ksh
sqlplus callidus/callidus4u@attstcal @Batch.sql
... (2 Replies)
I am reading lines from a file that contain a number sign (#) before a three or four digit number:
#1043
#677
I can remove the '#' and get just the number. However, I then want to assign that number to a variable and use it as part of a path further on in my program:
/mydir/10/1043 for... (5 Replies)
Discussion started by: KathyB148
5 Replies
LEARN ABOUT SUNOS
setcolor
setcolor(1F) FMLI Commands setcolor(1F)NAME
setcolor - redefine or create a color
SYNOPSIS
setcolor color red_level green_level blue_level
DESCRIPTION
The setcolor command takes four arguments: color, which must be a string naming the color; and the arguments red_level, green_level, and
blue_level, which must be integer values defining, respectively, the intensity of the red, green, and blue components of color. Intensi-
ties must be in the range of 0 to 1000. If you are redefining an existing color, you must use its current name (default color names are:
black, blue, green, cyan, red, magenta, yellow, and white). setcolor returns the color's name string.
EXAMPLES
Example 1: A sample output of setcolor command.
The following is an example of the arguments that setcolor takes:
`setcolor blue 100 24 300`
BUILT-IN FMLI
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO attributes(5)SunOS 5.10 5 Jul 1990 setcolor(1F)