At 16:50 -0700 1/10/01, jie zhang wrote:
Somehow, TZ is not recognized in my system. I am using oracle 8.1.7 on
solaris 5.8.
Did you actually tried out in your system ? Do I need to
set up any NLS variable in order to use the 'TZ' keyword ?
I'm afraid that Oracle's handling of timezones is
Hi all,
I have recently installed Oracle 8i enterprise (8.1.7) on a Redhat 7
system... and, using some advice from otn.oracle.com discussion forums,
I am able to run a database, use svrmgrl, and sqlplus... now, I want to
connect via DBI::Oracle to another oracle database that is running
Hello,
I am a Perl guy, not a DBA. Anyway, if I have a couple of DBs with X amount
of records, can I select from three databases, acquire the first 20 records
(sort by ASC), then (show them on the web) and when they hit next, show the
next 20, eg. 21-40 and so on and so on. Also, If that is
Yes.
Run a connect to each DB you want to work with. You can then run queries
with a where clause of 'rownum = 20' to get a sampling of a table from each
DB. I'm not sure about a page count myself, but you can check the number of
records in each DB in each table with a 'select count(*)' query
Jie,
Oracle doesn't support timezones in date format strings, unfortunately.
Brgds,
Mark
jie zhang wrote:
Somehow, TZ is not recognized in my system. I am using oracle 8.1.7 on
solaris 5.8.
Did you actually tried out in your system ? Do I need to
set up any NLS variable in order to
Susan,
My guess is that you installed DBD::Oracle with your environment pointing to
8.1.7.
When you install DBD::Oracle, it is linked with the Oracle client
libraries. If you run a program linked in an 8.1.7 environment, but (because
of your environment variables) it picks up the dynamic
Please review the dbi-users mailing list archives. There are plenty of
answers to this and similar questions there.
The short answer is that there is no direct Linux driver for MS Access. You
can:
use DBI proxy and have DBI installed on an NT machine
use EasySoft's ODBC bridge
What database are you using, it's pretty easy to do with MySQL, since it
supports the LIMIT clause.
To find out the number of records from any DB's table, just run a select
count(*) query on it.
Ilya
-Original Message-
From: Purcell, Scott
To: '[EMAIL PROTECTED]'
Sent: 10/2/01 6:36
In 8.1.6 for Solaris, browse standard.sql. There are numerous
functions, internal data types and overloaded operators that support
manipulation/display of time zone formats.
HTHYO.
Mark == Mark Vandenbroeck [EMAIL PROTECTED] writes:
Mark Jie, Oracle doesn't support timezones in date
the list mysteriously and completely disappeared for roughly 10 minutes,
and I wasn't sure if my post was received or not. *head-scratching*
-=-
unable to set ;csv_eol=\015, but saving the file via bbedit to DOS
instead of Macintosh, the code works?!? what the hell?
setting csv_eol=\015
Scott R. Godin wrote:
unable to set ;csv_eol=\015, but saving the file via bbedit to DOS
instead of Macintosh, the code works?!? what the hell?
AFAIK,
1. If you are on a MAC and have all MAC-formatted files, don't set
csv_eol at all, DBD::CSV should do the right thing.
2. If you are on a
- Forwarded message from Axel Rose [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Date: Tue, 2 Oct 2001 19:51:05 +0200
To: [EMAIL PROTECTED]
From: Axel Rose [EMAIL PROTECTED]
Subject: dbish, TERM problems
Hello Tim,
I know you are very busy. But perhaps you have the best idea
to
On Tue, Oct 02, 2001 at 03:27:04PM -0400, [EMAIL PROTECTED] wrote:
Does anyone have a sample code which demonstrates
using DBI to access both a remote oracle and local
sybase servers simultaneously?
Umm, how about this:
$syb = DBI-connect('dbi:Sybase:foo', ...);
$ora =
I don't have an example for Sybase, but I have done this sort of thing with
a couple of local and remote Oracles as well as multiple local Oracles.
Basically, you connect to each one as you would expect and assign a
different handle to each connection. From there on, it doesn't matter
whether
select * from catalog with (UPDLOCK ROWLOCK)
where product = 'acs-101'
gives me Table level lock (as can be seen through 'sp_lock' stored proc)!
ActivePerl Build 629
DBI 1.14
W2K
Any Clues?
Thanks,
MVRamana
_
Get your FREE
Venkataramana Mokkapati writes:
select * from catalog with (UPDLOCK ROWLOCK)
where product = 'acs-101'
gives me Table level lock (as can be seen through 'sp_lock' stored proc)!
I doubt that this is a DBI issue.
What do you get if you perform the same action through some other
On Mon, 1 Oct 2001, Scottie Thompson wrote:
I recently installed DBD::Informix on a Win NT machine, which appears to be
working just fine.
Good.
But I haven't been able to get it working in Win 2000.
I haven't tried - I don't have a Win2K machine to do the trying on.
Has anyone been able to
Thank you all very much for helping me. It looks like Oracle stores date
only in one timezone in one
database. I was able to do the format conversion using:
select to_char(sysdate, 'Dy Mon DD HH24:MI:SS PDT ') from dual;
TO_CHAR(SYSDATE,'DYMONDDHH24
Mon Oct 01
Three suggestions depending on the DBMS you are using:
1. This method is supported by MS SQL 7.0 or later:
SELECT TOP 20 Column1, Column2, Column3 FROM Sometable
WHERE Column1 NOT IN
(SELECT TOP 40 Column1 FROM Sometable
ORDER BY Column1)
ORDER BY COLUMN1
9i is a lot more timezone aware - if thats of any use. You can have a data
type of TIMESTAMP WITH [LOCAL] TIMEZONE, however I'm not sure of whether
the Oracle::DBD supports the new data types.
-Original Message-
From: jie zhang [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 3 October 2001
One correction, I forgot to alias the table in the third example (That's
what I get for typing straight into the body.
Should be:
SELECT o.Column1, o.Column2, o.Column3 FROM Sometable o
WHERE (SELECT Count(*) FROM Sometable i
WHERE i.Column1 o.Column1)
Pardon me if this has been covered before; I can't reach the archives, and
I'm the impateint type. ;-)
I'm using Perl 5.6.0 on OpenBSD 2.9; it's worked quite well for me so far.
After just installing MySQL 3.23.37, I figured the smart thing to do to work
with it would be to get the
22 matches
Mail list logo