Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to pass unix variable to SQLPLUS
Top Forums UNIX for Advanced & Expert Users How to pass unix variable to SQLPLUS Post 302076217 by chiru on Friday 9th of June 2006 11:51:05 PM
Old 06-10-2006
How to pass unix variable to SQLPLUS
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 advance
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pass variable to SQLPLUS in a ksh script?

Hi, I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers. Inside the same script, I am using SQLPLUS to run an Oracle SQL script,... (6 Replies)
Discussion started by: rwunwla
6 Replies

2. UNIX for Dummies Questions & Answers

How to pass unix variable to oracle

hi , how to pass unix variable to oracle code is ............. #! /bin/ksh echo enter date vale read date1 sqlplus x/y@oracle select * from emp where statrt_date= $date1 is this is correct way... (1 Reply)
Discussion started by: chiru
1 Replies

3. UNIX for Advanced & Expert Users

passing unix variable to sqlplus without a file name

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

select count(*) in sqlplus into variable unix shell

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

Passing the unix variable to sqlplus

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

How to print huge values in sqlplus variable in UNIX?

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

7. Shell Programming and Scripting

How to pass Variable from shell script to select query for SqlPlus?

echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on"; Select statement is mentioned below echo "select res.ti_book_no from disney_ticket_history res where res.ti_status =${STATUS} and... (7 Replies)
Discussion started by: aroragaurav.84
7 Replies

8. Programming

How to pass parameter from file to sqlplus in UNIX?

i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different. 343535435 365765767 343534543 343543543 i want to pass this file to sqlplus and sql command is ... (7 Replies)
Discussion started by: pallvi_mahajan
7 Replies

9. UNIX for Beginners Questions & Answers

Sqlplus variable UNIX

hi guys i have a sqlplus : sqlplus -s username/password << EOF @mysql.sql EOF in mysql.sql there is a count of a table, i want to write in a variabile unix. how can i do? Thanks a lot Regards Francesco. (3 Replies)
Discussion started by: Francesco_IT
3 Replies

10. Shell Programming and Scripting

Pass a VARIABLE to sqlplus script

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 V7

ching

CHING(6)							   Games Manual 							  CHING(6)

NAME

       ching, fortune - the book of changes and other cookies

SYNOPSIS

       /usr/games/ching [ hexagram ]

       /usr/games/fortune

DESCRIPTION

       The I Ching or Book of Changes is an ancient Chinese oracle that has been in use for centuries as a source of wisdom and advice.

       The  text  of  the  oracle  (as it is sometimes known) consists of sixty-four hexagrams, each symbolized by a particular arrangement of six
       straight (---) and broken (- -) lines.  These lines have values ranging from six through nine, with the even values indicating  the  broken
       lines.

       Each  hexagram  consists  of  two major sections.  The Judgement relates specifically to the matter at hand (E.g., "It furthers one to have
       somewhere to go.")  while the Image describes the general attributes of the hexagram and how they apply to one's own life ("Thus the  supe-
       rior man makes himself strong and untiring.").

       When  any  of  the lines have the values six or nine, they are moving lines; for each there is an appended judgement which becomes signifi-
       cant.  Furthermore, the moving lines are inherently unstable and change into their opposites; a second hexagram	(and  thus  an	additional
       judgement) is formed.

       Normally,  one  consults  the  oracle  by  fixing  the  desired	question  firmly  in  mind and then casting a set of changes (lines) using
       yarrow-stalks or tossed coins.  The resulting hexagram will be the answer to the question.

       Using an algorithm suggested by S. C. Johnson, the Unix oracle simply reads a question from the standard input (up to an  EOF)  and  hashes
       the  individual	characters in combination with the time of day, process id and any other magic numbers which happen to be lying around the
       system.	The resulting value is used as the seed of a random number generator which drives a simulated coin-toss divination.  The answer is
       then piped through nroff for formatting and will appear on the standard output.

       For  those  who wish to remain steadfast in the old traditions, the oracle will also accept the results of a personal divination using, for
       example, coins.	To do this, cast the change and then type the resulting line values as an argument.

       The impatient modern may prefer to settle for Chinese cookies; try fortune.

SEE ALSO

       It furthers one to see the great man.

DIAGNOSTICS

       The great prince issues commands,
       Founds states, vests families with fiefs.
       Inferior people should not be employed.

BUGS

       Waiting in the mud
       Brings about the arrival of the enemy.

       If one is not extremely careful,
       Somebody may come up from behind and strike him.
       Misfortune.

																	  CHING(6)
All times are GMT -4. The time now is 01:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy