file in to the column of the table

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split column data if the table has n number of column's with some record

Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records Table --------- Col1 col2 col3 col4 ....................col20 1 2 3 4 .................... 20 a b c d .................... v ...

2. Shell Programming and Scripting

Split column data if the table has n number of column's

please write a shell script Table -------------------------- 1 2 3 a b c 3 4 5 c d e 7 8 9 f g h Output should be like this --------------- 1 2 3 3 4 5 7 8 9 a b c c d e f g h

3. Shell Programming and Scripting

Verification of file name with table column

I am trying to generate code 1. move entire list of file names with specific pattern(standard patterned name for example file name is <process>_<country>_<yymmdd>) in a directory to a variable 2. Use variable in netezza code to check file name exist in a table or not? for example: Employee...

4. Shell Programming and Scripting

Construct 3 column table from one column list

Hi all! trying my best to parse a public site for information (ie fiscal year and turnover) about corporations. Doing this by having a file with business name and registration number (search key) the file bolag.txt currently looks like this Burgundy 556732-7217 AcademicSearch 556406-9879...

5. Shell Programming and Scripting

From column to table

Hi, I have an ascii file containing information. This file is n x m lines. Is there a way to generate an ascii file where the information is stored as n x m table instead? The m columns should be tab separated. Thanks a lot, Sarah

6. UNIX for Advanced & Expert Users

Data from table to column

Hi All, in bash I have a text file which is something like 7.96634E-07 1.0000 0.00000E+00 0.0000 0.00000E+00 0.0000 1.59327E-06 0.7071 2.23058E-05 0.1890 6.61207E-05 0.1098 1.13919E-04 0.0865 1.47377E-04 0.0747 .... .... 0.00000E+00 0.0000 0.00000E+00 0.0000 ...

7. UNIX for Dummies Questions & Answers

average of a column in a table

Hello, Is there a quick way to compute the average of a column data in a numerical tab delimeted file? Thanks, Gussi

8. Shell Programming and Scripting

To update a column in a table through shell script

Hi All, I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking. Something like this, through...

9. Shell Programming and Scripting

First Script: Query every table with column xxx.

Hi all, Im new to scripting and have no idea how to start this. Recently I had to Query an Oracle database to find a count(distinct version) from every single table inside. I want to write this up into a script for the future. I have a template to connect to the database, so that is not the...

LEARN ABOUT DEBIAN

dbix::searchbuilder::handle::oracle

DBIx::SearchBuilder::Handle::Oracle(3pm)		User Contributed Perl Documentation		  DBIx::SearchBuilder::Handle::Oracle(3pm)

NAME

	 DBIx::SearchBuilder::Handle::Oracle - An oracle specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of Oracle.

METHODS

   Connect PARAMHASH: Driver, Database, Host, User, Password
       Takes a paramhash and connects to your DBI datasource.

   BuildDSN
       Customized version of "BuildDSN" in DBIx::SearchBuilder::Handle method.

       Takes additional argument SID. Database argument used unless SID provided.  Two forms of DSN are generated depending on whether Host
       defined or not:

	   dbi:Oracle:sid=<SID>;host=...[;port=...]
	   dbi:Oracle:<SID>

       Read details in documentation for DBD::Oracle module.

   Insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

   InsertFromSelect
       Customization of "InsertFromSelect" in DBIx::SearchBuilder::Handle.

       Unlike other DBs Oracle needs:

       o   id generated from sequences for every new record.

       o   query wrapping in parens.

       NOTE that on Oracle there is a limitation on the query. Every column in the result should have unique name or alias, for example the
       following query would generate "ORA-00918: column ambiguously defined" error:

	   SELECT g.id, u.id FROM ...

       Solve with aliases:

	   SELECT g.id AS group_id, u.id AS user_id FROM ...

   KnowsBLOBs
       Returns 1 if the current database supports inserts of BLOBs automatically.  Returns undef if the current database must be informed of BLOBs
       for inserts.

   BLOBParams FIELD_NAME FIELD_TYPE
       Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type.  The current
       Oracle implementation only supports ORA_CLOB types(112).

   ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
       takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;

   DistinctQuery STATEMENTREF
       takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.

   BinarySafeBLOBs
       Return undef, as Oracle doesn't support binary-safe CLOBS

   DatabaseVersion
       Returns value of ORA_OCI constant, see "Constants" in DBI.

   SimpleDateTimeFunctions
       Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.

   ConvertTimezoneFunction
       Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.

       Use the following query to get list of timezones:

	   SELECT tzname FROM v$timezone_names;

       Read Oracle's docs about timezone files:

	   http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       perl(1), DBIx::SearchBuilder

perl v5.14.2							    2011-09-21				  DBIx::SearchBuilder::Handle::Oracle(3pm)

Shell Programming and Scripting