08-28-2012
Quote:
Originally Posted by
JuanPerez
---------- Post updated at 07:48 AM ---------- Previous update was at 07:42 AM ----------
It works!!!!
And what if I needed to save more than one count value? I mean if I used "gorup by"... Would I have to use cursors or something like that?
Thank you and thanks everybody!
And what exactly do you want to do with those values?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
trying this
===============================
Temp=`sqlplus -s user/passwd <<EOF
WHENEVER SQLERROR EXIT 1
set serverout on
set feedback off
set heading off
select nam from tabel1
where x=y;
EOF`
echo Temp>>$logfile
=================================
The select statement is... (2 Replies)
Discussion started by: amitkr
2 Replies
2. UNIX for Advanced & Expert Users
Hi all,
Iam facing a lot of problem while calling Oracle 10g SQLPLUS files from shell.
What is the standard procedures to be taken care.
Any help would be useful for me.
Thanks in advance,
Ganapati. (2 Replies)
Discussion started by: ganapati
2 Replies
3. Solaris
Ok. So I've finally compiled the latest version of GNU emacs on Solaris 5.8.
I've set putty up so that it sets TERM=xtermc. emacs now has syntax highlighting. The problem is, whenever I quit emacs, it changes the screen colors. The background is now the same as the color of the minibuffer. It... (1 Reply)
Discussion started by: m9dhatter
1 Replies
4. Shell Programming and Scripting
Hi my code looks like:
if test $STEP -le 10
then
.
.
ls -1d AM*-OUT|while read MYDIR
do
cd $MYDIR
ls |tail -n1| while read MYFILE
do
.
.
if test -s $MYFILE
then
sqlldr ....
rc=$?
if test $rc -ne 0 (3 Replies)
Discussion started by: anijan
3 Replies
5. Shell Programming and Scripting
This is a very simple problem, I am wondering why I can find no answer anywhere...
I have a script that can be run either sourced or not. This script has some place where it needs to quit execution (e.g., when an error is found)
If I "exit", the sourced call would exit the parent shell, but... (7 Replies)
Discussion started by: MadMage
7 Replies
6. Shell Programming and Scripting
Folks,
Below is a basic synopsis of the problem. I have a script that I need to check for some env vars and fail (exit the script) if they are not there. At the same time I need to set some default env vars. To do this I must run the script from the parent shell or source the script. Doing... (3 Replies)
Discussion started by: bashN00b
3 Replies
7. Shell Programming and Scripting
Hi all,
I have a scenario where im connecting to sqlplus executing a query,redirecting the output to a file and manipulating the file
MY CODE IS AS FOLLOWS
sqlplus -s /nolog << EOF > $UTILITIES_HOME/temp/analyze.temp.log &
set linesize 3000
set trimspool on
set pagesize... (2 Replies)
Discussion started by: niteesh_!7
2 Replies
8. Shell Programming and Scripting
sql_rows=`sqlplus -s / <<EOF
set heading off
set pagesize 1000
set tab off
set linesize 120 wrap off
column "Path" format a15
--column "No_Of_files" format a10
select tablespace_name, substr(file_name,1,instr(file_name,'/',1,2)) as "Path" , count(*) as "No_Of_files" from dba_data_files
... (7 Replies)
Discussion started by: desibabu
7 Replies
9. AIX
Hi guys,
Here is the error i get by running a "sqlplus -v" after installing an oracle client 10.2.0.5 on an AIX 5.3.9 server.
Could not load program sqlplus:
Symbol resolution failed for sqlplus because:
Symbol __pthread (number 307) is not exported from dependent
... (3 Replies)
Discussion started by: Chapel
3 Replies
10. Shell Programming and Scripting
Hi I am having a problem exiting a WHILE loop. I am on a Sun server using ksh.
I am running a Veritas Cluster Software (High Availablity) command to obtain a group status and grepping the command output for status "G" which means that the filesystem is frozen and therefore not available to... (3 Replies)
Discussion started by: bigbuk
3 Replies
LEARN ABOUT NETBSD
pthread_join
PTHREAD_JOIN(3) BSD Library Functions Manual PTHREAD_JOIN(3)
NAME
pthread_join -- wait for thread termination
LIBRARY
POSIX Threads Library (libpthread, -lpthread)
SYNOPSIS
#include <pthread.h>
int
pthread_join(pthread_t thread, void **value_ptr);
DESCRIPTION
The pthread_join() function suspends execution of the calling thread until the target thread terminates unless the target thread has already
terminated.
On return from a successful pthread_join() call with a non-NULL value_ptr argument, the value passed to pthread_exit() by the terminating
thread is stored in the location referenced by value_ptr. When a pthread_join() returns successfully, the target thread has been terminated.
The results of multiple simultaneous calls to pthread_join() specifying the same target thread are undefined. If the thread calling
pthread_join() is cancelled, then the target thread is not detached.
A thread that has exited but remains unjoined counts against _POSIX_THREAD_THREADS_MAX.
RETURN VALUES
If successful, the pthread_join() function will return zero. Otherwise an error number will be returned to indicate the error.
ERRORS
pthread_join() shall fail if:
[EINVAL] The value specified by thread does not refer to a joinable thread.
[ESRCH] No thread could be found corresponding to that specified by the given thread ID, thread.
pthread_join() may fail if:
[EDEADLK] A deadlock was detected or the value of thread specifies the calling thread.
SEE ALSO
wait(2), pthread_create(3)
STANDARDS
The function conforms to IEEE Std 1003.1-2001 (``POSIX.1'').
BSD
July 9, 2010 BSD