K shell with Oracle

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting K shell with Oracle
# 1  
Old 01-14-2008
K shell with Oracle


I am getting values from oracle database and splitting with "|".
When i loop thru the $OUTPUT i am getting so many new line characters.

Please help me why i am getting so many line and how to get rid of the same.

below is the code i am using.

OUTPUT=`sqlplus -s <<-!
whenever sqlerror exit failure
set pages 0 feed off echo off
select SEQNO,'|',MESSAGE_ID,'|'
from triton.cims_msg_out;

let count=0
for variable in $OUTPUT
echo "variable ======= $variable"
#file=$(echo $variable | awk '{FS = "." } {print $1}')
#ext=$(echo $variable | awk '{FS = "." } {print $2}')

Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Help on Oracle insert from shell script

Hi All I am trying to create a shell script to insert in to oracle table so far insert happens with out an issue, but i cant pass message variable to sqlplus script insert. i have highlighted the variable in red. Please help. thanks in advance. #!/bin/sh df -H | grep -vE... (3 Replies)
Discussion started by: LPK
3 Replies

2. Shell Programming and Scripting

Oracle to shell script

hi , i have some procedures that were written in oracle (sql/plsql). I need to convert them into shell scripts. So is there any procedure to this. or any tools available to do this. I need some guidance on this as i am totally new . I dont know shell scripting at all. My main target get the logic... (5 Replies)
Discussion started by: harishbabuy
5 Replies

3. Shell Programming and Scripting

Connecting to ORACLE through SHELL

Hi, I am trying to connect to oracle database ( through Sun solaris. But I am unable to do so. The content of my script is as follows: Shell Sript: RESULT=`$ORACLE_HOME/bin/sqlplus schema/'pwd'@db << EOF set echo on; set feedback on; @/home/count/qry.sql` echo... (10 Replies)
Discussion started by: fidelis
10 Replies

4. Shell Programming and Scripting

Getting value from oracle to unix shell

All, I am using Sun Solaris and Oracle 10g. I have a simple shell script returning a value. #!/usr/bin/ksh dummyvar=`sqlplus -s '/as sysdba' <<END set feedback off; set verify off; set serveroutput on; select num from scott.num1; END` echo $dummyvar For the above script - i... (5 Replies)
Discussion started by: user7509
5 Replies

5. UNIX for Advanced & Expert Users

Shell menus And Oracle

Dear All, Kindly suggest on how should i proceed with the following requirement I need to develop an interactive shell script menu which would enable the user to inquire the value of a column based on a key value . The output can be more records.. Also is it possible to do the following 1)... (2 Replies)
Discussion started by: ksm
2 Replies

6. Shell Programming and Scripting

Korn Shell and Oracle

Hi Guys, I haven't worked on oracle much but I have a situation where I have to do bdf in all the servers and insert that information into oracle table. I have already created table which have 7 columns, I can insert manually but I dont know how to insert that using Korn shell. SERVER_ID ... (9 Replies)
Discussion started by: pareshan
9 Replies

7. AIX

Accessing Oracle DB via Shell possible ?

At work we are using AIX 4.2 for the client. On this system, there is Oracle and kron, Bash and C shell. Is it possible to access Oracle via the shell to create/update tables ? There is this hourly data that we accumulate on the AIX and we manually copy the infos to Excel for stats. I thought... (2 Replies)
Discussion started by: Browser_ice
2 Replies

8. Shell Programming and Scripting

Shell Scripting with Oracle...

Hi guys, I have searched all the forums and searched the net as much as possible, but I carn't find any tutorials about shell scripting with Oracle. Has anyone come across any? Thanks for reading and in advance of posts, B14... (2 Replies)
Discussion started by: B14speedfreak
2 Replies

9. Shell Programming and Scripting

ORACLE from Shell scripts

Hi, I have Oracle, and I want to execute simple queries in it. Is it possible to do this using a UNIX shell scripts. Are there any commands in Shell scripting where in I can communicate to ORACLE!? Thanks, (2 Replies)
Discussion started by: mohanprabu
2 Replies
Login or Register to Ask a Question
DBIx::SearchBuilder::Handle::Oracle(3pm)		User Contributed Perl Documentation		  DBIx::SearchBuilder::Handle::Oracle(3pm)

DBIx::SearchBuilder::Handle::Oracle - An oracle specific Handle object SYNOPSIS
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of Oracle. METHODS
Connect PARAMHASH: Driver, Database, Host, User, Password Takes a paramhash and connects to your DBI datasource. BuildDSN Customized version of "BuildDSN" in DBIx::SearchBuilder::Handle method. Takes additional argument SID. Database argument used unless SID provided. Two forms of DSN are generated depending on whether Host defined or not: dbi:Oracle:sid=<SID>;host=...[;port=...] dbi:Oracle:<SID> Read details in documentation for DBD::Oracle module. Insert Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted. InsertFromSelect Customization of "InsertFromSelect" in DBIx::SearchBuilder::Handle. Unlike other DBs Oracle needs: o id generated from sequences for every new record. o query wrapping in parens. NOTE that on Oracle there is a limitation on the query. Every column in the result should have unique name or alias, for example the following query would generate "ORA-00918: column ambiguously defined" error: SELECT g.id, u.id FROM ... Solve with aliases: SELECT g.id AS group_id, u.id AS user_id FROM ... KnowsBLOBs Returns 1 if the current database supports inserts of BLOBs automatically. Returns undef if the current database must be informed of BLOBs for inserts. BLOBParams FIELD_NAME FIELD_TYPE Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current Oracle implementation only supports ORA_CLOB types(112). ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW; DistinctQuery STATEMENTREF takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set. BinarySafeBLOBs Return undef, as Oracle doesn't support binary-safe CLOBS DatabaseVersion Returns value of ORA_OCI constant, see "Constants" in DBI. SimpleDateTimeFunctions Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle. ConvertTimezoneFunction Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle. Use the following query to get list of timezones: SELECT tzname FROM v$timezone_names; Read Oracle's docs about timezone files: http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667 AUTHOR
Jesse Vincent, jesse@fsck.com SEE ALSO
perl(1), DBIx::SearchBuilder perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::Oracle(3pm)