insert values into sqlplus database using shell script Post: 302302519

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell Script And SQLPLUS

i'm having real problems retrieving the returncode of my sqlplus-call. I found a lot of informations on the net, but havn't been able to get it running so far, so now i ask for some help ;) I do start the sqlplus out of my shell script with the parameters stored in the proc_clips.sql, which is...

2. Shell Programming and Scripting

Shell Script: want to insert values in database when update script runs

Hi , I am new to linux and also also to shell scripting. I have one shell script which unpacks .tgz file and install software on machine. When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder...

3. Shell Programming and Scripting

shell script to insert data from gps.txt to mysql database

Hi, I have gps receiver, by using gpsd data i can read gps log data to my database(my sql). Steps: 1. telenet localhost 2947 > gps.txt (press enter) 2. r (press enter) //then i will get the data like below in gps.txt file Trying 127.0.0.1... Connected to localhost....

4. Shell Programming and Scripting

SQLPLUS within shell script

Hi I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional. Can anybody help me with this. Thanks Gaurav

5. Shell Programming and Scripting

sqlplus in shell script

Hi When I use sqlplus in shell script, I get sqlplus: command not found. ORACLE_HOME is not set. How to set ORACLE_HOME in unix? Thanks

6. Shell Programming and Scripting

Korn shell program to parse CSV text file and insert values into Oracle database

Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database. I need to write the korn shell program on Red Hat Enterprise Linux server. Oracle database is 10g.

7. Shell Programming and Scripting

Shell script for insert multiple records into a Database

I have a table in an Informix DB into which I want to insert multiple records at a time. Data for one of the column should be unique & other column data may be the same for all the records I insert Typical Insert Statement I use to insert one row : insert into employee(empid, country, state)...

8. Shell Programming and Scripting

Sqlplus in shell script

Hi All, Please let me know what i am missing in the following code (part of my script) Schemas=(AWQM WFCONTROLLER PROVCO PRISM) for s in "${Schemas}" do sch="${s}_$tol" if || ;then echo "This is AD or TD region" sqlplus -s $sch/$tpwd@$ttns <<EOF...

9. Shell Programming and Scripting

Need help on Insert data to phpMyAdmin mySQL database from Shell Script

Sorry to disturb you, I would like to seek help on inserting data whenever the switch is on or off to my phpMyAdmin mySQL database from my Shell Script. I'm using Raspberry PI as my hardware and I have follow this LINK: instructables.com/id/Web-Control-of-Raspberry-Pi-GPIO/?ALLSTEPS to create my...

10. Shell Programming and Scripting

Intelligent Script to Insert Records in Database Table

Hello All Members, I am new to this forum and to the shell scripting. I want to write a shell script to do the following: Scenario: I have a pipe delimited .txt file with multiple fields in it. The very first row of the file contains the name of the column which resembles the name of the...

LEARN ABOUT OSF1

pthread_getsequence_np

pthread_getsequence_np(3)				     Library Functions Manual					 pthread_getsequence_np(3)

NAME

       pthread_getsequence_np - Obtains the unique identifier for the specified thread.

LIBRARY

       DECthreads POSIX 1003.1c Library (libpthread.so)

SYNOPSIS

       #include <pthread.h>

       unsigned long   pthread_getsequence_np(
				     pthread_t	  thread);

STANDARDS

       None

PARAMETERS

       Thread object whose sequence number is to be obtained.

DESCRIPTION

       This  routine  obtains  and  returns  the DECthreads thread sequence number for the thread identified by the thread object specified in the
       thread argument.

       The thread sequence number provides a unique identifier for each existing thread.  A thread's thread sequence number is never reused  while
       the thread exists, but can be reused after the thread terminates.  The debugger interfaces use this sequence number to identify each thread
       in commands and in display output.

       The result of calling this routine is undefined if the thread argument does not specify a valid thread object.

RETURN VALUES

       No errors are returned.	This routine returns the DECthreads thread sequence number for the thread identified by the thread  object  speci-
       fied in the thread argument. The result of calling this routine is undefined if the thread argument does not specify a valid thread.

ERRORS

       None

RELATED INFORMATION

       Functions: pthread_create(3), pthread_self(3)

       Manuals: Guide to DECthreads and Programmer's Guide

       delim off

															 pthread_getsequence_np(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell Script And SQLPLUS

Discussion started by: maco_home

2. Shell Programming and Scripting

Shell Script: want to insert values in database when update script runs

Discussion started by: ring

3. Shell Programming and Scripting

shell script to insert data from gps.txt to mysql database

Discussion started by: gudivada213

4. Shell Programming and Scripting

SQLPLUS within shell script

Discussion started by: gaurav_1711