Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to acheive ALT+Enter of xls in Unix ksh/sqlplus
Top Forums Shell Programming and Scripting How to acheive ALT+Enter of xls in Unix ksh/sqlplus Post 302092989 by tmarikle on Monday 16th of October 2006 06:05:39 PM
Old 10-16-2006
Here's one sqlplus way to do it:
Code:
  1  SELECT text
  2        ,REPLACE (text
  3                 ,' '
  4                 ,CHR (10) ) text
  5  FROM   (SELECT 'desc1:value1 desc2:value2 desc3:value3' text
  6*         FROM   DUAL)
SQL> /

TEXT                                   TEXT
-------------------------------------- --------------------------------------
desc1:value1 desc2:value2 desc3:value3 desc1:value1
                                       desc2:value2
                                       desc3:value3

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help with ksh script that uses sqlplus, called from PHP

I have a ksh script that connects to sqlplus and dumps the query results into a file. The script works file when I run it from the command line, however, when I call it from PHP using system(), exec(), or shell_exec() commands, the script doesn't seem to run the query. It will create the text file... (7 Replies)
Discussion started by: j2owilson
7 Replies

2. Shell Programming and Scripting

How to pass variable to SQLPLUS in a ksh script?

Hi, I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers. Inside the same script, I am using SQLPLUS to run an Oracle SQL script,... (6 Replies)
Discussion started by: rwunwla
6 Replies

3. Shell Programming and Scripting

KSH Sqlplus problem

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

4. Shell Programming and Scripting

Simulate ENTER key in ksh scripting

Using SCO 5, Ksh here I am trying to automate some process that i am doing manually. During some point of time, I will have to press enter to clear away some messages. This is how I do manually. *one command* r r r r r I enter the command once, then press enter key 1 more... (6 Replies)
Discussion started by: khaos83_2000
6 Replies

5. Shell Programming and Scripting

Mail to: cc: How can i acheive this with ksh

Hi All, I have to write a script to send mail, in that i have to dynamically add the recepient in TO and my cc is a common one. For all mails my cc recepients are same. Only problem with TO recepient. Please i am looking for your inputs. (1 Reply)
Discussion started by: Arunprasad
1 Replies

6. Shell Programming and Scripting

Enter an input and reference another line in ksh script

Hi I have a file like so: Code: Frank Peter Tony Robert Mike 1 2 3 4 5 5 4 2 3 1 4 3 1 5 2 My out should look like this: Peter Tony Mike and so on.... I have the first part done to ask the user to... (8 Replies)
Discussion started by: bombcan1
8 Replies

7. Solaris

sqlplus output from ksh.

Hi All, I have the below simple script. It runs just fine by itself when I manually invoke it. But once I put it in the crontab with entry: * * * * * /users/myuser/test.ksh >> /users/myuser/log/test.txt" It does NOT print the returned value ($REMAIN) from the DB!? The result in the... (3 Replies)
Discussion started by: steve701
3 Replies

8. Shell Programming and Scripting

KSH - type ENTER to continue

Hello, Is ther any way to run a loop which promt an echo"waiting for user to hit ENTER" sleeps for an iterval and once user hit the ENTER key the loop exit and the script continue to the next stage? I need this ASAP !!! Thanks!! (9 Replies)
Discussion started by: LiorAmitai
9 Replies

9. Shell Programming and Scripting

Merging Multiple XLS into Different tabs in xls/ xlsx

HI, I have multiple files per dept in folder for eg : In a folder File1_Dept100.xls File2_Dept100.xls File3_Dept100.xls File1_Dept200.xls File2_Dept200.xls File3_Dept200.xls Output should be : Dept100.xls which has File1, File2, File3 in different tabs Dept200.xls which has... (1 Reply)
Discussion started by: venkyzrocks
1 Replies

10. Shell Programming and Scripting

Line break in sqlplus output through ksh script

Hi, I am new to shell script programming. I have written a ksh script to run the sql File placed in server directory and spool the output in destination directory. Below Command: $ORACLE_HOME/bin/sqlplus -s $ora_uid @$sqlfile_loc$testquery.sql > $opfiledirectory It is generating the output... (6 Replies)
Discussion started by: Sumit Arora
6 Replies

LEARN ABOUT REDHAT

math

math(n) 							 Tcl Math Library							   math(n)

NAME

       math - Tcl Math Library

SYNOPSIS

       package require Tcl 8.2

       package require math ?1.2?

       ::math::cov value value ?value ...?

       ::math::integrate list of xy value pairs

       ::math::fibonacci n

       ::math::max value ?value ...?

       ::math::mean value ?value ...?

       ::math::min value ?value ...?

       ::math::prod value ?value ...?

       ::math::random ?value1? ?value2?

       ::math::sigma value value ?value ...?

       ::math::stats value value ?value ...?

       ::math::sum value ?value ...?

DESCRIPTION

       The math package provides utility math functions.

COMMANDS

       ::math::cov value value ?value ...?
	      Return the coefficient of variation expressed as percent of two or more numeric values.

       ::math::integrate list of xy value pairs
	      Return the area under a "curve" defined by a set of x,y pairs and the error bound as a list.

       ::math::fibonacci n
	      Return the n'th Fibonacci number.

       ::math::max value ?value ...?
	      Return the maximum of one or more numeric values.

       ::math::mean value ?value ...?
	      Return the mean, or "average" of one or more numeric values.

       ::math::min value ?value ...?
	      Return the minimum of one or more numeric values.

       ::math::prod value ?value ...?
	      Return the product of one or more numeric values.

       ::math::random ?value1? ?value2?
	      Return a random number.  If no arguments are given, the number is a floating point value between 0 and 1.  If one argument is given,
	      the number is an integer value between 0 and value1.  If two arguments are given, the number is an integer value between value1  and
	      value2.

       ::math::sigma value value ?value ...?
	      Return the population standard deviation of two or more numeric values.

       ::math::stats value value ?value ...?
	      Return the mean, standard deviation, and coefficient of variation as percent as a list.

       ::math::sum value ?value ...?
	      Return the sum of one or more numeric values.

KEYWORDS

       math, statistics

math									4.2								   math(n)
All times are GMT -4. The time now is 01:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy