Perl Query Regarding format

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to create a file from output of vertica table query in UTF-8 format?

Hello, In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data. file -i filename.csv - gives...

2. Programming

Sybase ASE: Query to find correct format issue.

Hi Team , I am new to Sybase Adaptive Server Enterprise/15.7 (ASE) and need some guidance to find the different values in serial format column. SELECT DISTINCT SERIAL_FORMAT FROM PRODUCTS It has values with below format which contains 12 digits hexadecimal characters with...

3. Shell Programming and Scripting

Mailing query results in tabular format

Hi , I am purging two tables based on date. In my script I am taking the count of the tables purging them and then taking the after counts. I need to mail the before and after counts of the two tables in a mail in table format as mentioned in the result section. For Eg: ## Count of the...

4. Shell Programming and Scripting

From sql Insert Query to XML format

Hi How do I translate Let say Cat inserts.sql gives Insert into PM9_TAXATION_ROUNDING (STATE_GECODE, TAX_TYPE, TAX_AUTHORITY, SYS_CREATION_DATE, SYS_UPDATE_DATE, APPLICATION_ID, DL_SERVICE_CODE, ROUNDING_METHOD) Values ('xx', 'xx', 'x', TO_DATE('10/26/2012 13:01:20',...

5. Shell Programming and Scripting

perl module to convert xlsx format to xls format

Hi Folks, I have written a perl script that reads data from excel sheet(.xls) using Spreadsheet::ParseExcel module. But the problem is this module doesn't work for excel sheets with extension .xlsx. I have gone through Spreadsheet::XLSX module with which we can read from .xlsx file directly....

6. Shell Programming and Scripting

Need help getting my output from MYSQL query into right format

Good afternoon! I have been lurking in this forum for awhile now. I have just recently started posting. I think this is a really good site. With that being said, I don't like to just run and get an answer before I try my best first. I have poured some blood, sweat and tears into...

7. Shell Programming and Scripting

Convertion of Date Format using SQL query in a shell script

When I write Select date_field from TableA fetch first row only I am getting the output as 09/25/2009. I want to get the output in the below format 2009-09-25 i.e., MM-DD-YYYY. Please help

8. Shell Programming and Scripting

How to Format the result driven from a SQL Query

Hi All, I want to format the result driven from the query into neat format. For example pls find the below code, #! /bin/sh result=' sqlplus -s uname/passwrd@DBname select no,name,address,ph_no, passport_no,salary,designation from emp_table where salary>1000; exit EOF' ...

9. Shell Programming and Scripting

Displaying the data from the select query in a particular format

Hi, I have a shell script that returns 10 records for the column Name and age from a select query. Where when i store those data in retrieve_list.txt file i need to store the data in a particular format like:- $Jason$30 $Bill$23 $Roshan$25 Here is my script: 1)...

10. Shell Programming and Scripting

sed format query

hi how to do the following. If the input is ACCOUNT= 400 QT = 65 CAPT =85 NT = 5 the output should be ACCOUNT= 40 QT = 15 CAPT =37 NT = 90 I want the corresponding values to be changed to new values. hlp

LEARN ABOUT DEBIAN

plucene::search::query

Plucene::Search::Query(3pm)				User Contributed Perl Documentation			       Plucene::Search::Query(3pm)

NAME

       Plucene::Search::Query - base class for queries

SYNOPSIS

	       my $s_query = Plucene::Search::Query::Subclass->new({
		       boost => $boost_factor});

	       my $scorer = $s_query->scorer($query, $searcher, $reader);

DESCRIPTION

       This is an abstract base class for queries.

       A query is a specification of the content an properties of the desired documents. Every search is done by matching a query against the
       document index and locating the ones that match the query.

       The simplest query specifies a single term (or word) that is to be matched against a single field (e.g. 'author') of each of the documents
       in the index.  This kind of query matches any document that contains the term in the specified field.

       A more complex queries may contain nested queries with 'and', 'or', 'not' or 'phrase' relations. Queries may also contains specification of
       which document fields to match against the various parts of the query (.e.g.  'authors' and 'title') and hints that may effects the ranking
       of the matched documents ('boost' factor).

METHODS

   new
	       my $s_query = Plucene::Search::Query::Subclass->new({
		       boost => $boost_factor});

   boost
       Get / set this attribute

   scorer
	       my $scorer = $s_query->scorer
		       (Plucene::Search::Query $query, $searcher, $reader);

   prepare
       Does nothing

   sum_squared_weights / normalize  / _scorer
       These must be defined in a subclass

perl v5.12.4							    2011-08-14					       Plucene::Search::Query(3pm)

Shell Programming and Scripting