|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
How to compare to values returned from sql in shell scripting?
Post 302803647 by ramsavi on Tuesday 7th of May 2013 07:11:38 AM
05-07-2013
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want to extract data from database table to a flat file using shell scripting. For loading data from file to a table, I had used SQL Loader. How can I do the vice versa using shell scripting.
Thanks in advance (3 Replies)
Discussion started by: sendhil
3 Replies
2. Shell Programming and Scripting
Hi,
I have a file that has contents like this:
SQL> select * from details;
NAME REG
-------------------- ----------
Mani 1
Santosh 2
Manju 3
Mukesh 4
SQL> spool off;
... (5 Replies)
Discussion started by: sendhilmani123
5 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have a file containing the following data:
junk123junk723itemcode001qty01price10total10junkjunk
junk123junk723itemcode002qty02price10total20junkjunk
..
..
..
could be 5000+ lines
I have an algo and need a code to implement this:
1. Linecount = wc -l (should give 5000)
2. For i... (1 Reply)
Discussion started by: shiroh_1982
1 Replies
4. Shell Programming and Scripting
hi
iam new of scipiting.give me the some Material of regarding sql in scripting.
and i have no backup's in 3 severs.how to write script in dirctory.
please give me some usefull information
cheers
Naveen.g (2 Replies)
Discussion started by: naveeng.81
2 Replies
5. Shell Programming and Scripting
Hi guyz,
Posting a thread after a long time.
I want to pass two variables to unix shell script from sql script.
Note: I am calling sql script from unix script. sql script has 2 variables one is the return code for status of program run and second one email flag. I don't know how to capture... (3 Replies)
Discussion started by: sachin.gangadha
3 Replies
6. Shell Programming and Scripting
Hi,
I am looking for some books that have examples of both Oracle SQL and Shell script being used together. For example, to insert 500 rows into a table using a script. I already have books that cover Shell scripting or SQL, but as separate subjects. I am looking for books that have both of... (3 Replies)
Discussion started by: handle123
3 Replies
7. Shell Programming and Scripting
Hi,
I need to write a shell script file that does
1)Connects to DB using SQL plus
2)Do some SQL query like select * from....
3)Based on the output that I got from the sql query I will have to write a if else loop.
Plz let me know how to write the shell scripting for this.
Thanks for... (1 Reply)
Discussion started by: villain41
1 Replies
8. Shell Programming and Scripting
HI friends , i am also facing an issue in mysql
i ma trying to insert detail in a variable but not got success
#!/bin/sh
mysql -u<username> -p<password> <dbname> << EOF
DEV=`mysql --skip-column-names <dbname> -e "SELECT timestamp from process_record where id = 1"`
EOF
echo $DEV
ERROR... (3 Replies)
Discussion started by: sanjay833i
3 Replies
9. Shell Programming and Scripting
hey i have to connect to sql through shell script , then store the value of the query in a variable and then compare it after some time after running a process.
i have used this code but it is not working.
#!/bin/sh
Val = (sqlplus -s rte/rted2@rel76d2 <<!
SELECT MAX(STAT_ID) FROM CVT_STATS;... (3 Replies)
Discussion started by: ramsavi
3 Replies
10. Shell Programming and Scripting
Can anyone please assist me?
I have attached 2 input files and one output file. I need to generate the sql update statements using the above 2 input files. if inputfile2 has 5 rows, then we should generate 5 update statements because column1 is unique. inputfile1 and inputfile2 may contain more... (10 Replies)
Discussion started by: vinus
10 Replies
LEARN ABOUT DEBIAN
test::data::array
Array(3pm) User Contributed Perl Documentation Array(3pm) NAME
Test::Data::Array -- test functions for array variables SYNOPSIS
use Test::Data qw(Array); DESCRIPTION
Functions array_any_ok( ITEM, ARRAY [, NAME] ) Ok if any element of ARRAY is ITEM. array_none_ok( ITEM, ARRAY [, NAME] ) Ok if no element of ARRAY is ITEM. array_once_ok( ITEM, ARRAY [, NAME] ) Ok if only one element of ARRAY is ITEM. array_multiple_ok( ITEM, ARRAY [, NAME] ) Ok if more than one element of ARRAY is ITEM. array_max_ok( NUMBER, ARRAY [, NAME] ) Ok if all elements of ARRAY are numerically less than or equal to NUMBER. array_min_ok( NUMBER, ARRAY [, NAME] ) Ok if all elements of ARRAY are numerically greater than or equal to NUMBER. array_maxstr_ok( ITEM, ARRAY [, NAME] ) Ok if all elements of ARRAY are asciibetically less than or equal to MAX. array_minstr_ok( ITEM, ARRAY [, NAME] ) Ok if all elements of ARRAY are asciibetically greater than or equal to MAX. array_sum_ok( SUM, ARRAY [, NAME] ) Ok if the numerical sum of ARRAY is SUM. array_empty_ok( ARRAY [, NAME] ) Ok if the array contains no elements. array_length_ok( ARRAY, LENGTH [, NAME] ) Ok if the array contains LENGTH number of elements. array_sortedstr_ascending_ok( ARRAY, [, NAME] ) Ok if each succeeding element is asciibetically greater than or equal to the one before. array_sortedstr_descending_ok( ARRAY, [, NAME] ) Ok if each succeeding element is asciibetically less than or equal to the one before. array_sorted_ascending_ok( ARRAY, [, NAME] ) Ok if each succeeding element is numerically greater than or equal to the one before. array_sorted_descending_ok( ARRAY, [, NAME] ) Ok if each succeeding element is numerically less than or equal to the one before. SEE ALSO
Test::Data, Test::Data::Scalar, Test::Data::Function, Test::Data::Hash, Test::Builder SOURCE AVAILABILITY
This source is in Github: http://github.com/briandfoy/test-data/tree/master AUTHOR
brian d foy, "<bdfoy@cpan.org>" COPYRIGHT AND LICENSE
Copyright (c) 2002-2009 brian d foy. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2009-02-12 Array(3pm)