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 lice
pients 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;
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
-O
>
> >
> >
> >
> >
> >
> > "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
> > &l
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 pro
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
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 t
"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 confu
uhveloper, just use the ODBC
> interface in MS Excel.
>
> Jared
>
>
>
>
>
>
> "Tim Gorman" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 07/17/2002 12:35 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipient
o ORACLE-L
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 e
ot; <[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 sounds a
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 pe
I'm going to try very hard to unremember () 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 resembl
2 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
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.
>
>
http://asktom.oracle.com/pls/a
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 on
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 prog
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 w
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,
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 fa
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) t
e, 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
>
> Rachel
>
> Check out the SYS.ANY datatype in Oracle 9i (from the SQL reference). Me
> thinks its what S
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 hi
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 my
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 sys
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 32-
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 more.
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.
sql_varia
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 d
Hi Charles,
I think this is what you are looking for, This comes from Chapter 10, Schema
Objects of the Oracle 8i (release 2) Concepts manual:
User-Defined Operators
Oracle provides a set of built-in operators which include arithmetic
operators (+, -, *, /), comparison operators ( =, >, <), log
30 matches
Mail list logo