learn unix and linux commands

Filtering and Grouping: A Comparison of SQL, Linux Scripting, and Ruby


 
Thread Tools Search this Thread
# 1  
Old 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...
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparison of two file using bash 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

2. Programming

SQL Grouping SUM

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

3. UNIX for Advanced & Expert Users

Comparison in Korn shell scripting

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

4. Shell Programming and Scripting

PERL : SQL array bind issue while grouping

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. Shell Programming and Scripting

text processing and filtering 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

6. Shell Programming and Scripting

Comparison of two files which contains strings using Shell scripting or PERL

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

7. Shell Programming and Scripting

comparison of strings in unix shell 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
Login or Register to Ask a Question
SQL::ReservedWords::SQLServer(3pm)			User Contributed Perl Documentation			SQL::ReservedWords::SQLServer(3pm)

NAME
SQL::ReservedWords::SQLServer - Reserved SQL words by SQL Server SYNOPSIS
if ( SQL::ReservedWords::SQLServer->is_reserved( $word ) ) { print "$word is a reserved SQL Server word!"; } DESCRIPTION
Determine if words are reserved by SQL Server. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by SQL Server 7, 2000 or 2005. is_reserved_by_sqlserver7( $word ) Returns a boolean indicating if $word is reserved by SQL Server 7. is_reserved_by_sqlserver2000( $word ) Returns a boolean indicating if $word is reserved by SQL Server 2000. is_reserved_by_sqlserver2005( $word ) Returns a boolean indicating if $word is reserved by SQL Server 2005. reserved_by( $word ) Returns a list with SQL Server versions that reserves $word. words Returns a list with all reserved words. EXPORTS
Nothing by default. Following subroutines can be exported: is_reserved is_reserved_by_sqlserver7 is_reserved_by_sqlserver2000 is_reserved_by_sqlserver2005 reserved_by words SEE ALSO
http://msdn2.microsoft.com/en-us/library/ms130214.aspx AUTHOR
Christian Hansen "chansen@cpan.org" COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.8.8 2008-03-28 SQL::ReservedWords::SQLServer(3pm)