07-11-2012
Cannot get literal ampersand to display in SQL output
Gurus,
Thanks so much for your help, in advance.
I'm using ksh and outputting a literal string value to an output file, however, Unix isn't playing by SQL's rules. The ampersand character which I'm trying to disply as a knowledge base link is screwing up the output. Typically, the "&&" is the escape for displaying "&" in SQL output, however, this doesn't work inside a shell script.
Does anyone know the escape characters to disply the ampersand properly for the following?
I've include double ampersand, as per SQL's rules...
col Instructions3 heading "KNOWLEDGE BASE SUPPORT LINK" format a4000
select 'http://vr05a2.us.com:86/viewtopic.php?f=141&&t=2057&&p=2334&&hilit=over+pick&&sid=56b38c52bf3b36f1d17b854b29a41a3b#p2334' Instructions3
from dual;
Thanks,
Scott
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
What is the & for in Unix?? say for example that you have a line in a shellscript that will startup a executable and you have the ampersand at the end of the line, what is it for??
any info you could spare would be much appreciated
thanks in advance (1 Reply)
Discussion started by: eloquent99
1 Replies
2. Programming
In my program, I'm using argc and argv to accept command line arguments. However, if I have to get the '&' to work i.e. make it run the child as a background process, do I have to write some special code in C or does Unix handle it automatically? If I have to add the special code, how does it look... (2 Replies)
Discussion started by: Legend986
2 Replies
3. UNIX for Dummies Questions & Answers
Hi folks,
Please advise which command/command line shall I run;
1) to display the command and its output on console
2) simultaneous to save the command and its output on a file
I tried tee command as follows;
$ ps aux | grep mysql | tee /path/to/output.txt
It displayed the... (7 Replies)
Discussion started by: satimis
7 Replies
4. Shell Programming and Scripting
Hello,
I'm trying to do a select for an Oracle table but the output gives me only filelds values without fields name as in Informix.
Is there anyway to display both in output ?
For instance, the output will be :
Name Rico
Age 30
Position Engineer
Thx, (5 Replies)
Discussion started by: rany1
5 Replies
5. UNIX for Advanced & Expert Users
Hi folks,
I am facing one problem with v$sql, i need to store updating sql query in temp table when one trigger get fired on some update sql statement.
but with "sql_text" , i am not getting correct update statement in temp table.
I am getting sql_text with this cursor statement.
select... (0 Replies)
Discussion started by: apskaushik
0 Replies
6. Shell Programming and Scripting
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Discussion started by: adept
4 Replies
7. Shell Programming and Scripting
Hi,
I have the following output of a shell script
k m == -77.2820 (Act=79.9)
i want to display only
k m (6 Replies)
Discussion started by: sreejithalokkan
6 Replies
8. Shell Programming and Scripting
I want to add the character "<" to the end of each line of input using the & function in SED.
Something like:
sed 's/.*/&\</'
It's important to use the &, not another method, because I want to know what I'm doing wrong.
Thanks (5 Replies)
Discussion started by: rlopes
5 Replies
9. Programming
Hi,
I have been frantically googling and checking some sqlplus forums, but can't find the correct syntax.
Basically within sqlplus I want to do a count on a table and if the count is 0 it displays 0 instead of "no rows found".
For eample:
select count(*) from tableA where... (3 Replies)
Discussion started by: chris01010
3 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT PHP
mysql_unbuffered_query
MYSQL_UNBUFFERED_QUERY(3) 1 MYSQL_UNBUFFERED_QUERY(3)
mysql_unbuffered_query - Send an SQL query to MySQL without fetching and buffering the result rows.
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
oSee: Buffered and Unbuffered queries
resource mysql_unbuffered_query (string $query, [resource $link_identifier = NULL])
DESCRIPTION
mysql_unbuffered_query(3) sends the SQL query $query to MySQL without automatically fetching and buffering the result rows as
mysql_query(3) does. This saves a considerable amount of memory with SQL queries that produce large result sets, and you can start working
on the result set immediately after the first row has been retrieved as you don't have to wait until the complete SQL query has been per-
formed. To use mysql_unbuffered_query(3) while multiple database connections are open, you must specify the optional parameter $link_iden-
tifier to identify which connection you want to use.
o $query
- The SQL query to execute. Data inside the query should be properly escaped.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
For SELECT, SHOW, DESCRIBE or EXPLAIN statements, mysql_unbuffered_query(3) returns a resource on success, or FALSE on error.
For other type of SQL statements, UPDATE, DELETE, DROP, etc, mysql_unbuffered_query(3) returns TRUE on success or FALSE on error.
Note
The benefits of mysql_unbuffered_query(3) come at a cost: you cannot use mysql_num_rows(3) and mysql_data_seek(3) on a result set
returned from mysql_unbuffered_query(3), until all rows are fetched. You also have to fetch all result rows from an unbuffered SQL
query before you can send a new SQL query to MySQL, using the same $link_identifier.
mysql_query(3).
PHP Documentation Group MYSQL_UNBUFFERED_QUERY(3)