of list ORACLE-L [EMAIL PROTECTED]
X-Comment: Oracle RDBMS Community Forum
X-Sender: Loughmiller, Greg [EMAIL PROTECTED]
From: Loughmiller, Greg [EMAIL PROTECTED]
Subject: RE: a couple of questions
X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman
Mime-Version: 1.0
Content
I haven't been following this thread, but I saw the phrase database
independent and couldn't help chiming in...
For the past couple years, whenever someone mentioned database
independence as justification for certain decisions, I suggest that they
stick with MySQL and save themselves the
database indepdent...
oh dear...You're doomed :-)
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
and here they want to be database independent
sigh. it's for a content management system
--- Toepke, Kevin M [EMAIL PROTECTED]
wrote:
I agree, it looks messy and confusing... However,
As an additional side note to the 64 bit phase of this thread...
Solaris 9 is 64 bit by default. So the statement made by an individual (a
field engineer) if anyone has plans on moving to a Solaris 9 environment,
one will need to use the 64 bit Oracle version. I'm not totally convinced
of that
no, I do have SOME input -- we'll be hiring a consultant DBA on this,
at least to get it up and running. I have some control over who we
hire. I'm going to make sure I get someone who is willing and able to
say NO.
And I refuse to mention the ANY datatype :)
Rachel
--- Connor McDonald [EMAIL
Rachel,
I have talked to some very talented SQL Server DBA's that have used sql_variant data
types. They all agreed that this data type is not worth the time. They would get
unexplainable results. It is not so much a database issue but rather it is a coding
and understanding of the data
Tim Gorman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/17/2002 12:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: a couple of questions
Rachel,
This variant datatype
Title: RE: a couple of questions
Nope. Been happening for years. Where ignorance is bliss 'tis folly to be wise. Thomas Gray (1716-1771)
Damagement likes to be happy.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message
Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far,
but not much mileage on either. The one thing that came up is that you must
be careful because you seem to get 32-bit Oracle by default. Someone on this
list suggested running file oracle.
Oracle does have user-defined
Rachel,
First question - Not a Clue. I'm on windoze. ;o)
Second Question - SQL_Variant datatype -I'll find out more about this. I have never
used it.
A data type that stores values of various SQL Server-supported data types, except
text, ntext, image, timestamp, and sql_variant.
Rachel,
1. Don't know
2.
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/appdev.901/
a88876/adfnstyp.htm#434671 may not be the exact thing but you just might be
closer ...
Also, Oracle *automatically* does implicit conversion ... but I think your
developers are asking for
Rachel -
We were running 64-bit Oracle here for a while, but I decided against
it. I knew that we weren't going to need the features that the 64bit
version would buy us. That, coupled with the fact that the 64 bit
versions of the software are usually the *last* to be patched, kept me
on the
Dennis,
it's a dev box so we don't really need mileage it won't be hit as hard
as production (and I'll make sure production is created properly)...
as for the datatypes, I know about user-defined, they don't want that.
These are people who know SQL Server but not Oracle and are designing
the
A variant data type column in the database? What would be the domain of such a
column? Does such a column not beg for data which should be placed in other columns
to be stored in it? Oh what fun when someone stores 1234 or worse 1.2E4 both as a
number and string.
Perhaps I'm to staid in
Rachel
Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me
thinks its what SQL server would call a variant data type.
Follow this link for more info
http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/to
c.htm
Kevin
The Any types provide
:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: a couple of questions
Rachel
Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me
thinks its what SQL server would call a variant data type.
Follow
I agree, it looks messy and confusing... However, I found an example that
makes it a little easier to understand.
http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID,
F4950_P8_CRITERIA:3099475696866,%7Banydata%7D
My guess it was implemented for 2 reasons
1)
How do u get 32 bit by default? The 32bit and 64bit Oracle came as
separate CDs. Am I missing something?
Richard
-Original Message-
Sent: Wednesday, July 17, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so
Much better explanation especially with the examples. BUT, do I smell a
potential manure pile here?
Dick Goulet
Reply Separator
Author: Toepke; Kevin M [EMAIL PROTECTED]
Date: 7/17/2002 1:53 PM
I agree, it looks messy and confusing... However, I
Some times I get a thin CD pack which only has 32bit.
I will have to ask Oracle to ship me the 64bit version.
-Original Message-
Sent: Wednesday, July 17, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
Dennis,
I'm not sure your referring to the message I posted a couple of
Rachel,
This variant datatype sounds a lot like the union data structure from
C language, which closely resembled a struct (i.e. record) but all of
the fields overlap the same memory address. In other words, it was a
mechanism for type re-casting. In the grand tradition of robust programming
No problem running 64bit Oracle on 64bit Solaris so far.
But 64 bit has it's own set of bugs from 32 bit. I am
sure you will test it before deployment. :)
Richard Ji
-Original Message-
Sent: Wednesday, July 17, 2002 1:09 PM
To: Multiple recipients of list ORACLE-L
Okay, I'm working
and here they want to be database independent
sigh. it's for a content management system
--- Toepke, Kevin M [EMAIL PROTECTED] wrote:
I agree, it looks messy and confusing... However, I found an example
that
makes it a little easier to understand.
. But using it in SQL queries ain't the prettiest thing.
HTH,
- Kirti
-Original Message-
From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 12:59 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: a couple of questions
I'm going to try very hard to unremember (G) anything about ANY just
so I can tell them they can't get there from here.
Rachel
--- Tim Gorman [EMAIL PROTECTED] wrote:
Rachel,
This variant datatype sounds a lot like the union data structure
from
C language, which closely resembled a struct
Richard - I can't answer how we got 32 bit Oracle on Solaris by default.
Currently my sys admin is handling installs. I think he had only one version
and its' bitness wasn't labeled.
One day someone on this list asked how to tell whether the version
installed was 32 or 64 bit. Several other
/2002 12:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: a couple of questions
Rachel,
This variant datatype sounds a lot like the union data structure from
C language, which closely resembled
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:Re: a couple of questions
Not so with what you're describing. Sounds like a feature which is ripe
for
all kinds of abuse. I can just imagine entire tables populated with
columns
/17/2002 12:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: a couple of questions
Rachel,
This variant datatype sounds a lot like the union data structure
from
C language, which
Someone coming into where I work with only their OCP as their claim to fame will
most likely not get an interview whereas someone with a number of years Oracle
experience will. We were pretty badly burned in the recent past by someone who
had their OCP as their sole claim to fame. This
Title: RE: Re[2]: Couple of questions
Gosh I keep mine hush-hush. It is at the very bottom of my resume... Yes I have it but so what? I didn't claim to know a whole lot about backup and recovery until a couple of months ago when I actually had resources and time to PRACTICE.
Yes, Gene, you
I'd even give latitude to someone who might not know everything, but who has a basic
understanding and will logically and carefully research a problem as opposed to
hacking away at it until he/she figures it out.
[EMAIL PROTECTED] 03/22/01 12:13PM
Gosh I keep mine hush-hush. It is at the
32 matches
Mail list logo