10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
2. Solaris
I got a issue with running the following script below if I remove the inserts and alter table the tables will install just fine but if I try and do the full thing in one go i get the below error dose any one have any ideas on this problem?
its got me spinning, thanks.
REM
REM List of... (1 Reply)
Discussion started by: Wpgn
1 Replies
3. Shell Programming and Scripting
Hi,
This may not be the right forum but i am hoping someone knows an answer to this.
I have to capture rows for a column that was deleted. How can i do that without having to write a select query?
delete from myschema.mytable where currentdatetimestamp > columnDate
this should delete 5... (4 Replies)
Discussion started by: jakSun8
4 Replies
4. Shell Programming and Scripting
Hi, can anyone help me with this script please. I need the oracle command to go into the unix batch file.
#!/bin/sh
# A menu driven Shell script which has following options
# for acmtoron@>
#
#
# Exit
# As per option do the job
#----
while :
do
clear
echo " A C M LOG MONITORING... (0 Replies)
Discussion started by: tinaaguilera
0 Replies
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
Hello,
I am ftping the file from one unix box to another box. This script works fine. Only problem here is, it is asking the password when ftp the file. How can i stop that. I am providing the password inside the shell script. But it is not accepting this. I need to put this script in crontab.... (5 Replies)
Discussion started by: govindts
5 Replies
7. Shell Programming and Scripting
Hi Friends,
Do someone know how to capture value in a shell variable from oracle sql?
Requirement : In a table we want to count the number of records and want to pass this value to a shell variable where it can be manipulated later. In ksh shell we open oracle connection from sqlplus.
For... (1 Reply)
Discussion started by: sourabhsharma
1 Replies
8. AIX
hi there,
Please help me
How transfer sql file from one server to another without username and password .i know just IP address.
Thanks
Arpit (1 Reply)
Discussion started by: Arpitmitm
1 Replies
9. Shell Programming and Scripting
I've a script that fetches various values from the database as below:
#! /bin/ksh
$conn="user/pwd@service_name"
`sqlplus -s << $conn EOF1
@xyz.sql
@pqr.sql
@abc.sql
EOF1`
The output of the script should generate txt files containing the results from queries which are further... (6 Replies)
Discussion started by: manthasirisha
6 Replies
10. Shell Programming and Scripting
I have a shell script which resides on three SCO machines containing some simple sqlplus statments. I need to run these scripts remotely. Currently, I am trying to use rsh to do so:
rsh hostname myscript args
The problem is that the arguments to the sqlplus statements in the remote shell... (4 Replies)
Discussion started by: Madbreaks
4 Replies
Mason::Filters::Standard(3pm) User Contributed Perl Documentation Mason::Filters::Standard(3pm)
NAME
Mason::Filters::Standard - Standard filters
DESCRIPTION
These filters are automatically composed into Mason::Component.
FILTERS
Capture ($ref)
Uses "$m->capture" to capture the content in $ref instead of outputting it.
% $.Capture(my $content) {{
<!-- this will end up in $content -->
% }}
... do something with $content
CompCall ($path, @args...)
Calls the component with path and @args, just as with "$m->scomp", with an additional coderef argument "yield" that can be invoked to
generate the content. Arguments passed to "yield" can be accessed inside the content via @_. This is the replacement for Mason 1's
Components With Content <http://search.cpan.org/perldoc?HTML::Mason::Devel#Component_Calls_with_Content>.
In index.mc:
% $.CompCall ('list_items.mi', items => @items) {{
<li><% $_[0] %></li>
% }}
In list_items.mi:
<%class>
has 'items';
has 'yield';
</%class>
% foreach my $item (@{$.items}) {
<% $.yield->($item) %>
% }
NoBlankLines
Remove lines with only whitespace from content. This
% $.NoBlankLines {{
hello
world
% }}
yields
hello
world
Repeat ($count)
Repeat the content block $count times. Note that the block is re-executed each time, which may result in different content.
<!-- Prints 1 to 5 -->
% my $i = 1;
% $.Repeat(5) {{
<% $i++ %><br>
% }}
Tee ($ref)
Uses "$m->capture" to capture the content in $ref, and also output it.
% $.Tee(my $content) {{
<!-- this will end up in $content and also be output -->
% }}
...
<!-- output content again down here -->
<% $content %>
Trim
Remove whitespace from the beginning and end of the content.
SEE ALSO
Mason::Manual::Filters, Mason
AUTHOR
Jonathan Swartz <swartz@pobox.com>
COPYRIGHT AND LICENSE
This software is copyright (c) 2011 by Jonathan Swartz.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
perl v5.14.2 2012-05-02 Mason::Filters::Standard(3pm)
