hi fellows,
can any body tell me how to pass unix variables to oracle
code is...
#! /bin/ksh
echo ENTER DATE VALUE's
read START_DATE END_DATE
sqlplus xyx/abc@oracle
select * from table1 where coloumn1 between $START_DATE and $END_DATE;
is this is correct way...........
Thanks in... (1 Reply)
Hi,
I want to input unix variable to sqlplus.The following is working fine
sqlplus username/password @dummy.sql param1 param2 << EOF
create user $1 identified by $2;
EOF
But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that??
Thanks... (3 Replies)
Hi,
I am writing a script which creates an external table using a shell script. My requirement is like this.
Usage: . ./r.ksh <table_name> - this should create an external table.
e.g . ./r.ksh abc - this should create an external table as abc_external.
How do i achieve this? Please... (5 Replies)
hiiiiiiiiii
this is shyam.i have written a code that it will take the process id of any process and using it print the value of pcpu etc but the problem is it prints
the same value every time it is in loop the code for this is given below.
while true
do
y=`ps... (2 Replies)
I have a array as
CArray=( a1 a2 )
and a1,a2,a3 are also array as:
a1=(1 2 3)
a2=(3 4 5)
now I have this in my code:
for i in `echo "${CArray}"`
do
echo ${$i}
done
It is giving error as :"bad substitution"
It should give me value as
1 2 3
3 4 5
how can I get this...Can u please... (2 Replies)
sqlplus -s $USER_ID@$SID/$PWD<<EOF>sql_1.txt
set feedback off
set heading off
select 114032 as c_1 from dual ;
EOF
for i in `cat sql_1.txt`
do
sh script_1.sh $i
Currently i am passing one column value to the single unix variable.
How can i pass the values from 2... (2 Replies)
Hello,
Through the process of a executing a shell script, I extract the values for a number of variables (arbitrarily declared as a through i) and towards the end I print them out like shown below:
#!bin/sh
# bits of code to get values for the variables
......
......
# print the values... (4 Replies)
hi guys
i have a sqlplus :
sqlplus -s username/password << EOF
@mysql.sql
EOF
in mysql.sql there is a count of a table, i want to write in a variabile unix.
how can i do?
Thanks a lot
Regards
Francesco. (3 Replies)
Discussion started by: Francesco_IT
3 Replies
LEARN ABOUT CENTOS
gsbj
GSLP(1) Ghostscript GSLP(1)NAME
gslp - Format and print text using ghostscript
gsbj - Format and print text for BubbleJet printer using ghostscript
gsdj - Format and print text for DeskJet printer using ghostscript
gsdj500 - Format and print text for DeskJet 500 BubbleJet using ghostscript
gslj - Format and print text for LaserJet printer using ghostscript
SYNOPSIS
gslp -12BclqRr -b<header> -f<font> -F<hfont> -L<lines> -p<outfile> -T<n> --add-to-space <units> --add-to-width <units> --columns <n>
--detect --first-page <n> --kern <file.afm> --last-page <n> --(heading|footing)-(left|center|right) <string> --margin-(top|bot-
tom|left|right) <inches> --no-eject-(file|formfeed) --spacing <n> [gs options] [files]
gsbj [options] [files]
gsdj [options] [files]
gsdj500 [options] [files]
gslj [options] [files]
DESCRIPTION
This utility provides functionality approximately equivalent to the Unix enscript(1) program. It prints plain text files using a single
font. It currently handles tabs and formfeeds, but not backspaces. It will line-wrap when using fixed-pitch fonts. It will also do kern-
ing and width adjustment.
The default device (-sDEVICE=) and resolution (-r) are as follows:
gslp epson 180
gsbj bj10e 180
gsdj deskjet 300
gsdj500 djet500 300
gslj laserjet 300
By default the current date is formatted as the center header.
OPTIONS
Standard switches implemented:
-12BclqRr -b<header> -f<font> -F<hfont> -L<lines> -p<outfile>
Sun switches implemented:
-T<n> set tab width
Switches ignored:
-GghKkmow -# -C -d -J -n -P -S -s -t -v
Switches added:
--add-to-space <units>
add the given number of 1/72" units to the width of each space (may be negative)
--add-to-width <units>
add the given number of 1/72" units to the width of each character (may be negative)
--columns <n>
print in <n> columns
--detect
treat the file as PostScript if it starts with %!
--first-page <n>
start printing at page <n>
--kern <file.afm>
kern using information from the given .AFM file
--last-page <n>
stop printing after page <n>
--(heading|footing)-(left|center|right) <string>
set the heading/footing fields; use -B first to clear
--margin-(top|bottom|left|right) <inches>
set a margin
--no-eject-(file|formfeed)
end-of-file/FF only starts a new column, not a new sheet
--spacing <n>
use double (n=2), triple (n=3), etc. spacing
Also, the string %# in a heading or footing is replaced with the page #.
SEE ALSO gs(1)VERSION
This document was last revised for Ghostscript version 9.07.
AUTHOR
Artifex Software, Inc. are the primary maintainers of Ghostscript. This manpage by George Ferguson.
9.07 12 February 2013 GSLP(1)