insert query help Post: 302558448

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I insert x'0D' ?

I'm directing output to a *.dat file. The first byte is a variable, the second must be a carriage-return (x'0D'). Is there a UNIX equivalent of an ASCII command that will allow me to output this byte?

2. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1...

3. Shell Programming and Scripting

need to create a insert query for a file

Hi Guys, I need to create a insert query for the below file Fri Sep 4 06:25:51 2009 ACTION : 'CREATE INDEX S100S_DC.PLInsuranceReportRules_testI1 ON S100S_DC.PLInsuranceReportRules_test1(ENTITY_KEY)' DATABASE USER: '/' PRIVILEGE : SYSDBA CLIENT USER: oracle CLIENT TERMINAL: pts/3...

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

5. Programming

SQL : Fine tune Insert by query

i would like to know how can i fine tune the following query since the cost of the query is too high .. insert into temp temp_1 select a,b,c,d from xxxx .. database used is IDS..

6. Shell Programming and Scripting

How to use a variable in insert query?

My script contains as follows, VALUE=`sqlplus un/pwd <<EOF > OB.txt set pagesize 0 feedback off verify off heading off echo off select max(1) from table1; exit; EOF` insert into table2 values(1, 'The max value is $value',...); i need the value of VALUE to be inserted after 'The max...

7. Shell Programming and Scripting

Forming an insert query using awk

Hi, I'm trying to form an insert sql query using shell programming. I have table named company with four columns 'company name', 'company id', 'company code' and 'last change id' I have to read the company name, company code and last change id from a file delimited by | which has around 10...

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

Insert query with shell variable with AWK

Hi, I'm a first timer with Unix so pardon my ignorance. I'm trying to read a comma separated file from the same folder where the script is and insert the value in a DB2 table. I'm using AWK for the same. I'm getting `)' not expected error. I'm not sure but for me it doesn't look like detailed...

10. 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',...

LEARN ABOUT PHP

udm_find

UDM_FIND(3)								 1							       UDM_FIND(3)

udm_find - Perform search

SYNOPSIS

       resource udm_find (resource  $agent, string  $query)

DESCRIPTION

	Performs a search.

	The search itself. The first argument - session, the next one - query itself. To find something just type words you want to find and press
       SUBMIT button. For example, "mysql odbc". You should not use quotes " in query, they are written here only to divide  a	query  from  other
       text.  mnoGoSearch  will find all documents that contain word "mysql" and/or word "odbc". Best documents having bigger weights will be dis-
       played first. If you use search mode ALL, search will return documents that contain both (or more) words you entered. In case you use  mode
       ANY,  the  search  will	return	list of documents that contain any of the words you entered. If you want more advanced results you may use
       query language. You should select "bool" match mode in the search from.

PARAMETERS

	      o $agent
		- A link to Agent, received after call to udm_alloc_agent(3).

	      o $query
		- mnoGoSearch understands the following boolean operators:  & - logical AND. For example, "mysql & odbc".  mnoGoSearch	will  find
		any  URLs  that  contain  both "mysql" and "odbc".  | - logical OR. For example "mysql|odbc". mnoGoSearch will find any URLs, that
		contain word "mysql" or word "odbc".  ~ - logical NOT. For example "mysql & ~odbc". mnoGoSearch will find URLs that  contain  word
		"mysql"  and  do  not  contain word "odbc" at the same time. Note that ~ just excludes given word from results. Query "~odbc" will
		find nothing!  () - group command to compose more complex queries. For example "(mysql | msql) &  ~postgres".  Query  language	is
		simple and powerful at the same time. Just consider query as usual boolean expression.

RETURN VALUES

	Returns a result link identifier on success or FALSE on failure.

PHP Documentation Group 													       UDM_FIND(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do I insert x'0D' ?

Discussion started by: rchuttke

2. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

Discussion started by: hazno

3. Shell Programming and Scripting

need to create a insert query for a file

Discussion started by: mac4rfree

4. Shell Programming and Scripting

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

Discussion started by: balaeswari