09-11-2008
Filtering and Grouping: A Comparison of SQL, Linux Scripting, and Ruby
Learn some of the transferable concepts common to Oracle SQL, Linux commands, and scripting to address problems that involve data sets that need to be grouped, sorted, and filtered.
More...
7 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
STORAGE_TYPE=$1
echo "########### SQL SESSION STARTED ###########"
VALUE=`sqlplus -S /nolog << THEEND
connect tcupro/tcupro_dev@bdd1optn
SET SERVEROUTPUT ON
DECLARE
V_STORAGE_TYPE varchar2(3);
V_ERR_MSG varchar2(255) ;
V_LOG_LEVEL varchar2(200);
BEGIN... (1 Reply)
Discussion started by: piscean_n
1 Replies
2. Shell Programming and Scripting
Hi,
I need sample code to compare the two files line by line which contains text strings and to print the difference in the third file.
Thanks in advance (1 Reply)
Discussion started by: sudhakaryadav
1 Replies
3. Shell Programming and Scripting
Still new to bash. Using debian lenny 5, bash version 3.2.39. I'm working on three scripts. I need help completing them.
One script that inputs a plain text file, echo then chop it up into separate whitespace-delimited strings as an output. Not sure how to do this...
for example, the... (4 Replies)
Discussion started by: l20N1N
4 Replies
4. Shell Programming and Scripting
Hi,
I have an array of strings. Each string has 4 comma separated values. I am binding this array to a SQL where I am required to do an INSERT after grouping.
The binding is done as :
$insertADWSth->bind_param_array(1,A_CONSTANT_STRING);... (1 Reply)
Discussion started by: sinpeak
1 Replies
5. UNIX for Advanced & Expert Users
I have a scenario to implement in Korn shell script. Here it is..
I need to compare two values to see whether they are same or not. The issue is that the values coming in for comparison can be a string or an integer which can be determined during run time only.
Which korn shell comparison... (2 Replies)
Discussion started by: vani123
2 Replies
6. Programming
Hello people, I'm scratching my head to find a solution to this query.
I have a simple SQL table:
data | tot
==================
111201/0000 | 3
111201/0001 | 5
111201/0002 | 7
111201/0003 | 2
.....
111201/0059 | 1
111201/0100 | 5
111201/0101 | 8
111201/0102 | 6... (7 Replies)
Discussion started by: Lord Spectre
7 Replies
7. Shell Programming and Scripting
I need following code in linux bash:
Step 1:
run a command and create file1
run a command and create file2
compare file1 and 2
if any difference go to step 1 (keep trying 4 times, if no success, abort program)
else do nothing and continue program.
now I'm... (2 Replies)
Discussion started by: kashif.live
2 Replies
LEARN ABOUT DEBIAN
urn-scheme
uri_urn(3tcl) Tcl Uniform Resource Identifier Management uri_urn(3tcl)
__________________________________________________________________________________________________________________________________________________
NAME
uri_urn - URI utilities, URN scheme
SYNOPSIS
package require Tcl 8.2
package require uri::urn ?1.1.2?
uri::urn::quote url
uri::urn::unquote url
_________________________________________________________________
DESCRIPTION
This package provides two commands to quote and unquote the disallowed characters for url using the urn scheme, registers the scheme with
the package uri, and provides internal helpers which will be automatically used by the commands uri::split and uri::join of package uri to
handle urls using the urn scheme.
COMMANDS
uri::urn::quote url
This command quotes the characters disallowed by the urn scheme (per RFC 2141 sec2.2) in the url and returns the modified url as its
result.
uri::urn::unquote url
This commands performs the reverse of ::uri::urn::quote. It takes an urn url, removes the quoting from all disallowed characters,
and returns the modified urls as its result.
BUGS, IDEAS, FEEDBACK
This document, and the package it describes, will undoubtedly contain bugs and other problems. Please report such in the category uri of
the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883]. Please also report any ideas for enhancements you may have for
either package and/or documentation.
KEYWORDS
rfc 2141, uri, url, urn
CATEGORY
Networking
uri 1.1.2 uri_urn(3tcl)