sql plus report under unix environment


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting sql plus report under unix environment
# 1  
Old 06-17-2007
sql plus report under unix environment

Hi i am creating a report with file format csv using sql plus commands under unix environment. I am sending this report using mailx command to excel spread sheet. when i opened the report my columns are merged. I need to manually pull each column to see whole column results. Is there any way in unix to format the columns. to its actual length of results.
the reason i am using csv fomat is i wrote sql select query to retrieve the data from oracle DB. when i send the results to csv file format to excel it automatically formats. Every thing is comming is good except
darg the columns to see whole column.

how to format in unix of sql select query results.
columns are name, status, begin,end,date
i need to see whole results of the query in excel with out manullay drag the columns.
pl help me
N.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SQL Report from UNIX

I am trying to write a shell script which dynamically reads all the .sql (oracle sql files) from a particular directory and generates a .csv file in the target directory. I have started first with the below sample script to see if it is working but I am not able to get it executed, please help... (7 Replies)
Discussion started by: mora
7 Replies

2. Shell Programming and Scripting

How can i run sql queries from UNIX shell script and retrieve data into text docs of UNIX?

Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies

3. UNIX for Dummies Questions & Answers

SQL PLUS report formatting

Hi I am fetcthing the data from the oracle database using SQLPLUS. Here is my script #!/bin/ksh echo `sqlplus -s <<EOF set feedback off set linesize 5000 set pages 0 set space 0 set echo off set trimspool on set colsep '|' SELECT col1 , col2... (4 Replies)
Discussion started by: max_hammer
4 Replies

4. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

5. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies

6. Shell Programming and Scripting

unix variables from sql / pl/sql

How do I dynamically assign the below output to unix shell variables so I can build a menu in a shell script? Example: var1 = 1 var2= SYSTEM var3 = 2 var4= UNDOTBS1 and so on, then in the shell script I can use the variables to build a menu. set serveroutput on declare... (2 Replies)
Discussion started by: djehres
2 Replies

7. Shell Programming and Scripting

Script needed to FTP a file from sql report to unix server

Hi All, I have a Sqlplus report which will create a file. I need a FTP Script that will be executed inside the Sqlplus Report to FTP the report output file to unix server. Thanks, Previn (0 Replies)
Discussion started by: vprevin
0 Replies

8. UNIX for Dummies Questions & Answers

unix environment

Hi, Can anyone recommend a site where one can practise UNIX scripting . I don't have UNIX on my machine however I have heard there are some sites which let you log on to their servers for free. Thanks Rohit (2 Replies)
Discussion started by: rohitv
2 Replies

9. Shell Programming and Scripting

Unix Environment Script

Hi, I was wondering what is the best way to write a centralized unix environment script. This script would set the application environment variables per specific environment. e.g. dev, qa, test or prod. We currenlty have 2 types of env files e.g. .envfile and set.env per environment. These... (4 Replies)
Discussion started by: acheepi
4 Replies

10. UNIX for Dummies Questions & Answers

personalizing my unix environment

I share a login id/password with several folks so I don't like to change the .profile or other environment variables (e. g., set ignorecase in vi) that other users may expect to be set. Any suggestions to tailor my environment that will not affect other users (2 Replies)
Discussion started by: artjaniger
2 Replies
Login or Register to Ask a Question
fvwm-bug(1)							   Fvwm Modules 						       fvwm-bug(1)

NAME
fvwm-bug - report a bug in fvwm SYNOPSIS
fvwm-bug [--help] [--version] [address] DESCRIPTION
fvwm-bug is a shell script to help the user compose and mail bug reports concerning fvwm in a standard format. fvwm-bug invokes the editor specified by the environment variable EDITOR on a temporary copy of the bug report format outline. The user must fill in the appropriate fields and exit the editor. fvwm-bug then mails the completed report to the local fvwm maintainer, the fvwm workers list fvwm-work- ers@fvwm.org, or address. If the report cannot be mailed, it is saved in the file dead.fvwm-bug in the invoking user's home directory. The bug report format outline consists of several sections. The first section provides information about the machine, operating system, the fvwm version, and the compilation environment. The second section should be filled in with a description of the bug. The third sec- tion should be a description of how to reproduce the bug. The optional fourth section is for a proposed fix. Fixes are encouraged. ENVIRONMENT
fvwm-bug will utilize the following environment variables if they exist: EDITOR Specifies the preferred editor. If EDITOR is not set, fvwm-bug defaults to emacs. HOME Directory in which the failed bug report is saved if the mail fails. Fvwm 7 May 208 (2.5.26) fvwm-bug(1)