Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Convertion of Date Format using SQL query in a shell script
Top Forums Shell Programming and Scripting Convertion of Date Format using SQL query in a shell script Post 302372939 by aigles on Thursday 19th of November 2009 05:28:20 AM
Old 11-19-2009
The TO_CHAR function is perhaps specific to ORACLE.
You haven't specify wich database you are using.

Jean-Pierre.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Connecting DB in the Shell Script to do SQL Query

Any link or example to write shell script for the Connecting Oracle for Quering through SQL thanks in advance ... Cheers !! Mehul Doshi (3 Replies)
Discussion started by: mehuldoshi
3 Replies

2. Shell Programming and Scripting

Executing Sql Query Using Shell Script

HI ALL i have a requirement like this. i have to write a shell script to run a sql query. DB is oracle. once the query is run, the results of the query has to be published in a data file. can you please advice me how to go about it. i am absolutely new to shell scripts and this is a part of my job. (14 Replies)
Discussion started by: ragha81
14 Replies

3. Shell Programming and Scripting

executing a SQL query in shell script

Hi ALL, I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know. select query returns multiple values( say select name from emp) Thanks in advance LM (1 Reply)
Discussion started by: lijju.mathew
1 Replies

4. Shell Programming and Scripting

query sql using shell script

query sql using shell script, is it possible? my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script? thanks in advance! (2 Replies)
Discussion started by: kingpeejay
2 Replies

5. Shell Programming and Scripting

$ symbol in sql query in shell script

Hi Team, Can you please help me to resolve this issue. Am unable to use this $ symbol in sql query in the shell script. For Example: # !/bin/sh export USER_NAME=XXX export PASSWORD=YYY export ORACLE_SID=xamdb echo $ORACLE_SID echo " Session Details ..." ... (1 Reply)
Discussion started by: indira_s
1 Replies

6. UNIX for Dummies Questions & Answers

Regarding executing sql query in shell script

Hi, I have one SQL file prepared in UNIX and one script that is executing that. In SQL i have Update and create queries. I want to introduce conditions in SQL file (in UNIX) that if either of the create or update query failes whole transaction should be rollback. I just have 1 create... (2 Replies)
Discussion started by: abhii
2 Replies

7. Red Hat

Sql query through shell script

hey , i am using this code to store value of a sql query and and then use it in other query but after some time , but it is not working. please help #!/bin/bash val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF setting heading off select max(stat_id) from cvt_stats; exit EOF ) nohup... (5 Replies)
Discussion started by: ramsavi
5 Replies

8. Shell Programming and Scripting

Convert the SQL Query in Shell Script

Hi All, I have a query with output below select 'create synonym "'||TABLE_NAME||'" for '||Table_owner||'."'||table_name||'"'||chr(59) from user_synonyms; ================== create synonym "RV_SBC_SIG" for WFCONTROLLER_TE."RV_SBC_SIG"; create synonym "AQM_TASK" for AWQM_TE."AQM_TASK";... (2 Replies)
Discussion started by: pvmanikandan
2 Replies

9. Shell Programming and Scripting

How to embed sql query into our shell script?

Hi I would like to embed a sql query in my shell script. Also, before any the sql query is executed, i would like to validate username and password. (1 Reply)
Discussion started by: arghadeep adity
1 Replies

10. Shell Programming and Scripting

How do I read sql query into shell script?

Hello All, I'm trying to put together a shell script that will: 1. connect to an oracle database 2. execute a query 3. save the output to a csv file I know that I can execute the sqlplus -s user/pass @dbsid and get logged in. What I would like to do is have my query in a separate text... (9 Replies)
Discussion started by: bbbngowc
9 Replies

LEARN ABOUT DEBIAN

cracklib-unpacker

cracklib-format(8)					      Debian GNU/Linux manual						cracklib-format(8)

NAME

       cracklib-format, cracklib-packer, cracklib-unpacker - cracklib dictionary utilities

SYNOPSIS

       cracklib-format file ...

       cracklib-packer cracklib_dictpath

       cracklib-unpacker cracklib_dictpath

DESCRIPTION

       cracklib-format	takes a list of text files each containing a list of words, one per line, It lowercases all words, removes control charac-
       ters, and sorts the lists.  It outputs the cleaned up list to standard output.  The text files may be optionally compressed with gzip(1).

       If you supply massive amounts of text to cracklib-format you must have enough free space available for use by the sort(1) command.  If  you
       do not have 20Mb free in /var/tmp (or whatever temporary area your sort(1) command uses), have a look at the /usr/sbin/cracklib-format pro-
       gram which is a sh(1) program.  You can usually tweak the sort(1) command to use any large area of disk	you  desire,  by  use  of  the	-T
       option.	cracklib-format has a hook for this.

       cracklib-packer	reads  from  standard input a list of sorted and cleaned words and creates a database in the directory and prefix given by
       the command line argument cracklib_dictpath.  Three files are created with the suffixes of .hwm, .pwd, and .pwi.  These three files are	in
       the  format  that  the  FascistCheck(3) subroutine, cracklib-unpacker(8), and cracklib-check(8), utilities understand.  The number of words
       read and written are printed on stdout(3).

       cracklib-unpacker reads from the database in the directory and prefix given by the command line argument cracklib_dictpath and  outputs	on
       standard output the list of words that make up the database.

       The  database  is in a binary format generated by the utilities cracklib-format(8) and cracklib-packer(8).  On a Debian system the database
       is located in the directory /var/cache/cracklib/cracklib_dict and is generated daily with the program /etc/cron.daily/cracklib.	The  loca-
       tion  is  also  defined	in  the  header  file  crack.h using the constant CRACKLIB_DICTPATH though none of the subroutines in the cracklib
       libraries have this location hardcoded into their implementations.

FILES

       /var/cache/cracklib/cracklib_dict.[hwm|pwd|pwi]
	      cracklib dictionary database files used by utilities.

       /etc/cron.daily/cracklib
	      cracklib daily cron program to rebuild the cracklib dictionary database.

       /etc/cracklib/cracklib.conf
	      cracklib configuration file used by the cracklib daily cron program to rebuild the cracklib dictionary database.

       /usr/include/crack.h
	      cracklib header file defining the subroutine FascistCheck(3) and the constant CRACKLIB_DICTPATH used to compile in the  location	of
	      the cracklib dictionary database for these utilities.

       /usr/sbin/cracklib-format
	      cracklib shell script to create initial list of words for dictionary database.

SEE ALSO

       FascistCheck(3), cracklib-check(8), update-cracklib(8), create-cracklib-dict(8)
       /usr/share/doc/libcrack2/libcrack2.html
       /usr/share/doc/cracklib-runtime/cracklib-runtime.html

AUTHOR

       cracklib2 is written by Alec Muffett <alecm@crypto.dircon.co.uk>. Manual added by Jean Pierre LeJacq <jplejacq@quoininc.com>.

2.7-8.5 						   Sat Jun 21 22:43:12 CEST 2008					cracklib-format(8)
All times are GMT -4. The time now is 08:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy