Sponsored Content
Top Forums Shell Programming and Scripting Query Oracle tables and return values to shell script that calls the query Post 302363981 by Scott on Wednesday 21st of October 2009 07:28:35 PM
Old 10-21-2009
Hi.

It helps if you post examples representative to your problem. This saves on the guess work.

My previous post shows how to return values from SQL/Plus into a shell variable.

If that's not enough, please do let me know.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Tables to query to find users for database from shell script

I am coding shell script. I need to connect to different databases like DB2, Oracle and Sybase. I would then need to query tables where it has all the groups, users for that database. I would also need who has what kind of permissions. EG: I know for DB2 some TABAUTH table needs to be... (0 Replies)
Discussion started by: pinnacle
0 Replies

2. Shell Programming and Scripting

run oracle query remotly with shell script

hello how to run shell script to excute oracle queries on remote db ? i have tried as following sqlplus -s user/password@remote_server "select query;" but not working also this one sqlplus -s user/password@remote_server `select query;` not working :( i add this line to run another... (4 Replies)
Discussion started by: mogabr
4 Replies

3. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies

4. Shell Programming and Scripting

PROBLEM WITH ORACLE QUERY IN UNIX SCRIPT

hi Guys, i have a problem with oracle query in my unix script.. I'm getting the following error while executing.. ./logtab.sh: sqlplus -s "pmutv/pmutv1" << EOFSQL^Jset head off^Jinsert into... (2 Replies)
Discussion started by: apple2685
2 Replies

5. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

6. Shell Programming and Scripting

Problems with storing oracle sqlplus query output shell script

Hello everyone, I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected. I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies

7. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
9 Replies

8. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies

9. Shell Programming and Scripting

Return db2 query value to shell script

Hi, Im new to DB2. I need to connect to DB2 from shell script and return the query output back to shell script variable. this is my code #!/bin/ksh db_name=db db_user=usr db_pwd=pwd db2 <<EOSQL connect to $db_name user $db_user using "$db_pwd" select count(1) from table quit EOSQL ... (3 Replies)
Discussion started by: sup
3 Replies

10. Shell Programming and Scripting

Shell script automation using cron which query's MySQL Tables

What I have: I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory) note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates... (3 Replies)
Discussion started by: kkpand
3 Replies
POST-REVIEW(1)							   User Commands						    POST-REVIEW(1)

NAME
post-review - post/update reviews to Review Board SYNOPSIS
post-review [-pond] [-r review_id] [changenum] OPTIONS
Review Request Options -p, --publish publish the review request immediately after submitting -r ID, --review-request-id=ID existing review request ID to update --revision-range=REVISION_RANGE generate the diff for review based on given revision range Server Options --server=SERVER specify a different Review Board server to use --submit-as=USERNAME user name to be recorded as the author of the review request, instead of the logged in user --username=USERNAME user name to be supplied to the reviewboard server --password=PASSWORD password to be supplied to the reviewboard server Basic Options --version show program's version number and exit -h, --help show this help message and exit -o, --open open a web browser to the review request page -n, --output-diff outputs a diff to the console and exits. Does not post Field Defaults Options --target-groups=TARGET_GROUPS names of the groups who will perform the review --target-people=TARGET_PEOPLE names of the people who will perform the review --summary=SUMMARY summary of the review --description=DESCRIPTION description of the review --description-file=DESCRIPTION_FILE text file containing a description of the review --testing-done=TESTING_DONE details of testing done --testing-done-file=TESTING_FILE text file containing details of testing done --branch=BRANCH affected branch --bugs-closed=BUGS_CLOSED list of bugs closed --change-only updates info from changelist, but does not upload a new diff (only available if your repository supports changesets) --tracking-branch=TRACKING Tracking branch from which your branch is derived (git only, defaults to origin/master) --p4-client=P4_CLIENT the Perforce client name that the review is in --p4-port=P4_PORT the Perforce servers IP address that the review is on -d, --debug display debug output --diff-filename=DIFF_FILENAME upload an existing diff file, instead of generating a new diff Git Options --guess-summary guess summary from the latest commit (git/hgsubversion only) --guess-description guess description based on commits on this branch (git/hgsubversion only) Git and Mercurial Options --parent=PARENT_BRANCH the parent branch this diff should be against (only available if your repository supports parent diffs) Subversion Options --repository-url=REPOSITORY_URL the url for a repository for creating a diff outside of a working copy (currently only supported by Subver- sion). Requires either --revision-rangeor --diff-filename options Perforce Options --diff-only uploads a new diff, but does not update info from changelist ClearCase Options --label=LABEL Specifies the label used for ClearCase. DESCRIPTION
post-review is intended to post a review from a local repository to the Review Board server, or update such an existing review. It works differently with different version-control systems. For CVS and Subversion, the review to post is the uncommited change in a working copy. With distributed VC systems (currently Git and Mercurial are supported), the review is a topic branch. Posting it is, technically, pushing it to the repository at the Review Board server. PerForce and ClearCase also seem to be supported but the author of this page fails to understand the details. Refer to undocumented(7) for more information on using them with this program. [A more detaild description can help] CONFIGURATION
post-review needs to be told of the address of the server to post to. This can come from several possible places: GIT property reviewboard.url For example, the following command will set a repository-specific property: git config --add reviewboard.url http://reviewboard.example.com Refer to git-config(1) for the full details. Subversion Property reviewboard:url The subversion property reviewboard:url may be set on the top-level directory. svn propset reviewboard:url http://reviewboard.example.com . Perforce Counters Rumour has it they exist and can even help in the configuration here. .reviewboardrc $HOME/.reviewboardrc The file .reviewboardrc can exist in either the top-level directory of the project or under the user's top-level directory. This file uses python syntax for assignments. It has two optionalmethods of defining the repository URL: REVIEWBOARD_URL A simple variable pointing to the server: REVIEWBOARD_URL = "http://reviewboard.example.com" TREES A directionary of subversion repositories to REVIEWBOARD_URL-s: TREES = { 'http://svn.example.com': { 'REVIEWBOARD_URL': 'http://rb.example.com', }, 'username@cvs.example.com:/cvsroot/cvs': { 'REVIEWBOARD_URL': 'http://rb.example.com', }, } EXAMPLES
post a new review from a working subversion copy: post-review This generates a new draft review. Refer to the "Field Defaults" options above to set non-empty values to some fields in the review. Alter- natively set them later through the web interface. Update that review, assuming its review number is 17: post-review -r 17 To post a review from a your GIT feature branch: git checkout -b new-feature main-branch emacs -f butterfly '.......' # or ed git commit post-review [That said, I can't really follow the documentation as to how post-review works on git/hg: how does it post the last diff only?] This does not create a new diff. Rather, it updates the existing one. In the following two examples, the review was not published. AUTHOR
post-review was written by Christian Hammond and David Trowbridge. This man page was written by Tzafrir Cohen <tzafrir.cohen@xorcom.com>. SEE ALSO
On-Line Documentation <http://www.reviewboard.org/docs/manual/dev/users/tools/post-review/> post-review 0.8 March 2010 POST-REVIEW(1)
All times are GMT -4. The time now is 05:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy