Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Execute SQL query in unix script
Top Forums Shell Programming and Scripting Execute SQL query in unix script Post 302371498 by vijays3 on Sunday 15th of November 2009 08:34:42 AM
Old 11-15-2009
Bug Execute SQL query in unix script
Hi

I am new in unix. oracle and unix are installed in my sytem.i need the script
which could connect to the oracle using username ,password and schema and can run the select * from tab query.



Thanks
vijay
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sql query results in unix shell script

Hi I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this. 1. Opened a cursor to a table in DB2 databse. 2. Fetching individual rows with the help of cursor. 3. Each row has 4 fields. I want each of the field in individual shell... (1 Reply)
Discussion started by: skyineyes
1 Replies

2. Shell Programming and Scripting

Execute oracle query determined at runtime from a unix script

Hi I am trying to run a SQL statement from a unix script determined at runtime. It is throwing me an error. Please advise some solution to this. echo "Enter username for the database" read username echo "Enter password for the database" read password echo "Enter SQL stmt" read... (4 Replies)
Discussion started by: infyanurag
4 Replies

3. Shell Programming and Scripting

need help in reading a output of a sql query in unix script

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

4. Shell Programming and Scripting

TO execute .sql 2005 query file in shell script

Hi, I know in oracle a .sql file is called by @ <path> /<filename>. But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script. (0 Replies)
Discussion started by: n2ekhil
0 Replies

5. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies

6. UNIX for Dummies Questions & Answers

executing SQL query using unix shell script

I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful. (3 Replies)
Discussion started by: nathanvaithi
3 Replies

7. Shell Programming and Scripting

Different way to connect to database ans execute sql query

Hi Friends, I am using AIX version and sqlplus to connect to database while writing a shell script. I have implemented three ways to connect to database : 1) sqlplus -s <USERNAME>/<PASSWORD> <<! @<SQL FILE TO EXECUTE> exit ! 2) sqlplus -s <USERNAME>/<PASSWORD> <<! -----sql statemenets... (6 Replies)
Discussion started by: gauravgarg
6 Replies

8. Programming

JDBC code to pass the SQL query as parameter and execute?

Below i have the sample code. i need to pass the entire query from file or as parameter and read the results and write into a output file. here the number of columns are unknown. some times it may be 2,3 or entire columns from the table. read all the column results and write into a comma... (0 Replies)
Discussion started by: laknar
0 Replies

9. Shell Programming and Scripting

SQL query in UNIX script - output in flat file

Hi, I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen. snapshot of my script:... (13 Replies)
Discussion started by: juzz4fun
13 Replies

10. Shell Programming and Scripting

Shell script to execute sql query.

Hi Experts, Need your support. Not able to use sql query alias in shell script. Could you please help me in finding right way to use alias with sql query in shell script. Below is the code i am using. #!/bin/bash sqlplus -s abc/abc@abc << EOF> bcd.csv set trimspool on select zone_id... (4 Replies)
Discussion started by: as7951
4 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 07:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy