On Mon, Feb 14, 2005 at 12:04:02PM +0530, Nagaraj_Hayyal wrote:
Hi there,
I am newbee to this perl.
I am using db2 as a database.
I have a problem in fetching clob data in perl.
I have set all the necessary parameters as shown below.
But still I have a problem in fetching a single row
Hi all,
the new version (0.07) of DBIx::ProcedureCall has support for
PostgreSQL (in addition to Oracle) now.
So if you have functions like these:
1) CREATE FUNCTION some_select() RETURNS SETOF pg_user AS $$
SELECT * FROM pg_user;
$$ LANGUAGE SQL;
2) the built-in power(number, number)
You
Amonotod [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
From: Robert [EMAIL PROTECTED]
Date: 2005/02/11 Fri PM 12:55:03 CST
Nope you got it. I am just mulling in my thick head.
Say what? We're quite willing to help, we just need a little more data to
do so...
Robert
Hi all,
I have one simple question - how I can return 10 random rows
from select?
For example we have select:
Select name, street, date
from people
order by date desc
limit 0,100
Now, I want return 10 random peoples. How to do it ? It is possible
via SQL statement, or I have to care about
It depends on what database you are using. It can be done in oracle by
SELECT region AVG(amount)
FROM sales SAMPLE(5)
GROUP BY region;
This statement select 5 percent of the data in the sales table. This is
from the oracle 8i documentation.
Thanks,
Sam Gold
-Original Message-
I'm not sure what type of database you are using, but you can achieve
this quite easily in MySQL by using ORDER BY RAND()... in your query.
Example:
SELECT name, street, date
FROM people
ORDER BY RAND()
LIMIT 10
HTH...
Chris
Ing. Branislav Gerzo wrote:
Hi all,
I have one simple question - how I
Hi everyone,
Thanks to those who responded. I tried all the helpful ideas, and well,
I guess it's better to get a different error than living in the same
error, hehe.
If I don't use strict, I get the following errors:
Database error: DBI::st=HASH(0x239094)-bind_param(...): attribute
Darren Duncan wrote:
I don't have a lot of experience with databases other than Oracle
and a little PostgreSQL, but I'm under the impression that indexing
behavior in general is not very standardized, so not a good
candidate for DBI.
I think that MySQL works the same way. You create a
On 02/14/2005 11:10 AM, [EMAIL PROTECTED] said:
If I don't use strict, I get the following errors:
You should (nearly) always use 'use strict;'. It helps prevent single
errors from combining into real rats' nests.
Database error: DBI::st=HASH(0x239094)-bind_param(...): attribute
parameter
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have one simple question - how I can return 10 random rows
from select?
Just to round out the previous two answers, the PostgreSQL way:
SELECT name, street, date FROM people ORDER BY random() LIMIT 10;
Be aware that this is not
10 matches
Mail list logo