Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: To pass one month range in sql script
Top Forums UNIX for Advanced & Expert Users To pass one month range in sql script Post 302964743 by rohit_shinez on Monday 18th of January 2016 04:59:32 PM
Old 01-18-2016
Guys can any one advise??
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pass multiple variables to SQL script

I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time. ## Accept variable(s) from the command line... (1 Reply)
Discussion started by: jagannatha
1 Replies

2. Shell Programming and Scripting

pass input arguements to DB2 SQL script

Hi all, I have a shell script which invoke a sql script using command db2 -tf /home/me/db_housekeep.sql -z /home/me/db_housekeep.log however, this mentioned sql script requires several input arguments, I wonder if one can pass variables from shell script to sql script? thanks! (0 Replies)
Discussion started by: mpang_
0 Replies

3. Shell Programming and Scripting

How to pass pl/sql table values to shell script

Hello, i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies

4. Shell Programming and Scripting

Pass a variable to SQL script

Hi Guys, I like to pass a variable to a sql file in a unix script.. I tried a below code.. var=200903 db2 -vf test.sql 200903 test.sql is as below. select * from db2.users where quarter = $1; Please tell me where i go wrong.. Thanks in advance, Magesh (2 Replies)
Discussion started by: mac4rfree
2 Replies

5. UNIX for Advanced & Expert Users

How to use parameter in sql script pass from unix script?

Hi, I am unable to use parameter in sql script passed from unix script. my sql script CREATE_SBI_LIST_GROUP.sql is like this - ------------------------------- SELECT SDS.ID "SO_ID", SDS.SO a1, sgp.sga__code SGA_CODE, FROM sga sga,sales_genl_provision sgp , comm_product_condn cpc... (2 Replies)
Discussion started by: apskaushik
2 Replies

6. Shell Programming and Scripting

How to put date range from a perl & sql script

Hi Guys, Can someone please help me on adding/inserting a variable date to an sql scipt? Basically I want to assign a 7 days date range. As shown below.. #!/usr/bin/perl use strict; use Env qw(ORACLE_HOME); my $SQLPLUS='/opt/oracle/product/10.1.0/db_1/bin/sqlplus -S... (1 Reply)
Discussion started by: pinpe
1 Replies

7. Shell Programming and Scripting

pass null value to sql script from korn shell script

There are 4 parameters that I have to pass from korn shell to sql script. 1) I have to check if $1 , $2 , $3 and $4 are null values or not . How can I do that ? 2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies

8. Shell Programming and Scripting

How to add decimal month to some month in sql, php, perl, bash, sh?

Hello, i`m looking for some way to add to some date an partial number of months, for example to 2015y 02m 27d + 2,54m i need to write this script in php or bash or sh or mysql or perl in normal time o unix time i`m asking or there are any simple way to add partial number of month to some... (14 Replies)
Discussion started by: bacarrdy
14 Replies

9. Shell Programming and Scripting

How to pass Oracle sql script as argument to UNIX shell script?

Hi all, $ echo $SHELL /bin/bash Requirement - How to pass oracle sql script as argument to unix shell script? $ ./output.sh users.sql Below are the shell scripts and the oracle sql file in the same folder. Shell Script $ cat output.sh #!/bin/bash .... (7 Replies)
Discussion started by: a1_win
7 Replies

10. Shell Programming and Scripting

Unable to pass value from .Shell script to .SQL file

Hi All, I am new to shell script. I am trying to pass value from .sh file to .sql file . But I am able to run the .sql file from .sh file with values in sql file. But I am unable to pass the values from .sh file. can some one please help to resolve this. here is my .sh file s1.sh ... (4 Replies)
Discussion started by: reddy298599
4 Replies

LEARN ABOUT DEBIAN

xml::rss::headline::fark

XML::RSS::Headline::Fark(3pm)				User Contributed Perl Documentation			     XML::RSS::Headline::Fark(3pm)

NAME

       XML::RSS::Headline::Fark - XML::RSS::Headline Example Subclass

VERSION

       2.2

SYNOPSIS

       Strip out the extra Fark redirect URL and strip out the various [blahblah] blocks in the headline

	   use XML::RSS::Feed;
	   use XML::RSS::Headline::Fark;
	   use LWP::Simple qw(get);

	   my $feed = XML::RSS::Feed->new(
	       name  => "fark",
	       url   => "http://www.pluck.com/rss/fark.rss",
	       hlobj => "XML::RSS::Headline::Fark",
	   );

	   while(1) {
	       $feed->parse(get($feed->url));
	       print $_->headline . "
" for $feed->late_breaking_news;
	       sleep($feed->delay);
	   }

       Here is the before output in #news on irc.perl.org

	   <rssbot>  - [Sad] Elizabeth Edwards diagnosed with breast cancer
	   <rssbot>    http://go.fark.com/cgi/fark/go.pl?IDLink=1200026&location=http://www.msnbc.msn.com/id/6408022

       and here is the updated output

	   <rssbot>  - Elizabeth Edwards diagnosed with breast cancer
	   <rssbot>    http://www.msnbc.msn.com/id/6408022

MUTAITED METHOD

       $headline->item( $item )
	   Init the object for a parsed RSS item returned by XML::RSS.

AUTHOR

       Jeff Bisbee, "<jbisbee at cpan.org>"

BUGS

       Please report any bugs or feature requests to "bug-xml-rss-feed at rt.cpan.org", or through the web interface at
       <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=XML-RSS-Feed>.  I will be notified, and then you'll automatically be notified of progress
       on your bug as I make changes.

SUPPORT

       You can find documentation for this module with the perldoc command.

	   perldoc XML::RSS::Headline::Fark

       You can also look for information at:

       * AnnoCPAN: Annotated CPAN documentation
	   <http://annocpan.org/dist/XML-RSS-Feed>

       * CPAN Ratings
	   <http://cpanratings.perl.org/d/XML-RSS-Feed>

       * RT: CPAN's request tracker
	   <http://rt.cpan.org/NoAuth/Bugs.html?Dist=XML-RSS-Feed>

       * Search CPAN
	   <http://search.cpan.org/dist/XML-RSS-Feed>

ACKNOWLEDGEMENTS

       Special thanks to Rocco Caputo, Martijn van Beers, Sean Burke, Prakash Kailasa and Randal Schwartz for their help, guidance, patience, and
       bug reports. Guys thanks for actually taking time to use the code and give good, honest feedback.

COPYRIGHT &; LICENSE
       Copyright 2006 Jeff Bisbee, all rights reserved.

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

       XML::RSS::Feed, XML::RSS::Headline, XML::RSS::Headline::PerlJobs, XML::RSS::Headline::UsePerlJournals, POE::Component::RSSAggregator

perl v5.8.8							    2006-07-17					     XML::RSS::Headline::Fark(3pm)
All times are GMT -4. The time now is 03:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy