04-10-2019
Could you share the returned result of the sqlplus using code tags, please.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
My requirement is :
We are calling an sql statement from a UNIX session, and fetching data into some variables from a table .. now we are unable to access these variables from outside the SQL part. Please let me know how can I achieve this.
Can you please share a code snippet which... (4 Replies)
Discussion started by: venkatesh_sasi
4 Replies
2. Shell Programming and Scripting
i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated.
my sql query provide output some thing like this -
col1 col2 count
---- ---- ------
A B 10
c D 6
e... (8 Replies)
Discussion started by: pharos467
8 Replies
3. Shell Programming and Scripting
Hi,
I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning.
success records to success.log file
failure record to failure.log file.
As of now i am doing like... (1 Reply)
Discussion started by: sailaja_80
1 Replies
4. UNIX for Advanced & Expert Users
Hello Guys,
This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help.
Here is my script-
#! /bin/ksh
export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2
/opt/oracle/app/oracle/product/9.2/bin/sqlplus -s... (5 Replies)
Discussion started by: thepurple
5 Replies
5. Shell Programming and Scripting
Hi
I want ot save SQL query result in one txt file. for that i have written one code line
sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt
but it is not working .
database : Oracle
so please advice me how can i... (7 Replies)
Discussion started by: Himanshu_soni
7 Replies
6. Shell Programming and Scripting
Hi,
my sql query return below value for " $SQL_OPN_AMT "
CUSTCODE OH OHOPNAMT_GL OHREFNUM -------------------------------- -- ----------- ------------------------------ OHENTDATE FCC --------- --- 1.1072256 IN 74.85 000072061
0 01-MAY-13 MVR 1.1072256 IN 751.72 0000744751 01-JUN-13 MVR... (3 Replies)
Discussion started by: ranabhavish
3 Replies
7. Shell Programming and Scripting
Hi All,
#!/bin/ksh
call_sql ()
{
sql=$1
sqlplus -s $sqlparam_sieb <<EOF
SET ECHO OFF;
SET NEWPAGE NONE;
SET SQLBL OFF;
SET VERIFY OFF;
SET LINESIZE 2000;
SET... (2 Replies)
Discussion started by: Kevin Tivoli
2 Replies
8. Solaris
Hi
I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query
select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p
inner join v$session se on p.addr = se.paddr
inner join
( select... (2 Replies)
Discussion started by: tharmendran
2 Replies
9. Shell Programming and Scripting
Hi
iam new to shell scripting
how to declare variables as redshift query and I have to compare two counts by using if condition .
ex:count=select count(*) from prd;
select count(*) from prd;
select count(*) from tag;
can any one help me .
Please use CODE tags when displaying... (1 Reply)
Discussion started by: sam526
1 Replies
10. Shell Programming and Scripting
I am writing the following script to create the file v_out.txt.
sqlplus -s /nolog << EOF
CONNECT scott/tiger@orcl;
whenever sqlerror exit sql.sqlcode;
set newpage 0;
SET PAGESIZE 0;
SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SET VERIFY OFF;
SET LINESIZE 100;
set tab off;
set... (7 Replies)
Discussion started by: itzkashi
7 Replies
LEARN ABOUT DEBIAN
update-otags
UPDATE-OTAGS(8) System administration commands UPDATE-OTAGS(8)
NAME
update-otags - update system-wide tags tables
SYNOPSIS
update-otags
DESCRIPTION
update-otags runs otags on the system-wide installed OCaml files (in ocamlc -where). This makes it possible to use the tag-features of
vi/vim and Emacs to jump to the declarations of library functions in the system-wide installed .mli files to read the documentation that is
hopefully embedded in those files.
To use the system-wide tags table in Emacs, use M-x visit-tags-table <RET> /var/lib/otags/TAGS. To load it by default, customize tags-ta-
ble-list to contain /var/lib/otags (by using M-x customize-variable, for instance).
For vim use :set tags=/var/lib/otags/tags or add set tags=/var/lib/otags/tags to your .vimrc.
One would typically update the system-wide tags tables with a cron-job once per week or day.
FILES
/var/lib/otags/{TAGS,tags}
System-wide tags table for Emacs and vi/vim.
/usr/share/otags/hints
Directory for parsing hints. Packages that install files in non-standard syntax can install a parser hints file for otags in this
directory, see option -parser-hints in the otags(1) manual.
BUGS
Camlp4 (and therefore otags too) cannot parse all legal OCaml sources. Most notably, camlp4 dies on pervasives.mli (see bug #5495). There-
fore, none of the core library functions are tagged.
Various files in the system-wide OCaml directory are written in the revised syntax or require other syntax extensions. In principle these
files can all be properly tagged, but the dumb update-otags script tries to parse all files with the original syntax.
CREDITS
update-otags appeared first in Debian Etch (see Debian bug #341939). It has been added to the contrib directory with an improved man page
in otags 3.12.2.
AUTHOR
Hendrik Tews <otags at askra.de>
SEE ALSO
otags(1)
OTAGS
January 2012 UPDATE-OTAGS(8)