06-12-2006
Please search the forum. This one question has been answered at least five different times in the past week.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am calling an oracle function that returns a number (either 0 or 2), how do I pass that pass to the wrapping shell script as I would like to do other things based on the value returned by the oracle function.
Your help will be appreciated.
--------------------------
sqlplus / <<... (3 Replies)
Discussion started by: Jtrinh
3 Replies
2. UNIX for Dummies Questions & Answers
how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies
3. UNIX for Advanced & Expert Users
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)
Discussion started by: chiru
1 Replies
4. UNIX for Advanced & Expert Users
I am having a file which has the following data
123424
2354235
142424
43423
1434
.
.
.
.
etc
i want to pass these values to oracle at a time by using a file.. can someone suggest me a answer...
waiting...... (1 Reply)
Discussion started by: vidyadhar85
1 Replies
5. Shell Programming and Scripting
Hi
i am calling a stored procedure from unix shell like this call
test_proc('0002','20100218');
the stored procedure was giving output
like this dbms_output.put_line(' processed earlier');
i want to see the output in the unix shell where i called.
Thanks
barani (6 Replies)
Discussion started by: barani75
6 Replies
6. Shell Programming and Scripting
Please help me how to pass some unix vairable to oracle. I have used below , but not displaying passed (inval) value.
calling()
{
sqlplus -s $1/$2@$3 <<EOF
begin
exec call_sql($4);
end;
exit
EOF
}
calling user pwd inst value1... (17 Replies)
Discussion started by: Jairaj
17 Replies
7. UNIX for Dummies Questions & Answers
i had this unix korn shell code that connects to oracle database and execute the oracle procedure. i need to add a variable that indicates the oracle procedure failed. basically the variable is to check if the oracle procedure failed it will assign 1 and when the variable is equal to 1 it will not... (4 Replies)
Discussion started by: wtolentino
4 Replies
8. Shell Programming and Scripting
Hello All,
I need to export various variables in UNIX. But the values of those variables will come from Oracle.
Say i have Oracle query:
Select
file_id, file_desc, file_freq_cd, load_table_nm, load_stored_procd_nm, load_proc_typ_nm, err_rec_cnt_thrsld_nbr, file_expc_rec_cnt From Table1... (7 Replies)
Discussion started by: Arun Mishra
7 Replies
9. Shell Programming and Scripting
Hello,
I am trying to execute an SQL query from shell script.
A part of script is something like this:
fromDate=`echo $(date +"%F%T") | sed "s/-//g" | sed "s/://g"`
$ORACLE_HOME/sqlplus -s /nolog <<EOD1
connect $COSDBUID/$COSDBPWD@$COSDBSID
spool... (4 Replies)
Discussion started by: sanketpatel.86
4 Replies
10. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
LEARN ABOUT DEBIAN
fccexam
HAMEXAM(1) General Commands Manual HAMEXAM(1)
NAME fccexam - Study guide for USA FCC commercial radio license examinations.
SYNOPSIS
fccexam [option]
DESCRIPTION
fccexam presents questions in random order from the selected question pool, and terminates when all questions have been answered correctly.
The session may be interrupted with ^C, and resumed later.
Some questions refer to diagrams. The diagrams for the selected question pool are displayed in a separate window using eog(1).
Licenses are issued by the Federal Communications Commission (FCC), but examinations are administered by COLEM examiners. See http://wire-
less.fcc.gov/commoperators/index.htm?job=home for information regarding USA commercial radio licenses.
OPTIONS
If no pool is specified, usage, version, and help information is displayed.
To initialize the question pool, one of the element numbers may be specified:
1 Element 1, Basic radio law and operating practice.
3 Element 3, General Radiotelephone; Electronic fundamentals and techniques required to adjust, repair, and maintain radio transmit-
ters and receivers.
5 Element 5, Radiotelegraph operating procedures and practices.
6 Element 6, Advanced technical, legal, and other matters applicable to the operation of all classes of radiotelegraph stations.
7 Element 7, GMDSS Radio Operating Practices.
7R Element 7R, Restricted GMDSS Radio Operating Practices.
8 Element 8, Ship Radar Techniques.
9 Element 9, GMDSS Radio Maintenance Practices and Procedures.
The following abbreviations may be used to select multiple elements:
T1 First Class Radiotelegraph: elements 1, 5, 6.
T2 Second Class Radiotelegraph: elements 1, 5, 6.
T3 Third Class Radiotelegraph: elements 1, 5.
GROL General Radiotelephone Operator License: elements 1, 3.
GROL+ General Radiotelephone Operator License + Radar: elements 1, 3, 8.
MROP Marine Radio Operator Permit: element 1.
GMDSS Global Maritime Distress Safety System Radio Operator: elements 1, 7.
GMDSS+ GMDSS Radio Maintainer + Radar: elements 1, 7, 8, 9.
RGMDSS Restricted GMDSS Radio Operator: elements 1, 7R.
q The question pool is selected interactively. This is needed when starting the application from an icon.
FILES
A directory ~/.fccexam is created to hold the names of the questions which remain to be answered correctly.
SEE ALSO
For more information regarding licensing, ref. http://wireless.fcc.gov/commoperators/index.htm?job=home
For information regarding amateur radio licensing (ham radio), see the package hamexam.
COPYRIGHT
fccexam is Copyright (c) 2011-2012 John Nogatch <jnogatch@yahoo.com>.
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
BUGS
The question pools, and number of questions required, are sometimes modified; ref. http://wireless.fcc.gov/commopera-
tors/index.htm?job=question_pools
Radiotelegraph Operator licenses also require Morse code proficiency elements, which are not provided by fccexam.
fccexam does not automatically update the question pools from the FCC Web site.
HAMEXAM(1)