Hi!
I need to wrap this SQL into SP where I can pass new owner name. I'm planning create db table with all owners I need to pass.
BEGIN FOR r IN (SELECT table_name FROM dba_tables WHERE owner='TRAIN1') LOOP EXECUTE IMMEDIATE 'truncate table TRAIN1.'||r.table_name; END LOOP;END;/
Thanks.
Greg
CREATE OR REPLACE PROCEDURE labware_admin.truncate_tables( schema_owner IN VARCHAR2) AS
r number(10);
BEGIN
FOR r IN (SELECT table_name FROM dba_tables WHERE owner=schema_owner) LOOP EXECUTE IMMEDIATE 'truncate table schema_owner.'||r.table_name; END LOOP;
END;
ERROR: Line 14 Column 55
function.
Good
Luck
Tom
Mercadante Oracle Certified
Professional
-Original Message-From: Greg Sorrel
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 08, 2004 2:55
PMTo: Multiple recipients of list ORACLE-LSubject:
simple question
Hi!
I need to wrap this SQL into SP where
Remove
the
r
number(10);
and it
should be fine.
Tom Mercadante Oracle Certified Professional
-Original Message-From: oranew2004
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 08, 2004 3:24
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
simple question
I'll add that if you have foreign keys, they will mess you up. Here is an
old script I have in my stash that you can modify with info already provided
by others.
procedure truncate_all(code_word in varchar2 default 'XXX') is
cursor c1 is select table_name,constraint_name from user_constraints
Why do you have r declared as number(10)?
On 01/08/2004 03:24:25 PM, oranew2004 wrote:
CREATE OR REPLACE PROCEDURE labware_admin.truncate_tables
(
schema_ownerIN VARCHAR2
)
AS
r number(10);
BEGIN
FOR r IN (SELECT table_name FROM dba_tables WHERE owner=schema_owner)
LOOP
Sorry for the SQL Server post, working on SQL Server for the first time, and
this list is my only resource as of now. I'm reading the SQL Server join
syntax and trying it myself. Meanwhile, If i can get some expert help, it
will be more than useful
I'm simplifying the problem with the help of
- A very simple question
Sorry for the SQL Server post, working on SQL Server for the
first time, and
this list is my only resource as of now. I'm reading the SQL
Server join
syntax and trying it myself. Meanwhile, If i can get some
expert help, it
will be more than useful
I'm
INTO t4 VALUES ('A', 'DD'); as INSERT INTO t4 VALUES
('', 'DD'); in my previous mail.
Regards
Naveen
-Original Message-
From: Naveen Nahata
Sent: Wednesday, June 25, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Outer join in SQL server - A very simple question
I don't know the answer but can suggest some resources:
www.sqlmag.com
www.sqlpass.org/forums
www.sqlservercentral.com/forum
Just to be sure, I went to each of these this morning to make sure they
are still live.
[EMAIL PROTECTED] 06/25/03 02:49AM
Sorry for the SQL Server post, working on
-Original Message-
From: Naveen Nahata
Sent: Wednesday, June 25, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Outer join in SQL server - A very simple question
Sorry for the SQL Server post, working on SQL Server for the
first time, and
this list is my only
('', 'DD'); in my previous mail.
Regards
Naveen
-Original Message-
From: Naveen Nahata
Sent: Wednesday, June 25, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
Subject: Outer join in SQL server - A very simple question
Sorry for the SQL Server post, working on SQL
To: Multiple recipients of list ORACLE-L
Subject: Re: Outer join in SQL server - A very simple question
I don't know the answer but can suggest some resources:
www.sqlmag.com
www.sqlpass.org/forums
www.sqlservercentral.com/forum
Just to be sure, I went to each of these this morning to make
Thank you very much Dennis and Dick for your info.
wow!! These days I am learning lot. Thanks for my friend Ravi Kiran
who suggested me to join this group..
-Original Message-
Sent: Friday, January 24, 2003 10:35 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Allow me to add
My point wasn't to pick any particular detail
of any particular example . I was merely making
the point that whilst the concept of DDL without
commits seems to be straightforward, the requirement
for designing something that could analyse and handle
all the consequent errors that might be a
Take your first example :
insert into t1 values (1);
drop table t1;
-- how to deal with self-deadlock ?
insert into t1 values (2);
commit;
Why does Oracle HAVE to commit when the DROP TABLE is issued ?
What if the INSERT had been issued by another session ? Would
the DROP TABLE go through
Banarasi - Worse than that, Oracle used to recommend that you use no more
than 4 characters (look at your process names, and imagine if your O.S. only
allowed 8 characters for the name). The problem is that some, mostly older,
computer systems have severe filesystem and process name limitations. I
Dennis,
Allow me to add another item to the pile from the OLD days. Back in SQL*Net
V1 it was recommended to select a database name/SID that was case insensitive.
That restriction/recommendation was due to older DOS based clients that handled
all of that sort of data as upper case.
Hemant,
My guess is that Oracle, at some point in time long ago, decided that DDL's
and DML's should not be mixed together. Because they could not (or did not
want to) deal with the issue, they decided to perform an implicit commit
before any DDL statement was issued. Case closed. This is the
Tom - I think you've nailed it. Think of the design decisions that some of
Oracle's competitors made in the early days and how silly they seem in
retrospect. Anyone remember the row-locking vs. block-locking wars?
The other aspect that many people don't think of if they have never
worked in
are at a safe commit point.
jared
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/24/2003 09:34 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: DDLs -- was Re: simple question
Agreed. There's a lot of code out there that was developed considering the
way Oracle handled DDL and DML specifically.
Although I would have liked Oracle to handle DDL as an Autonomous Transaction
and provide an error message for the scenario in the first example, I guess
it might be too late
SORRY - this was the wrong list. the other pertinent list is one about controlling
machines via a DDL protocol and a demon called the alike.
kr mr
[EMAIL PROTECTED] 01/22/03 16:49 PM
hi
what's your exact question?
you mean autocommit like in database applications?
what tool are you using to
-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: simple question on DDL
Date: Wed, 22 Jan 2003 14:18:57 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc1-f3.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed
recipients of
list
ORACLE-L [EMAIL PROTECTED]
.com cc:
Sent by: Subject: RE: simple
question
on
DDL
root@fatcity.
com
]
Subject: RE: simple question on DDL
Date: Wed, 22 Jan 2003 14:18:57 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc1-f3.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed,
22 Jan
2003 15:13:04 -0800
Received: from fatcity.UUCP (uucp
thoughts on that?
Arup
From: Fink, Dan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: simple question on DDL
Date: Wed, 22 Jan 2003 14:18:57 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc1-f3
:
Sent by: Subject: RE: simple question on DDL
[EMAIL PROTECTED
recipients of list ORACLE-L [EMAIL PROTECTED]
rizon.com cc:
Sent by: Subject: RE: simple
question on DDL
[EMAIL PROTECTED]
January 22,
2003
10:33
PM
Title: RE: simple question on DDL
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 8:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: simple question on DDL
Actually, DB2 (pardon my French) doesn't issue a commit
after a DDL. I'm
]]
Sent: Thursday, January 23, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: simple question on DDL
Arup,
I see your point and agree that the DDL should be an
autonomous tx.
Perhaps an enhancement request is in order? Since Oracle has
the autonomous
tx code
Title: RE: simple question on DDL
Set autotrace on ... and then do explain plan for
You'll see.
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't
One question to ask is whether whether all DDL
use the same strategy. Similarly, if you have
multiple code paths for do a ddl call how much
more risk of error do you introduce to the kernel.
Finally how do you get a consistent error response
to the end user if the error condition of apparently
Hi All
Why name of the Database is restricted to 8 bytes. where as we can have long
names for tablespaces, tables, views, etc ?
thanks
Banarasi Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: BanarasiBabu Tippa
INET: [EMAIL PROTECTED]
Fat City Network
Hi friends
Why DDL statements performs auto commit ? What is the exact reason behind
that one?
Anyone can share his/her opinions!!
Thanks regards
BanarasiBabu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: BanarasiBabu Tippa
INET: [EMAIL PROTECTED]
Fat City
hi
what's your exact question?
you mean autocommit like in database applications?
what tool are you using to observe or redard to this phenomenon?
the erd-demon has to send some info via rs232 to make the amplifier -called booster -
work. no info implies no current on the tracks. kind of answwer
My guess will be to preserve the changes to the data dictionary, which are
just Oracle tables anyway. When you create a table, a record goes to TAB$,
SEG$ and so on and so forth. Unless there is a commit these information is
not visible.
But now that you asked, I wnder why the same objective
]
tmail.com cc:
Sent by: Subject: Re: simple question on DDL
root@fatcity
Consistency is the key too imagine what would happen if I dropped a
column or changed it's definition, while a SQL statement or PL/SQL package
was executing. The data that was updated before the change may well be very
different in nature than the data after the change
Borrowing from
arupnanda@hoTo: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
tmail.com cc:
Sent by: Subject: Re: simple question
on DDL
root@fatcity.
com
January 22
Take the case of an insert (we'll call tx1), where space allocation is
required. As you insert records, the table allocated additional extents
(updating fet$ (free extent table) and uet$ (used extent table) in the data
dictionary). These updates to the data dictionary are implicitly committed,
Very good case described.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 22, 2003 2:16 PM
Take the case of an insert (we'll call tx1), where space allocation is
required. As you insert
: RE: simple question on DDL
root@fatcity.
com
]
.comcc:
Sent by: Subject: RE: simple question on
DDL
root@fatcity.
com
January 22,
2003 02:16 PM
Please
: simple question on DDL
Date: Wed, 22 Jan 2003 14:18:57 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc1-f3.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Wed, 22 Jan
2003 15:13:04 -0800
Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com
(8.9.3
Dan addressed this very well in his earlier post...
Here is what Tom Kyte says in his book (Expert one-on-one Oracle):
DDL locks are automatically placed against objects during a DDL operation to protect
them from changes by other sessions.
DDL locks are held for the duration of the DDL
Stephane,
you are right, after I talked to the developer. She is totally confused
by alias name, dbname, schema name. She is referring database name.
joan
Joan Hsieh wrote:
Stephane,
Well spoken- my bad. Our developer threw me this question when I was
just leaving from work. (I copied
Hi Listers,
I am trying to find a way to know the schema name. Say, if I logged in
as jjin01@ngd. When I run a program, how can I get the schema name
which should be ngd? If I logged in as bkrasnof@pr, in this case, the
schema name will be pr.
Thanks in advance,
Joan
--
Please see the
Joan Hsieh wrote:
Hi Listers,
I am trying to find a way to know the schema name. Say, if I logged in
as jjin01@ngd. When I run a program, how can I get the schema name
which should be ngd? If I logged in as bkrasnof@pr, in this case, the
schema name will be pr.
Thanks in advance,
Stephane,
Well spoken- my bad. Our developer threw me this question when I was just
leaving from work. ( I copied from her email) Now I am at home to look it over.
I am not clear what she asked for. I think she wants to pass a variable based
on the @xxx to access this schema. I will make it
Stephane,
Well spoken- my bad. Our developer threw me this question when I was
just leaving from work. (I copied her email to the list) Now I am at
home and taking a chance to look it over again. I am not sure what she
asked for. My guess is she wants to pass a variable based on @xxx to
access
Hi Gurus,
How can I turn off logging for a table in Oracle7.3 database. Iam planning
to reorg thru ctas and want to use append hint for loading data.
SQL alter table tt unrecoverable;
alter table tt unrecoverable
*
ERROR at line 1:
ORA-01735: invalid ALTER TABLE option
SQL
ALTER TABLE yourtable NOLOGGING
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 14, 2002 4:33 PM
Hi Gurus,
How can I turn off logging for a table in Oracle7.3 database. Iam planning
to reorg thru ctas and want to use
Title: RE: Simple question on logging..
-Original Message-
From: Peter R [mailto:[EMAIL PROTECTED]]
How can I turn off logging for a table in Oracle7.3 database.
Recoverable/unrecoverable is not a persistent attribute in 7.3.4 The unrecoverable option only applies
Hi.
I was trying to truncate a table, which is a parent
to two other tables (its PK is referred to by two FKs
from two other tables). These other tables are
empty.
When I tried to truncate the parent table, however, I
got an error message ORA-02266: unique/primary keys in
table referenced by
Hi.
I was trying to truncate a table, which is a parent
to two other tables (its PK is referred to by two
FKs
from two other tables). These other tables are
empty.
When I tried to truncate the parent table, however,
I
got an error message ORA-02266: unique/primary keys
in
table referenced by
Hi Gene,
You cannot truncate a table that is a parent in enabled FK constraints.
You did the right thing. or you can simply delete (of course longer) with
enabled constraints.
--
Alexandre
Hi.
I was trying to truncate a table, which is a parent
to two other tables (its PK is referred to by
You did it right.
It's just the way oracle works.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, June 18, 2002 9:43 AM
Hi.
I was trying to truncate a table, which is a parent
to two other
Gene,
In the event of a delete from the parent Oracle has a chance to check the
child table(s) to see if the parent is still valid. But since a truncate is
really a DDL, not DML, command there is no such chance. Therefore if you want
to truncate a table you have to disable the foreign
: Data Warehouse
experts, a simple question
for you| Outdated?
Dennis,
I have on my desk, all in varying stages of being
read:
Inmon's book Building the Data Warehouse (very
understandable)
Kimball's articles from his site and from
, Ian A. [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/21/2002 05:48 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Warehouse experts, a simple question
for
you| Outdated?
I am
by: [EMAIL PROTECTED]
05/21/2002 05:48 PM
Please respond to ORACLE-L
To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Warehouse
experts, a simple question
for
you| Outdated?
I am new to his books, three
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Warehouse experts, a simple question
for
you| Outdated?
I am new to his books, three chapters in. The first release of the
Data
Warehouse Toolkit defines a data warehouse much as a data mart
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Warehouse experts, a simple question
for
you| Outdated?
I am new to his books, three chapters in. The first release of the
Data
Warehouse Toolkit defines a data warehouse much
-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Warehouse experts, a simple
question
for
you| Outdated?
I am new to his books, three chapters in. The first release of the
Data
Warehouse Toolkit defines a data warehouse much as a data mart is
today
[EMAIL PROTECTED]
cc:
Subject:RE: Data Warehouse experts, a simple question
for
you| Outdated?
I am new to his books, three chapters in. The first release of the
Data
Warehouse Toolkit defines a data warehouse much as a data mart is
today
Dennis,
We are active participants in the process. We are also making an offer
to someone with an extensive background in developing data warehouses,
which will help me to sleep much more comfortably at night :)
Rachel
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
Rachel
- Glad Inmon's book
Rachel,
This was just received from the SearchDatabase email and I thought
it might be of interest to you.
.
TODAY'S BI STRATEGY: Placement of the data warehouse (Part 2)
By William McKnight, SearchCRM Expert
Another question I received [last week at the Data Warehousing
ron,
Even without reading the rest of the article, my first instinct is to
scream NOO
and, after reading the article, it appears the author agrees with me.
I have a sane boss. an intelligent boss. He is management, not
damagement he has the same concerns about what the
Dennis Williams wrote:
Personally, I have understood everything that Kimball has
written and have never been able to read one of Inmon's articles to the
end.
But maybe that is just me.
No, it's not just you. I can't read him either. It's like taking
a walk through a briar patch without a
Rachel,
Having the same backup problems as talked about in the article, I can
agree with the views and opinions of the author. The second part of the
article dealt with the placement of the data and type of operation on
the data in the same instance.
I have mixed emotions about that idea.
Jared - Hmmm. . . if Rachel finds him very readable, does that mean:
a) she will shortly explain Inmon to the rest of us dumb DBAs.
b) she will become incomprehensible to the rest of us.
Sorry Rachel, couldn't resist. Actually, I am hoping for option A.
Dennis Williams
DBA
Lifetouch, Inc.
I have NOT read his articles. Nor have I gotten all THAT far into the
book
however, the prep work I did before starting his book (reading the
Oracle docs, reading some Kimball articles, searching the web) may be
the reason I find him readable.
Of course, it could just be that I am smarter than
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Fax to:
Subject:RE: Data Warehouse experts, a simple question for you|
Outdated?
Dennis,
I have on my desk, all in varying stages of being read:
Inmon's book Building the Data Warehouse
Warehouse experts, a simple question
for you| Outdated?
Dennis,
I have on my desk, all in varying stages of being read:
Inmon's book Building the Data Warehouse (very understandable)
Kimball's articles from his site and from the
Intelligententerprise.com
site (somewhat understandable, I
by: [EMAIL PROTECTED]
23-05-2002 11:13 PM
Please respond to ORACLE-L
To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
cc:
Fax to:
Subject:RE: Data Warehouse
experts, a simple question
for you| Outdated?
Dennis
: Data Warehouse experts, a simple question for you| Outdated?
Date: Thu, 23 May 2002 07:33:26 -0800
Rachel
- Glad Inmon's book is working for you. I have only read (or more
correctly attempted to read) his articles, which can be found at
http://www.datawarehousing.com/, or at least
-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Data Warehouse experts, a simple question for you
gee, and here I thought all I had to do was put the book under my
pillow and let the words
:
Subject: RE: Data Warehouse experts, a
simple
question for you
05/21/2002
08:28 PM
PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Data Warehouse experts, a simple question for you|
Outdated?
I am new to his books, three chapters in. The first release of the Data
Warehouse
[EMAIL PROTECTED]
Sent by: rootcc:
Subject: RE: Data Warehouse
experts, a simple
question for you
05/21/2002
08:28 PM
MacGregor, Ian A. [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/21/2002 05:48 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Data Warehouse experts,
a simple question for you| Outdated?
I am
:
Subject:
RE: Data Warehouse
experts, a simple
question
for you
05/21/2002
08:28 PM
Please
respond to
ORACLE-L
.us
[EMAIL PROTECTED]
Sent by: rootcc:
Subject:
RE: Data Warehouse
experts, a simple
question
for you
05/21/2002
of
list
ORACLE-L
.us [EMAIL PROTECTED]
Sent by: rootcc:
Subject: RE: Data Warehouse
experts, a simple
question for you
05/21/2002
Warehouse experts, a simple question for
you| Outdated?
I am new to his books, three chapters in. The first release of the Data
Warehouse Toolkit defines a data warehouse much as a data mart is today.
Today we think of a data warehouse as having a highly normalized
structure which stores
:
Subject:Re: Data Warehouse experts, a simple question for you
looks like published aug of 98 for that book?, like $60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK is stored
as an FK in the fact table.
That way you can select from
ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: Data Warehouse experts, a simple question
for you
looks like published aug of 98 for that book?, like $60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK is stored
as an FK
Warehouse experts,
a simple question for you
looks like published aug of 98 for that book?, like
$60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK
is stored
as an FK in the fact table.
That way you can select from the time dimension
to ORACLE-L
To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: Data Warehouse
experts, a simple question
for you
looks like published aug of 98 for that book?,
like $60?
joe
[EMAIL PROTECTED] wrote
PROTECTED]
cc:
Subject:Re: Data Warehouse
experts, a simple question
for you
looks like published aug of 98 for that book?,
like $60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK
apart. Make sure that you have few gallons of water
at hand, though.
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Data Warehouse experts, a simple question for you
gee
:Re: Data Warehouse experts, a simple question for
you
looks like published aug of 98 for that book?, like $60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK to the time dimension. The PK is stored
as an FK in the fact table.
That way you can select from the time dimension by year
PROTECTED]
05/20/2002 05:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list
ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: Data Warehouse
experts, a simple question
for you
looks like published aug
.
-Original Message-
From: Rachel Carmichael
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Data Warehouse experts, a simple
question for you
gee, and here I thought all I had to do was put
the book
Title: RE: Data Warehouse experts, a simple question for you
Okay you guys are silly. I have probably a stupid basic question to ask. How important is it to store data (let's say state codes, county codes with leading zeroes as character versus numeric). What is the standard out there? Does
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/20/2002 05:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Data Warehouse experts, a simple question for
you
looks like published aug
that you have few gallons of
water
at hand, though.
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 4:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Data Warehouse experts, a simple question for you
gee, and here I
PROTECTED]
cc:
Subject:Re: Data Warehouse
experts, a simple question
for you
looks like published aug of 98 for that book?,
like $60?
joe
[EMAIL PROTECTED] wrote:
Joe,
Add a generated PK
Ok i'm messing with dimensions.
dm_time to be exact:
create table dm_time
( calendar_date date not null,
calendar_month number(2) not null,
calendar_qtr number(1) not null,
calendar_year number(4) not null);
insert into dm_time values(to_date('20020101','MMDD'), 1,1,2002);
insert
1 - 100 of 130 matches
Mail list logo
