Sponsored Content
Top Forums Shell Programming and Scripting How to pass Oracle sql script as argument to UNIX shell script? Post 302913916 by junior-helper on Wednesday 20th of August 2014 05:54:35 PM
Old 08-20-2014
Bug

Quote:
Originally Posted by a1_win
I think I got it
Are you sure? Did you try to pass another sql script? I think it works now because you still have users.sql hardcoded:
Code:
#!/bin/bash
. /test1/product/r12/TEST1/apps/apps_st/appl/APPSTEST1_xyz.env

/test1/product/r12/TEST1/apps/tech_st/10.1.2/bin/sqlplus apps/apps@TEST1  <<-EOF

spool fnd_user_output.xls
@users.sql
spool off
exit;
EOF

This line probably needs to be changed to @$1.
This User Gave Thanks to junior-helper For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to pass values from oracle sql plus to unix shell script

how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies

2. Shell Programming and Scripting

How to pass pl/sql table values to shell script

Hello, i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies

3. UNIX for Advanced & Expert Users

How to use parameter in sql script pass from unix script?

Hi, I am unable to use parameter in sql script passed from unix script. my sql script CREATE_SBI_LIST_GROUP.sql is like this - ------------------------------- SELECT SDS.ID "SO_ID", SDS.SO a1, sgp.sga__code SGA_CODE, FROM sga sga,sales_genl_provision sgp , comm_product_condn cpc... (2 Replies)
Discussion started by: apskaushik
2 Replies

4. Shell Programming and Scripting

pass null value to sql script from korn shell script

There are 4 parameters that I have to pass from korn shell to sql script. 1) I have to check if $1 , $2 , $3 and $4 are null values or not . How can I do that ? 2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies

5. Shell Programming and Scripting

How we can pass the argument when calling shell script from perl script

Can someone let me know how could I achieve this In one of per script I am calling the shell script but I need to so one thing that is one shell script call I need to pass pne argument.In below code I am calling my ftp script but here I want to pass one argument so how could I do this (e.g:... (5 Replies)
Discussion started by: anuragpgtgerman
5 Replies

6. Programming

pass value from Oracle sql to Korn shell

Hi All , I am trying to pass a value from sqlplus to korn shell . There is a table tab1 in Oracle that has a column userdate. I need to pass the userdate to the korn shell . This is what I am doing . VALUE=`sqlplus -silent username/password << END set pagesize 0 feedback off verify off... (14 Replies)
Discussion started by: megha2525
14 Replies

7. UNIX for Advanced & Expert Users

Use of Oracle pl/sql in UNIX shell script

Hi, I have basic knowledge on how to write pl/sql code inside shell script. I am looking for more advance thing. Is there any book for that which can just talk about how to write more advance plsql code inside shell script. Please help Thanks!!!!!! (1 Reply)
Discussion started by: diehard
1 Replies

8. Shell Programming and Scripting

How to pass command line argument in shell script?

I need to write a shell script, when I run that script I should pass those arguments if not, then script should not run and pass the error message like invalid option - - should pass the argument. and Exit from the script https://www.unix.com/images/misc/progress.gif (1 Reply)
Discussion started by: Nsharma3006
1 Replies

9. UNIX for Dummies Questions & Answers

How to pass command line argument in shell script?

I need to write a shell script, when I run that script I should pass those arguments if not, then script should not run and pass the error message like invalid option - - should pass the argument. and Exit from the script (8 Replies)
Discussion started by: Nsharma3006
8 Replies

10. Shell Programming and Scripting

Unable to pass value from .Shell script to .SQL file

Hi All, I am new to shell script. I am trying to pass value from .sh file to .sql file . But I am able to run the .sql file from .sh file with values in sql file. But I am unable to pass the values from .sh file. can some one please help to resolve this. here is my .sh file s1.sh ... (4 Replies)
Discussion started by: reddy298599
4 Replies
gnome-calculator(1)						   User Commands					       gnome-calculator(1)

NAME
gnome-calculator, gcalctool - perform basic, financial, and scientific calculations SYNOPSIS
gnome-calculator [-a accuracy] [-D] [-E] [gnome-std-options] DESCRIPTION
The Calculator application is multifunctional and can handle different types of mathematical approaches. Calculator has the following modes: Basic Mode Provides standard calculator functions. You can store numbers in 10 different memory registers, and easily retrieve and replace the numbers in the memory registers. Basic Mode is the default mode. You can use all of the Basic Mode functions in each of the other modes. Financial Mode Provides several complex financial functions. Scientific Mode Provides many additional mathematical functions, including trigonometric and logical functions. You can also store your own functions and constants, when you use Scientific Mode. EXTENDED DESCRIPTION
On startup, Calculator uses the following configuration resources stored in a GConf database. Resource: /schemes/apps/gcalctool/accuracy Values: Accuracy value Description: The number of digits displayed after the numeric point. This value must be in the range 0 to 9. Resource: /schemes/apps/gcalctool/base Values: Numeric Base Description: The initial numeric base. Valid values are "BIN" (binary), "OCT" (octal), "DEC" (deci- mal), and "HEX" (hexadecimal). Resource: /schemes/apps/gcalctool/display Values: Display mode Description: The initial display mode. Valid values are "ENG" (engineering), "FIX" (fixed-point), and SCI" (scientific). Resource: /schemes/apps/gcalctool/mode Values: Mode Description: The initial calculator mode. Valid values are "BASIC", "FINANCIAL", and "SCIENTIFIC". Resource: /schemes/apps/gcalctool/showzeroes Values: true, false (true) Description: Whether to show trailing zeroes after the numeric point in the display value. Resource: /schemes/apps/gcalctool/showregisters Values: true, false (true) Description: Whether to display the memory register window when Calculator starts. Resource: /schemes/apps/gcalctool/trigtype Values: Trig. type Description: The initial trigonometric type. Valid values are "DEG" (degrees), "GRAD" (grads), and "RAD" (radians). Any constants or functions that the user defines are also stored in the GConf database. OPTIONS
The following options are supported: -a accuracy Specifies the number of digits displayed after the numeric point. This value must be in the range 0 to 9. -D Enable debug mode. -E Enable debug mode in the multiple-precision arithmetic package. gnome-std-options Standard options available for use with most GNOME applications. See gnome-std-options(5) for more information. EXAMPLES
Example 1: Launching Calculator example% gnome-calculator EXIT STATUS
The following exit values are returned: 0 Application exited successfully >0 Application exited with failure FILES
The following files are used by this application: /usr/bin/gnome-calculator Executable for Calculator. ~/.gcalctoolrc User-specific resources for customizing the appearance and color of Calculator. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWgnome-calculator | +-----------------------------+-----------------------------+ |Interface stability |External | +-----------------------------+-----------------------------+ SEE ALSO
Calculator Manual Latest version of the GNOME Desktop User Guide for your platform. gnome-std-options(5) NOTES
Written by Glynn Foster and Rich Burridge, Sun Microsystems Inc., 2003. SunOS 5.10 1 Oct 2003 gnome-calculator(1)
All times are GMT -4. The time now is 09:08 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy