12-21-2011
You can have a persistent connection if your shell implements coprocesses (ksh93, zsh and bash 4 support coprocesses).
If you need something like this though, most probably the shell is not the right choice (use PL/SQL, Perl or some other high level programming language).
Why do you want to fetch n records at a time? I'm just curious ...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Discussion started by: mogabr
4 Replies
2. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
3. Shell Programming and Scripting
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)
Discussion started by: sureshcisco
0 Replies
4. Shell Programming and Scripting
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)
Discussion started by: rkrish
1 Replies
5. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
6. Shell Programming and Scripting
I've been sent the following script to finish. It's supposed to connect to an oracle database, query it, and send an email if the query result value is one or more. Currently it isn't connecting properly, just giving the following error:
ERROR: ORA-01017: invalid username/password; logon denied... (2 Replies)
Discussion started by: jackmorgan2007
2 Replies
7. Shell Programming and Scripting
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)
Discussion started by: Kapom
2 Replies
8. Shell Programming and Scripting
Hi,
I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script.
The scenario is like....
Suppose I have a file abc.txt that has the card numbers..it could be in thousands..
then I need to fire a query like
... (12 Replies)
Discussion started by: vsachan
12 Replies
9. UNIX for Dummies Questions & Answers
Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies
10. Shell Programming and Scripting
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 OPENSOLARIS
builtin
builtin(1) User Commands builtin(1)
NAME
builtin - ksh93 built-in function to add, delete, or display shell built-ins
SYNOPSIS
builtin [-ds] [-f lib] [pathname ...]
DESCRIPTION
The ksh93 builtin command adds, deletes, or displays built-in commands in the current shell environment. A built-in command executes in the
current shell process and can have side effects in the current shell. On most systems, the invocation time for built-in commands is one or
two orders of magnitude less than commands that create a separate process.
For each pathname specified, the basename of the pathname determines the name of the built-in. For each basename, the shell looks for a C
level function in the current shell whose name is determined by pre-pending b_ to the built-in name. If pathname contains a forward slash
(/), the built-in is bound to pathname. A built-in bound to a pathname is only executed if pathname is the first executable found during a
path search. Otherwise, built-ins are found prior to performing the path search.
If pathname is not specified, builtin displays the current list of built-ins, or just the special built-ins if the -s option is specified,
on standard output. The full pathname for built-ins that are bound to pathnames are displayed.
Libraries containing built-ins can be specified with the -f option. If the library contains a function named lib_init(), this function is
invoked with argument 0 when the library is loaded. The lib_init() function can load built-ins by invoking an appropriate C level function.
In this case there is no restriction on the C level function name.
The C level function is invoked with three arguments. The first two are the same as main() and the third one is a pointer.
The ksh93 builtin command cannot be invoked from a restricted shell.
OPTIONS
The following options are supported:
-d Delete each of the specified built-ins. Special built-ins cannot be deleted.
-f lib On systems with dynamic linking, load and search for built-ins in the shared library, lib.
Libraries are searched for in $PATH and system dependent library directories. The system dependent shared library prefix or suf-
fix can be omitted. Once a library is loaded, its symbols become available for the current and subsequent invocations of builtin.
Multiple libraries can be specified with separate invocations of builtin. Libraries are searched in the reverse order in which
they are specified.
-s Display only the special built-ins.
OPERANDS
The following operands are supported:
pathname Specifies the pathname. The basename of the pathname determines the name of the built-in.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
>0 An error occurred.
EXAMPLES
Example 1 Loading a builtin Command
The following example loads a builtin command mycmd from the library libfoo.so:
example% builtin -f foo mycmd
AUTHORS
David Korn, dgk@research.att.com
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|Interface Stability |Uncommitted |
+-----------------------------+-----------------------------+
SEE ALSO
ksh93(1), whence(1), attributes(5)
SunOS 5.11 1 May 2007 builtin(1)