|
|
Sponsored Content
Top Forums
UNIX for Beginners Questions & Answers
Sqlplus variable UNIX
Post 303004846 by Francesco_IT on Tuesday 10th of October 2017 06:49:01 AM
10-10-2017
|
|
10 More Discussions You Might Find Interesting
1. 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
2. Shell Programming and Scripting
Hello,
I'm trying to write a script that will loop a sql statement through an external list. Basically, the script enters a loop and runs the sql statement for each entry in the list file. Currently, the script will stop at a cursor where I can then manually enter the SQL statment. This is... (11 Replies)
Discussion started by: MadHatter
11 Replies
3. UNIX for Advanced & Expert Users
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)
Discussion started by: sakthi.abdullah
3 Replies
4. UNIX for Dummies Questions & Answers
Need to select count(*) from table to check for zero result in unix script (2 Replies)
Discussion started by: struggle
2 Replies
5. Shell Programming and Scripting
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)
Discussion started by: Anaramkris
5 Replies
6. Shell Programming and Scripting
hi
how can i store sqlplus output to a variable in sh script (not bash)
Thanks
MM (1 Reply)
Discussion started by: murtymvvs
1 Replies
7. Shell Programming and Scripting
Hi, I'm a it stuck on the below code where a variable is pulled from sqlplus and used in awk. It runs with no errors but still pulls back all records in the input file.
It should pull the max reference from sql plus and then only print those records where the reference value in column 1 is... (4 Replies)
Discussion started by: jonathanb30
4 Replies
8. Shell Programming and Scripting
Hi,
I ahve a unix code as below.
sqlTxt=$*
sqlReturn=`echo "set feedback off;
set heading off;
set term off;
set verify off;
set serveroutput on size unlimited
set lin 1000;
VARIABLE GV_return_val NUMBER;
VARIABLE GV_script_error varchar2(4000);
EXEC :GV_return_code := 0;
EXEC... (6 Replies)
Discussion started by: bhaski2012
6 Replies
9. Shell Programming and Scripting
Hi Gurus,
I am stuck with the step where i need to fetch the location & sales from the below procedure by taking it from table field using the for loop. any idea how this can be done in unix. From one column both the location and sales are taken out.
create or replace procedure newyork... (2 Replies)
Discussion started by: arun888
2 Replies
10. Shell Programming and Scripting
Hi Team,
I am trying to run a sqlplus script against several databases via a FOR/LOOP and also passing the loop variable to a sqlplus script I am calling, as follows:
#!/bin/bash
export ORACLE_SID=plgc1
export ORACLE_HOME=/opt/oracle/product/11.2.0.2/db_1
export... (1 Reply)
Discussion started by: jonnyd
1 Replies
LEARN ABOUT ULTRIX
su
su(1) General Commands Manual su(1) Name su - substitute a user ID Syntax su [username] su - [username] su -f [username] Description The command requests the password of the specified username. If the correct password is given, changes to that username without changing the current directory. The user environment is unchanged except for HOME and SHELL which are taken from the password file entry for user- name. The shell that is run is also taken from the password file entry for username. The new user ID stays in force until the shell exits. If no username is specified, `root' is assumed. To remind the superuser of his responsibilities, the shell substitutes `#' for its usual prompt. Options -f Prevents from executing the .cshrc file, making start up faster. - Simulates a full login. Diagnostics Sorry An invalid password was supplied for the specified username. Unknown login: username The specified username was not found in the passwd database. No directory The home directory for the username is not accessible at this time (only with ``-'' argument). No shell The shell specified in the passwd database entry for username could not be executed. Kerberos initialization failure Consult your system administrator. If enhanced security features are enabled the following error messages are also possible: Requires secure terminal Attempt to su to UID 0 on a line that is not marked secure in User's password has expired Access is denied because the password for username is expired. This account is disabled Access is denied because the auth entry corresponding to username is marked disabled. Files Log file of anyone who became root, with a date mark. See Also csh(1), sh(1), passwd(5yp), environ(7), edauth(8) Security Guide for Administrators Security Guide for Users su(1)