i found that it is not the problem with the screen configuration, but it is the problem with the column width that the sql will write into the buffer
i used 'set lin 300' in the sql. Check the following SQL
Code:
sqlplus -silent $USER/$passwd@$DB << EOF
set heading off
set feedback off
set serveroutput on;
whenever sqlerror exit -1
whenever oserror exit -2
set lin 300;
SPOOL tmpfile;
select descr60 from tmp where id='1234'
SPOOL OFF;
EOF
set lin <n> will set the column width to <n> characters width.
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Hi,
We have >1000 UNIX boxes in our environment with various UNIX flavors like Solaris, HP-UX and Redhat Linux ES 3/4/5. We need to collect their system configuration like
- No. of CPUs and their frequencies
- RAM Size
- No. of HDDs installed and their usage
- Exact OS Version and its... (3 Replies)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
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)
Hi
I am writting a configuration script to make changes to the /etc/rc.config.d/nddconf file. I have pulled this section out to test it so I have the editing of the file already written.
I have two problems with the function.
1. The script is ignoring the results of the if loop.
2. The sed... (12 Replies)
I need help in the following script. I want to grep the sql errors insert into the error table and exit the shell script if there is any error, otherwise keep running the scripts.
Here is my script
#!/bin/csh -f
source .orapass
set user = $USER
set pass = $PASS
cd /opt/data/scripts
echo... (2 Replies)
Hi,
I am new to shell scripting,and i was planning to write a script that will FTP files to destination folder.
I was planning that All configuration should be done through a properties files. and finally the output should be
Files are transferred
I have developed a properties file named... (4 Replies)
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)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
LEARN ABOUT HPUX
atan2dw
atan2d(3M)atan2d(3M)NAME
atan2d(), atan2df(), atan2dl(), atan2dw(), atan2dq() - degree-valued arctangent-and-quadrant functions
SYNOPSIS
HP Integrity Server Only
DESCRIPTION
is a degree-valued version of the function. It returns the arctangent of y/x, in the range -180 to 180, using the signs of both arguments
to determine the quadrant of the return value.
is a version of it takes arguments and returns a result.
Integrity Server Only
is a version of it takes arguments and returns a result.
is an version of it takes arguments and returns an result.
is equivalent to on HP-UX systems.
USAGE
To use these functions compile either with the default option or with the and the options.
To use (for Integrity servers) or compile also with the option.
To use any of these functions, make sure your program includes and link in the math library by specifying on the compiler or linker command
line.
For more information, see the at the following site:
RETURN VALUE
If y and x is -0,
If y and x is +0,
If y and x is less than zero,
If y and x is greater than zero, returns
If y is less than zero and x is zero, returns -90.
If y is greater than zero and x is zero, returns 90.
If y is greater than zero and x is -INFINITY, returns 180.
If y is less than zero and x is -INFINITY, returns -180.
If y is greater than zero and x is INFINITY, returns +0.
If y is less than zero and x is INFINITY, returns -0.
If y and x is finite, returns
If y and x is -INFINITY, returns
If y and x is +INFINITY, returns
If x or y is NaN, returns NaN.
ERRORS
No errors are defined.
SEE ALSO acosd(3M), asind(3M), atand(3M), atan2(3M), cosd(3M), sind(3M), tand(3M), math(5).
STANDARDS CONFORMANCE
These functions are not specified by any standard.
atan2d(3M)
01-11-2012
Script/SQL configuration
