linux operating commands and unix operating commands

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

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. 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...

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...

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);...

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...

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

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...

LEARN ABOUT DEBIAN

sql::translator::parser::oracle

SQL::Translator::Parser::Oracle(3pm)			User Contributed Perl Documentation		      SQL::Translator::Parser::Oracle(3pm)

NAME

       SQL::Translator::Parser::Oracle - parser for Oracle

SYNOPSIS

	 use SQL::Translator;
	 use SQL::Translator::Parser::Oracle;

	 my $translator = SQL::Translator->new;
	 $translator->parser("SQL::Translator::Parser::Oracle");

DESCRIPTION

       From http://www.ss64.com/ora/table_c.html:

	CREATE [GLOBAL TEMPORARY] TABLE [schema.]table (tbl_defs,...)
	    [ON COMMIT {DELETE|PRESERVE} ROWS]
		[storage_options | CLUSTER cluster_name (col1, col2,... )
		   | ORGANIZATION {HEAP [storage_options]
		   | INDEX idx_organized_tbl_clause}]
		      [LOB_storage_clause][varray_clause][nested_storage_clause]
			  partitioning_options
			     [[NO]CACHE] [[NO]MONITORING] [PARALLEL parallel_clause]
				[ENABLE enable_clause | DISABLE disable_clause]
				    [AS subquery]

       tbl_defs:
	  column datatype [DEFAULT expr] [column_constraint(s)]
	  table_ref_constraint

       storage_options:
	  PCTFREE int
	  PCTUSED int
	  INITTRANS int
	  MAXTRANS int
	  STORAGE storage_clause
	  TABLESPACE tablespace
	  [LOGGING|NOLOGGING]

       idx_organized_tbl_clause:
	  storage_option(s) [PCTTHRESHOLD int]
	    [COMPRESS int|NOCOMPRESS]
		[ [INCLUDING column_name] OVERFLOW [storage_option(s)] ]

       nested_storage_clause:
	  NESTED TABLE nested_item STORE AS storage_table
	     [RETURN AS {LOCATOR|VALUE} ]

       partitioning_options:
	  Partition_clause {ENABLE|DISABLE} ROW MOVEMENT

       Column Constraints (http://www.ss64.com/ora/clause_constraint_col.html)

	  CONSTRAINT constrnt_name {UNIQUE|PRIMARY KEY} constrnt_state

	  CONSTRAINT constrnt_name CHECK(condition) constrnt_state

	  CONSTRAINT constrnt_name [NOT] NULL constrnt_state

	  CONSTRAINT constrnt_name REFERENCES [schema.]table[(column)]
	     [ON DELETE {CASCADE|SET NULL}] constrnt_state

       constrnt_state
	   [[NOT] DEFERRABLE] [INITIALLY {IMMEDIATE|DEFERRED}]
	      [RELY | NORELY] [USING INDEX using_index_clause]
		 [ENABLE|DISABLE] [VALIDATE|NOVALIDATE]
		     [EXCEPTIONS INTO [schema.]table]

       Note that probably not all of the above syntax is supported, but the grammar was altered to better handle the syntax created by
       DDL::Oracle.

AUTHOR

       Ken Youens-Clark <kclark@cpan.org>.

SEE ALSO

       SQL::Translator, Parse::RecDescent, DDL::Oracle.

perl v5.14.2							    2012-01-18				      SQL::Translator::Parser::Oracle(3pm)