09-05-2001
sqlplus and sh scripts (to_char command))
Hi evrybody!!!!
I have a problem with this shell script
INICIO=$(sqlplus -s user/user@db1 << END | awk '{printf $1}'
set head off
set feed off
select to_char(min(create_dt) , 'HH24') from table_name where trunc(create_dt)=trunc(sysdate-2);
END)
I want to recover, in INICIO, the min time from a group of records but the problem is I am using the to_char command with (') symbol, as you see in the example 'HH24'. With Oracle it works OK, directly by sqlplus. But with sh scripts it doesn't. I tried with '' double single quoted or " double quoted and \' but the problem continues, could somebody have an advice to solve the problem?
Thanks
José
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Can someone tell me how to execute sqlplus command.
I`m Executing:
sqlplus user/pasw @/report/output/new/PlatformOut_Cdrs.sql
the error is:
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Aug 9 15:37:44 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:... (3 Replies)
Discussion started by: Nel
3 Replies
2. Shell Programming and Scripting
How to execute a query which is stored in a variable.
Say for example :
v_source_query=”select count(*) from emp”
v_source_value=`sqlplus -S "$DATABASE_LOGIN" << EOF | tr '\n' ' '
set feed off
set pagesize 0
set head... (12 Replies)
Discussion started by: trupti_d
12 Replies
3. UNIX for Dummies Questions & Answers
hi all,
i was given by my supervisor a task to search for scripts which contain oracle sqlplus i.e "myusername/mypasswd @myDB" in every /home/userfolder, which are, all the scripts made by different user. I've done some find command to search string for sqlplus, but it may up too long to respond.... (8 Replies)
Discussion started by: Helmi
8 Replies
4. HP-UX
hi,
i need bash shell script run on the crontab(Unix tru64).
i have write my shell. it's using sqlplus command and connect to oracle db.
execute cron job when i have error messege: "sqlplus: command not found"
have you any suggestion? (4 Replies)
Discussion started by: Tlg13team
4 Replies
5. Shell Programming and Scripting
Hi folks
I use a Solaris 10 box with Bash shell.
I have here a script (it works!) to list all scripts in crontab which contains the string "sqlplus":
for i in $(ls `crontab -l | grep -v '#' | awk '{ print $6 }' | grep -v '^$'`); do grep -l 'sqlplus' "$i"; done
Is there a more elegant... (1 Reply)
Discussion started by: slashdotweenie
1 Replies
6. Ubuntu
I installed Oracle 10.2.1.0 in Ubuntu 10.10..my installation was well,i could even open isqlplus( http://ubuntu.ubuntu-domain:5560/isqlplus/workspace.uix ) and execute some queries..But,back in terminal when i try to login to sqlplus i am getting error (20 Replies)
Discussion started by: sandy0594
20 Replies
7. UNIX and Linux Applications
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Discussion started by: TRS80
1 Replies
8. Red Hat
Hi,
I am facing a strange issue when connecting to SQLPLUS via a shell scripts.
I am using Linux 2.6.18-274.18.1 and gbash shell.
When I connect to SQLPLUS through scripts then it throws TNS Time Out error ""sometimes"" and connects successfully other times.This is only happening when... (9 Replies)
Discussion started by: aashish.sharma8
9 Replies
9. Shell Programming and Scripting
Hi ,
i am new to unix i need a small clarification regarding this
sqlplus -s $USER_NAME/$PASSWD@$ORA_SID<< EOF >> SQL_CONN_LOG.log
In the above command what is the meaning of <<EOF>>
Thanks,
krishna. (2 Replies)
Discussion started by: rams_krishna
2 Replies
10. UNIX and Linux Applications
Hi all,
i face an error related to my server ""it's running server"" when i use sqlplus command
$ sqlplus
bash: sqlplus: command not found
the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup.
i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies
chsh(1) General Commands Manual chsh(1)
NAME
chsh - change default login shell
SYNOPSIS
login-name [shell]
login-name [shell]
login-name [shell]
login-name [shell]
DESCRIPTION
The command changes the login-shell for a user's login name in the repository (see passwd(1)).
The DCE repository is only available if Integrated Login has been configured; see auth.adm(1M). If Integrated Login has been configured,
other considerations apply. A user with appropriate DCE privileges is capable of modifying a user's shell; this is not dependent upon
superuser privileges.
If the repository is not specified (as in [login-name]), the login shell is changed in the file only.
Run after running to make sure the information was processed correctly.
Notes
The command is a hard link to the command. When is executed, actually the command gets executed with appropriate arguments to change the
user login shell in the repository specified in command line. If no repository is specified, the login shell is changed in the file.
Arguments
login-name A login name of a user.
shell The absolute path name of a shell. If the file exists, the new login shell must be listed in that file. Otherwise, you
can specify one of the standard shells listed in the getusershell(3C) manual entry. If shell is omitted, it defaults to
the POSIX shell,
Options
The following option is recognized:
Specify the repository to which the operation is to be applied.
Supported repositories include and
Security Restrictions
You must have appropriate privileges to use the optional login-name argument to change another user's login shell.
NETWORKING FEATURES
NFS
File can be implemented as a Network Information Service (NIS) database.
EXAMPLES
To change the login shell for user to the default:
To change the login shell for user to the C shell:
To change the login shell for user to the Korn shell in the DCE registry:
WARNINGS
If two or more users try to write the file at the same time, a passwd locking mechanism was devised. If this locking fails after subse-
quent retrying, terminates.
AUTHOR
was developed by HP and the University of California, Berkeley.
FILES
SEE ALSO
chfn(1), csh(1), ksh(1), passwd(1), sh(1), sh-posix(1), getusershell(3C), pam(3), passwd(4), shells(4).
chsh(1)