oracle process query ! Post: 302144323

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Oracle Query results to be stored in variables

Hi I would like to know if there is a way to just have one ORACLE connection established, using which we can execute different queries and store the results under different variables. For e.g the following uses to two silent ORACLE connection to store the result under two different...

2. Shell Programming and Scripting

Oracle SQL Query & connect?

Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best...

3. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

4. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance

5. Programming

Oracle Database Query

How can i modify the below to search for the things i'm looking for during a certain time frame? select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc; In this particular case, this query is...

6. Shell Programming and Scripting

PROBLEM WITH ORACLE QUERY IN UNIX SCRIPT

hi Guys, i have a problem with oracle query in my unix script.. I'm getting the following error while executing.. ./logtab.sh: sqlplus -s "pmutv/pmutv1" << EOFSQL^Jset head off^Jinsert into...

7. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks

8. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

9. Programming

Oracle query with field filter

Dear community, I have to make a query from a database and apply the following filter: select filed1,field2,field3 from database where (field1 contains only alphanumeric chars and NOT only numbers) Let me explain better what I Need: 21test ==> OK test ==> OK test21 ==> OK te21st ==>...

10. Programming

MySQL query does not work on Oracle 11g

Dear community, I have to make a "simple" query on ORACLE 11g DB who will output ONLY numbers in field1 who exceeded a specific threshold. In other words, assuming I have the following data in database. FIELD1 FIELD2 FIELD3 ========= ============== ...

LEARN ABOUT DEBIAN

recoll

RECOLL(1)						      General Commands Manual							 RECOLL(1)

NAME

       recoll - user interface for the Recoll full text search system

SYNOPSIS

       recoll [ -c <configdir> ] [ -o | -l | -f | -a ] [ -t ] [ -q <query> ]

DESCRIPTION

       The recoll command will start the graphical user interface for querying the Recoll database.

       On the first run, recoll will create the user configuration which can be customized before starting the first indexation.

       The -c option specifies the configuration directory name, overriding the default or $RECOLL_CONFDIR.

       The  -q	option	can be used to specify an initial query on the command line. This query will be interpreted by default as a query language
       string.	If -a is specified, the query string will be interpreted as an all words simple search query. If -o is specified, the query string
       will  be  interpreted  as  an  any word simple search query. If -f is specified, the query string will be interpreted as a file name simple
       search query. If -l is specified, the query string will be interpreted as a query language simple search query.

       If -t is specified, the Graphical User Interface will not be started, and results will  be  printed  to	the  standard  output.	Additional
       options	understood  by	the  recollq  command may be specified in this case. These can control the output format and the maximum number of
       results to be printed.

       Please refer to online help for a full description.

SEE ALSO

       recollindex(1) recollq(1) recoll.conf(5)

								  8 January 2006							 RECOLL(1)