Sponsored Content
Full Discussion: Sqlplus code format
Top Forums UNIX for Beginners Questions & Answers Sqlplus code format Post 302990390 by Corona688 on Wednesday 25th of January 2017 04:45:37 PM
Old 01-25-2017
All your questions are generic Bourne shell questions so far, the command reads text in and prints text out, no special SQL knowledge required. So you're just looking for the wrong kind of tutorial really.
 

10 More Discussions You Might Find Interesting

1. Programming

how i prepare a c++ code(c code) for implementing my own protocol format

helo my protocol format is given below { destno,mode,no.of packet,pktsize,,pktno,textsize,CRC} description:- { is starting flag destno - 4bytes mode - 1 byte no.of pkt - 4byes pktsize - 6 bytes ... (1 Reply)
Discussion started by: amitpansuria
1 Replies

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

3. Shell Programming and Scripting

code to FTP the spool file from Sqlplus to the unix server.

I have a sqlplus report and inside that report I have the following piece of code to mail the report output to the email id. My requirement is, instead of emailing the output I want to FTP that script to a different unix server (say ip as 10.10.1.1). How to modify this code to FTP the spool file... (0 Replies)
Discussion started by: vprevin
0 Replies

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

5. Programming

Basic perl code- Date format

Hi friends, Please see the below code carefully. ======================================================= # Get batch date and Ord range open OR,$ARGV; while (<OR>) { # find the batch date next if length $_ < 3; # BLANK LINE # last if $. > 120; # sample should be good enough... (2 Replies)
Discussion started by: pspriyanka
2 Replies

6. Shell Programming and Scripting

need code for date which is in yyyy-mm-dd format

Hi, I am having one log files. contains som data according to date. And it is going to append .Eg:abc.log contains below data 2011-10-19 abjhgj 2011-10-19 gjhgjgj 2011-10-20 hhhjh 2011-10-20 hhhhjj 2011-10-21 gg . . . 2011-11-24 yyy from log files i want catch only... (2 Replies)
Discussion started by: aish11
2 Replies

7. Shell Programming and Scripting

perl code-sequence of json format

Hi All , Below is the perl code. from below code want to confirm one thing that wahtever the sequence of data we are passing through json format which contains 3 tuples of different sequences Eg: ParentID,SystemID,SendingTime,Time,ClientLocation,ClientID, ... (1 Reply)
Discussion started by: aish11
1 Replies

8. Shell Programming and Scripting

Shell Script passing parameters to sqlplus code

Hello All, I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible? Thanks (4 Replies)
Discussion started by: compprog11
4 Replies

9. UNIX and Linux Applications

Please help: Oracle gqsql or sqlplus output format like mysql

On psql select titolo,lingua from titolo where titolo ~* 'brivid'; titolo | lingua ------- + ------ Brivido | 1 On Sqlplus/gqsql SQL> select titolo,genere,anno,lingua from titolo where titolo like '%rivid%'; TITOLO... (6 Replies)
Discussion started by: Linusolaradm1
6 Replies

10. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
SNMPCONF(1)							     Net-SNMP							       SNMPCONF(1)

NAME
snmpconf - creates and modifies SNMP configuration files SYNOPSIS
snmpconf [OPTIONS] [fileToCreate] Start with: snmpconf -g basic_setup Or even just: snmpconf DESCRIPTION
snmpconf is a simple Perl script that walks you through setting up a configuration file step by step. It should be fairly straight forward to use. Merely run it and answer its questions. In its default mode of operation, it prompts the user with menus showing sections of the various configuration files it knows about. When the user selects a section, a sub-menu is shown listing of the descriptions of the tokens that can be created in that section. When a description is selected, the user is prompted with questions that construct the configuration line in question. Finally, when the user quits the program any configuration files that have been edited by the user are saved to the local directory, fully commented. A particularly useful option is the -g switch, which walks a user through a specific set of configuration questions. Run: snmpconf -g basic_setup for an example. OPTIONS
-f Force overwriting existing files in the current directory without prompting the user if this is a desired thing to do. -i When finished, install the files into the location where the global system commands expect to find them. -p When finished, install the files into the users home directory's .snmp subdirectory (where the applications will also search for configuration files). -I DIRECTORY When finished, install the files into the directory DIRECTORY. -a Don't ask any questions. Simply read in the various known configuration files and write them back out again. This has the effect of "auto-commenting" the configuration files for you. See the NEAT TRICKS section below. -rall|none Read in either all or none of the found configuration files. Normally snmpconf prompts you for which files you wish to read in. Reading in these configuration files will merge these files with the results of the questions that it asks of you. -R FILE,... Read in a specific list of configuration files. -g GROUPNAME Groups of configuration entries can be created that can be used to walk a user through a series of questions to create an initial configuration file. There are no menus to navigate, just a list of questions. Run: snmpconf -g basic_setup for a good example. -G List all the known groups. -c CONFIGDIR snmpconf uses a directory of configuration information to learn about the files and questions that it should be asking. This option tells snmpconf to use a different location for configuring itself. -q Run slightly more quietly. Since this is an interactive program, I don't recommend this option since it only removes information from the output that is designed to help you. -d Turn on lots of debugging output. -D Add even more debugging output in the form of Perl variable dumps. NEAT TRICKS
snmpconf -g basic_setup Have I mentioned this command enough yet? It's designed to walk someone through an initial setup for the snmpd(8) daemon. Really, you should try it. snmpconf -R /usr/local/snmp/snmpd.conf -a -f snmpd.conf Automatically reads in an snmpd.conf file (for example) and adds comments to them describing what each token does. Try it. It's cool. NOTES
snmpconf is actually a very generic utility that could be easily configured to help construct just about any kind of configuration file. Its default configuration set of files are SNMP based. SEE ALSO
snmpd(8), snmp_config(5), snmp.conf(5), snmpd.conf(5) 4th Berkeley Distribution 08 Feb 2002 SNMPCONF(1)
All times are GMT -4. The time now is 12:49 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy