Sql select replace Post: 302803911

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Pipe SQL select statement results to script

Hello I would like to perform a select from a oracle table and return those values to my shell script For example: site=head -1 $infile | cut -c1-15 | awk '{printf "s%", $0} sqlplus -s /nolog |& #Open pipe to sql select col1, col2, col3, col4 from oracle_table where col5 =...

2. Shell Programming and Scripting

formatting the sql select result

Hi, I have about 12 columns and 15 rows to be retrived from sybase isql command through unix. But when i output the sql into a file and see it, the formatting is going for a toss. can someone please suggest how can i get the result correctly in the output file ? Thanks, Sateesh

3. Web Development

SQL Select inside Insert

I have following. . . . $userid = 2 . $query = "select username from users where userid = ".$userid.";"; . $username = $line; $data="Some Data Here"; . $query = "insert into logger (username, data) valuse ($username, $data);"; . I would like to not have 2 database calls.

4. Shell Programming and Scripting

SQL Select and awk

Dear All , I have file1.txt contain values like the following: ---------- 23 24 25 and I have shell script which has the following : more file1.txt | awk '{print "select 'DUMP',CODE1||'|'||CODE2||'|'||CODE3 from CODE where CODE1='" $1 "';"}' > file2.sql all I need is to have the...

5. Shell Programming and Scripting

Select SQL Queries Option

count.sh#!/bin/ksh SQL1=`sqlplus -s usr/pwd @count.sql $1 $2 $3` SQL2=`sqlplus -s usr/pwd @selectall.sql $1 $2 $3` LIST="Count Select_All" select i in $LIST do if then echo $SQL1 elif then echo $SQL2 fi done

6. Shell Programming and Scripting

using SELECT sql statement in shell script

Hi there I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this SN=123456 n=server1 m=x4140 sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';" echo $sql |/usr/sfw/bin/mysql -h...

7. Shell Programming and Scripting

SQL select all but not if it is already in an other column

I know I know.. for sure one of the easier mysql statements. But somehow I can not figure out this. I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row) data_12 ...

8. Programming

I'm going crazy with SQL select. Please help!

Hello people, as wrote in title I'm going crazy with a "complex" SQL select. This is the seelct: select T_ADDRESS, T_MCC,T_MNC,T_MSIN,T_IM_MNC, COUNT(*) FROM TABLETEST WHERE T_MCC=123 AND (T_MNC=11 OR T_MNC=01) GROUP BY T_ADDRESS,T_MCC,T_MNC,T_MSIN,T_IM_MNC HAVING count(*) > 5;This select...

9. Programming

[Solved] SQL SELECT REPLACE

Hi All, I had a query related to sql select update replace command. i have a table named clusters and it looks like this name model characteristics sample1.1 +123 parent sample1.2 -456 clone sample1.3 +122 ...

10. Shell Programming and Scripting

Parse SQL text and only format first SELECT statement.

Hi Forum. Need your expertise on the following question. I have the following file which I would like to parse, find first block of SELECT statment and concatenate all input fields as 1 field (~ delimited): Old File: SELECT /*+ USE_HASH(CCOMM ICAR IMAP IAS IP IMAS IMPS IAP SPCA) */ ...

LEARN ABOUT OSX

glgetmultisamplefv

GLGETMULTISAMPLEFV(3G)						    OpenGL 3.3						    GLGETMULTISAMPLEFV(3G)

NAME

       glGetMultisamplefv - retrieve the location of a sample

C SPECIFICATION

       void glGetMultisamplefv(GLenum pname, GLuint index, GLfloat *val);

PARAMETERS

       pname
	   Specifies the sample parameter name.  pname must be GL_SAMPLE_POSITION.

       index
	   Specifies the index of the sample whose position to query.

       val
	   Specifies the address of an array to receive the position of the sample.

DESCRIPTION

       glGetMultisamplefv queries the location of a given sample.  pname specifies the sample parameter to retrieve and must be
       GL_SAMPLE_POSITION.  index corresponds to the sample for which the location should be returned. The sample location is returned as two
       floating-point values in val[0] and val[1], each between 0 and 1, corresponding to the x and y locations respectively in the GL pixel space
       of that sample. (0.5, 0.5) this corresponds to the pixel center.  index must be between zero and the value of GL_SAMPLES - 1.

       If the multisample mode does not have fixed sample locations, the returned values may only reflect the locations of samples within some
       pixels.

ERRORS

       GL_INVALID_ENUM is generated if pname is not one GL_SAMPLE_POSITION.

       GL_INVALID_VALUE is generated if index is greater than or equal to the value of GL_SAMPLES.

SEE ALSO

       glGenFramebuffers(), glBindFramebuffer()

COPYRIGHT

       Copyright (C) 2010 Khronos Group. This material may be distributed subject to the terms and conditions set forth in the Open Publication
       License, v 1.0, 8 June 1999.  http://opencontent.org/openpub/.

OpenGL 3.3							    03/08/2011						    GLGETMULTISAMPLEFV(3G)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Pipe SQL select statement results to script

Discussion started by: houtakker

2. Shell Programming and Scripting

formatting the sql select result

Discussion started by: kotasateesh

3. Web Development

SQL Select inside Insert

Discussion started by: Ikon

4. Shell Programming and Scripting

SQL Select and awk

Discussion started by: habuzahra