Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Not able to write SQL query output in to .csv file with shell script. Post 303036121 by sandeepgoli53 on Friday 14th of June 2019 10:51:38 AM
Old 06-14-2019
Hi RudiC,

Yes i changes column names and used '|' as delimiter.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

need help in reading a output of a sql query in unix script

i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated. my sql query provide output some thing like this - col1 col2 count ---- ---- ------ A B 10 c D 6 e... (8 Replies)
Discussion started by: pharos467
8 Replies

2. Shell Programming and Scripting

TO execute .sql 2005 query file in shell script

Hi, I know in oracle a .sql file is called by @ <path> /<filename>. But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script. (0 Replies)
Discussion started by: n2ekhil
0 Replies

3. 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

4. Shell Programming and Scripting

SQL Script's output to a CSV file

I need to call and execute an SQL script within a KSH script and get the output/extracted data into a CSV file. Is there any way to get the out put in a CSV file other than spooling ? I tried spooling. Problem is if there is any wrning/comment/Error they all will be spooled into the csv file. I... (4 Replies)
Discussion started by: Sriranga
4 Replies

5. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

Hi Guys.. Need your help to format the output of my shell script. I am using spool command to take out put in csv file. below is my code. (for example) col USERNAME for a15 col EMAIL for a30 col FULL_NAME for a20 col LAST_LOGIN for a40 col DATE_CREATED for a40 SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies

6. Shell Programming and Scripting

SQL query in UNIX script - output in flat file

Hi, I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen. snapshot of my script:... (13 Replies)
Discussion started by: juzz4fun
13 Replies

7. Shell Programming and Scripting

SQL Query in Shell Script output formatting

Hi All, #!/bin/ksh call_sql () { sql=$1 sqlplus -s $sqlparam_sieb <<EOF SET ECHO OFF; SET NEWPAGE NONE; SET SQLBL OFF; SET VERIFY OFF; SET LINESIZE 2000; SET... (2 Replies)
Discussion started by: Kevin Tivoli
2 Replies

8. Shell Programming and Scripting

Need to write shell script for my .sql file call

Hi Guys, I need to write a simple shell script which will generate a .csv file/report by calling .sql file inside a shell script. Can somebody help me on this. Thanks in advance! Regards, LK (7 Replies)
Discussion started by: lakshmanraok117
7 Replies

9. Shell Programming and Scripting

Run sql query in shell script and output data save as delimited text

I want to run sql query in shell script and output data save as delimited text (delimited text would be comma) Code: SPOOL_FILE=/pgedw/dan.txt SQL=/pgedw/dan.sql sqlplus -s username/password@myhost:port/servicename <<EOF set head on set COLSEP , set linesize 32767 SET TRIMSPOOL ON SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies

10. Shell Programming and Scripting

Shell script appending output of sql query

I am writing the following script to create the file v_out.txt. sqlplus -s /nolog << EOF CONNECT scott/tiger@orcl; whenever sqlerror exit sql.sqlcode; set newpage 0; SET PAGESIZE 0; SET ECHO OFF; SET FEEDBACK OFF; SET HEADING OFF; SET VERIFY OFF; SET LINESIZE 100; set tab off; set... (7 Replies)
Discussion started by: itzkashi
7 Replies
priv_str_to_set(3)					     Library Functions Manual						priv_str_to_set(3)

NAME
priv_str_to_set(), priv_set_to_str() - privilege name to set conversion function SYNOPSIS
Parameters priv_list The list of privilege names, passed as a string, separated by one or more characters from delimiter. It may also contain the compound privileges (basic, basicroot, and policy). delimiter Separates the privileges in priv_list. index_ptr If an error occurs while parsing the list of privilege names, the pointer pointed to by index_ptr is set to point to the remainder of the string after the error occurred, so long as index_ptr is not a NULL pointer. delimiter Separates the individual privilege names by any of the specified characters. If delimiter is a NULL character, the default delimiter of comma is used. flag Bit mask with the following bit positions defined: Exactly one of the two flags must be passed. When flag is the resulting string uses the compound privileges and to arrive at a short representation. priv_vec Specifies privilege set. DESCRIPTION
priv_str_to_set Conversion converts a list of privilege names to a privilege set. priv_list is a string consisting of privilege names and/or compound privileges. The individual elements in the string are separated by one or more characters of delimiter . Any privilege in the list priv_list can be optionally preceded by an exclamation mark to be interpreted as removal. For example, means all privileges in the compound privilege except the privilege. The string is case-insensitive. prefix is optional to a privilege name. For example, and all have the same meaning. priv_list is interpreted left to right, so the string is the same as an empty list of privileges, while is the same as For a list of valid privileges (both individual privileges and compound privileges), see privileges(5). priv_set_to_str Conversion converts a privilege set to a string of privilege names separated by the character specified by delimiter . RETURN VALUE
and return the following values: pointer Successful completions. Returns a non-null pointer. The caller of is responsible for freeing the result using the The caller of is responsible for freeing the result using the NULL pointer Function failed. Returns a null pointer and sets to indicate the error . ERRORS
If any of the following conditions occur, the functions fail and set Cannot allocate enough memory for the given data. One or more arguments are invalid. EXAMPLES
#include <stdio.h> #include <sys/types.h> #include <sys/privileges.h> #define priv_list "PRIV_CHOWN,PRIV_CHROOT,PRIV_DACREAD" main() { char *index; priv_set_t * priv_vector; if ( (priv_vector = priv_str_to_set( priv_list, NULL, &index)) == NULL ) { perror("priv_str_to_set Failed"); if (index) printf("Invalid privilege name starting at %s ", index); exit(1); } printf("The privileges in the given privilege vector are %s ", priv_set_to_str( priv_vector, NULL, PRIV_STR_SHORT) ); } DEPENDENCIES
and are both part of the library. SEE ALSO
privset_free(3), privileges(5). priv_str_to_set(3)
All times are GMT -4. The time now is 02:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy