Sponsored Content
Special Forums UNIX and Linux Applications Please help: Oracle gqsql or sqlplus output format like mysql Post 302777927 by Linusolaradm1 on Friday 8th of March 2013 06:03:26 PM
Old 03-08-2013
Works fine,thanks
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

File Format issue: Output of sqlplus

Hi, I am using a query like below in my shell script : { { echo "set echo off" echo "set head off" echo "whenever sqlerror exit -1; select NUMBER ||','|| FNAME ||','|| LOC ||','|| ... (2 Replies)
Discussion started by: deepakgang
2 Replies

2. Shell Programming and Scripting

Help needed to format mysql output

Hi all, Does anyone know how to format the output from mysql from within a shell script? i.e. RESULT=`mysql command` echo ${RESULT} the ${RESULT} only displays the output on one line instead of how mysql would display it as columns etc (3 Replies)
Discussion started by: muay_tb
3 Replies

3. Shell Programming and Scripting

Formatting Oracle sqlplus output

a job extracts orcle data into unix as flat file. a single record breaks into two record in unix flat file. This is the case only for 6 records out of 60 lack records. (its not single record in two line. but its single record into record. ie., \n come into picture) can you tell me what... (6 Replies)
Discussion started by: Gopal_Engg
6 Replies

4. UNIX for Dummies Questions & Answers

Connecting to Oracle DB using sqlplus

Hi, I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following: 1. Connect to oracle database hosted on a different server 2. fire a query on the oracle db 3. store the output in a variable 4. use this variable for further logic... (1 Reply)
Discussion started by: shrutihardas
1 Replies

5. Shell Programming and Scripting

Connecting to Oracle DB using sqlplus

Hi, I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following: 1. Connect to oracle database hosted on a different server 2. fire a query on the oracle db 3. store the output in a variable 4. use this variable for further logic... (26 Replies)
Discussion started by: shrutihardas
26 Replies

6. Shell Programming and Scripting

Format the output from sqlplus while writing to log file.

Hi I have developed bash script to connect to database and execute .sql files. I am logging some statements in to log file using echo. While logging I am adding the date in front of the log statements which makes sense. I am unable to add date in front of output from the sqlplus and sqlldr,... (8 Replies)
Discussion started by: murtymvvs
8 Replies

7. Shell Programming and Scripting

Problems with storing oracle sqlplus query output shell script

Hello everyone, I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected. I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies

8. Shell Programming and Scripting

Need help getting my output from MYSQL query into right format

Good afternoon! I have been lurking in this forum for awhile now. I have just recently started posting. I think this is a really good site. With that being said, I don't like to just run and get an answer before I try my best first. I have poured some blood, sweat and tears into... (4 Replies)
Discussion started by: brianjb
4 Replies

9. Shell Programming and Scripting

Connect to Oracle using sqlplus

I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'. What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies

10. UNIX for Beginners Questions & Answers

Sqlplus code format

Hi, I have some questions about sqlplus running from bash. I am still new and learning. I have the code shown below: echo "exit" | sqlplus... (10 Replies)
Discussion started by: mohca2020
10 Replies
PSIZE(1)							  PDB2PQR Manual							  PSIZE(1)

NAME
psize - Get dimensions and other information from PQR files SYNOPSIS
psize [--cfact=value] [--fadd=value] [--space=value] [--gememfac=value] [--gememceil=value] [--ofrac=value] [--redfac=value] {pqrfile} psize {--help | -h} DESCRIPTION
psize derives information from PQR files to preprare the models of proteins and chemicals for electrostatics calculations. The tool calculates dimensions for coarse and fine grids, grid spacings, box size and estimates the memory required to perform an electrostatics calculation. The calculation of this information can be influenced by giving constraints to psize as parameters. OPTIONS
psize accepts the following options: --help, -h Print a help message and exit. --cfact=value Factor by which to expand the molecule dimensions to get the coarse grid dimensions --fadd=value Amount to add to the molecule dimensions to get the fine grid dimensions. --space=value Desired fine mesh resolution. --gememfac=value Number of bytes per grid point required for sequential MG calculation. --gememceil=value Maximum MB allowed for sequential MG calculation. Adjust this to force the script to perform faster calculations (which require more parallelism). --ofrac=value Overlap factor between mesh partitions. --redfac=value Maximum factor by which a domain dimension can be reduced during focusing. SEE ALSO
apbs(1), pdb2pqr(1) AUTHOR
Manuel Prinz <debian@pinguinkiste.de> Wrote this manpage for the Debian System. COPYRIGHT
Copyright (C) 2008 Manuel Prinz psize 2008-06-04 PSIZE(1)
All times are GMT -4. The time now is 03:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy