Since your "in list" could be more than 1,000 items, You could use a 'external table' and just join the external table to the target table(s) so that you only retrieve matching card numbers, example:
Code:
-- Create oracle external table linked to a flat file
create table user.table (
card_num varchar2( 16 ) )
organization external (
type oracle_loader
default directory TMP
access parameters (
records delimited by newline
badfile 'card_numbers.bad'
discardfile 'card_numbers.dis'
logfile 'card_numbers.log'
missing field values are null
( card_num ) )
location('card_numbers.txt') )
Thanks for your suggestion Spacebar....
but I can not touch the database...So we need to only use shell script.
i have this basic piece of code that i am trying to debug to accept input parameter to be able to display a directory listing of files.
cd /u02/app/eatv/dev/out
CURDIR=`pwd`
echo directory listing of $CURDIR
echo
if ; then
ls -latr
else
ls -latr $1
fi
basically if the script... (9 Replies)
Hi,
I need a script that will run a dynamic Oracle SQL. Dynamic meaning the SQL statement depends on the parameter.
For instance, something like this:
#!/bin/ksh -x
# Set environment
. /home/mine/set_vars
sqlplus $LOGINID <<! >> /home/mine/log.txt
select count(1) from $1
where... (2 Replies)
Hello,
If I run this command on the server it works.
# dbc "update config set radio_enabled = 0;"
how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line.
#!/usr/bin/perl
#database path
$dbc='/opt/bin/psql -Userver... (0 Replies)
Hello,
I have this shell script that runs awk code by passing in parameters however now it doesn't work anymore with the parameters and I don't know why.
It removes duplicates from an input file based on a part of the last field and a key column. It removes the record with the older datetime... (0 Replies)
Hello,
When listing the file systems (using ls -ltr) , if the group names are longer the group name is getting truncated.
Can someone help with the script which would display the truncated group name?
I appreciate if someone could help in this regard. (3 Replies)
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies
LEARN ABOUT PLAN9
font
FONT(6) Games Manual FONT(6)NAME
font, subfont - external format for fonts and subfonts
SYNOPSIS
#include <libg.h>
DESCRIPTION
Fonts and subfonts are described in cachechars(2).
External fonts are described by a plain text file that can be read using rdfontfile. The format of the file is a header followed by any
number of subfont range specifications. The header contains two numbers: the height and the ascent, both in pixels. The height is the
inter-line spacing and the ascent is the distance from the top of the line to the baseline. These numbers are chosen to display consis-
tently all the subfonts of the font. A subfont range specification contains two or three numbers and a file name. The numbers are the
inclusive range of characters covered by the subfont, with an optional starting position within the subfont, and the file name names an
external file suitable for rdsubfontfile. The minimum number of a covered range is mapped to the specified starting position (default
zero) of the corresponding subfont. If the subfont file name does not begin with a slash, it is taken relative to the directory containing
the font file. Each field must be followed by some white space. Each numeric field may be C-format decimal, octal, or hexadecimal.
External subfonts are represented in a more rigid format that can be read and written using rdsubfontfile and wrsubfontfile (see subfal-
loc(2)). The format for subfont files is: a bitmap containing character images, followed by a subfont header, followed by character infor-
mation. The bitmap has the format for external bitmap files described in bitmap(6). The subfont header has 3 decimal strings: n, height,
and ascent. Each number is right-justified and blank padded in 11 characters, followed by a blank. The character info consists of n+1
6-byte entries, each giving the Fontchar x (2 bytes, low order byte first), top, bottom, left, and width. The x field of the last Fontchar
is used to calculate the bitmap width of the previous character; the other fields in the last Fontchar are irrelevant.
Note that the convention of using the character with value zero (NUL) to represent characters of zero width (see bitblt(2)) means that
fonts should have, as their zeroth character, one with non-zero width.
FILES
/lib/font/bit/*
font directories
SEE ALSO graphics(2), bitblt(2), cachechars(2), subfalloc(2)FONT(6)
05-28-2013
