There's also a tool from Embarcadero called ER Studio, which is my personal
recommendation at the moment. I used to recommend ERWin, but then CA
bought it and it has only been lackadaisically maintained since then.
I think there are others...basically any decent ER modelling tool (and
Visio is
Neat! I knew there was some way of selecting that, but couldn't remember
it and also couldn't find them in the FM. Didn't someone complain about
the terrible indexes on Oracle manuals? Let me add my voice to that
particular clamor.
Diana Duncan
TITAN Technology Partners
One Copley Parkway,
How about something like this? Of course, it requires that the user have
select access to v$instance -- maybe there's another place to find this.
You could do some sort of batch to reference the $ORACLE_SID instead, but
the advantage of this is you can put it into glogin.sql or login.sql -- or
While on the one hand I completely agree, as in my opinion Perl is the
absolutely bestest, yummiest and downright smartest language I've ever
encountered -- if you learn it first, you'll never be satisfied or happy in
any other language again ever.
;-)
Also, as a learning language, it can be
Ooh, a fun one. If you are sure of the format of the data (as you'll see
in the following function) you can create a function to make the data
numeric. I can't think of another way to do it, but maybe someone else
can?...
create or replace function fractionToDecimal (str in varchar2) return
I don't know about that...am I the only one that finds Feuerstein's books a
bit too pithy and not real enough? (No disrespect intended) I've
certainly toyed with the idea of a PL/SQL book with real-life situations
and examples, especially in the use of triggers and packages for enforcing
Oh, that would be great! Add some tips on how to spec out a system, and
I'm buying it!
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
Here are some sed commands that do what you want -- in the [] brackets,
there is a space and a tab.
$ cat removeblanks.sed
/^[ ]*$/d
s/^[]*//
s/[ ]*$//
Here's a test file.
$ cat test.txt
This is a real line, the lines above are a carriage return, a tab and
spaces.
Harvinder,
You must have a carriage return at the end of the enum variable. Try
rtrim, like this:
name2 :='t_pv_'||substr(rtrim(enum,chr(10),i+1)||'_2';
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL
In addition to the reason for your error, which someone else has pointed
out, this piece of code has another problem -- you never close your cursor.
This will get you into no ends of trouble at some point in the future, so I
though I should point it out. Also, a cursor for loop would be much
Yeah, that's what I was going to suggest. QUIT used to do an exit without
a commit, but now it commits it just like EXIT does. I wonder why they
changed that? Now they are just synonyms of one another.
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
Richard,
The discussion so far has not found a way to turn that off -- even set
autocommit off will still commit when you exit (or quit, dang it), unless
you EXIT ROLLBACK; Did you find another way? Or is that what you mean?
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
select col1, col2
from table1
where (col1 = 'A' and col2 between 'A' and 'E')
or (col1 = 'B' and col2 between 'A' and 'X')
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
There's an excellent tool by the company Kintana that automates the
deployment of software (which can include stored packages and procedures,
as well as shell scripts, SQL*Loader, whatever). The developer creates a
release with the file names and version numbers in PVCS or ClearCase, and
the
You mean like the programmers of the Oracle Applications? What would we
need for that, a missile?
(What kills me is that, they don't use declared foreign key constraints in
the database. Presumably, since the code base is so old, if they
introduced them now everything would break. You'd
Isn't that sort of like Taoism? Accept your lot, there must be good in it
somewhere...
Also, it seems to be the basis of many major religions to essentially never
ask why. So, I guess it's a pretty popular philosophy.
(Oh no, I feel a discourse by Eric coming on...)
Diana Duncan
TITAN
Sure, and thanks. I appreciate the corrections, as one problem with doing
this for a while is the aggregation of useless and no longer true facts,
which I'm finding I have more and more of. They feel like barnacles. :)
I've finally decided to go get my OCP, which I hope will help scrape some
Cherie, I have no idea if this could be the case, but I noticed that the
type is based on the datatype VARCHAR, not VARCHAR2. According to the
docs, this shouldn't make a difference, but they've been warning since the
introduction of VARCHAR2 that they may do something different with VARCHAR
at
It's free.
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
I think the error is in the call to the procedure, not in the procedure
itself -- the procedure looks fine at a glance. Could you post the ASP
code that makes the call?
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F:
Satish,
You can do a couple of things...in the query you could to a
replace(column1, chr(10), '~') (or some other unlikely character or
string), then do a replace again in the SQL*Loader script to get the
carriage returns back in there. Or you could use the query to put a
character in the
Whyever would you want data inserted in order? There is no guarantee that
Oracle will actually store the records in order, there is no performance
gain, and you can always retrieve the records in order by using an order by
statement -- if you really need ordered data, you could use a
In 8.1.6, you don't have to have the one column in the database. Use
'FILLER' as the data type.
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
My husband is Scottish, and he heard from a Scottish pal of his that top
Oracle consultants can earn up to ?1000 a day in Edinburgh! Made me want
to up and go, I'll tell you...then again, having a husband with a British
passport means I can work without too many problems.
Regards,
Diana
You probably don't have . in your path (which is good security). Preface
the call to your script with ./
./test.sh
On the other hand, you may not have the magic comment at the top of the
script, like this:
#!/bin/ksh
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
In 8.1.x, as long as your schemas have their own tablespaces, you could to
TSPITR (Tablespace Point in Time Recovery).
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
Oracle HAD to rename it -- they have consistently changed the name with
each release, so they couldn't stop now!
A brief history, from what I remember:
Oracle Webserver 1.x
Oracle Web Application Server 2.x
Oracle Web Application Server 3.x? (whoops, I guess they kept it once,
anyway I can't
Example of a SQL*Load control file to load a file, skipping the first line,
replacing the data in the table, with comma-separated, double-quote
enclosed data, using the decode function on one of the columns.
OPTIONS (SKIP=1)
LOAD DATA
INFILE data.dat
INTO TABLE mytable REPLACE
FIELDS TERMINATED
And sure, you can criticize, but only in America are you in danger of being
run down or shot for having a bumper sticker expressing an opinion on
politics or abortion or religion or NASCAR...I'm especially nervous now
that Eric has told us that all these women are carrying guns now. :)
I love
The only way I know of to do this is with self-joins, and you have to have
a known upper bound of the number of Relations per ID. An example
(warning, untested, off the top of my head):
select t1.id, t1.relation || ' ' || t2.relation || ' ' || t3.relation
from relationtable t1, relationtable
Ooh, I like this one better! Disregard mine, I hate all the characters you
have to put into replace().
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
You could always write your own function. Or you could do something using
the replace() function, maybe like this (again, untested):
select circ_id, circ_num from circuit
where replace(circ_num,
'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890',
tablespace?
The last DBA put all of our indexes into three tablespaces
(small, medium, large) which doesn't work very well when you
go to get rid of a partition.
Thanks,
Cherie
Diana_Duncan@ttpa
rtners.com To: Multiple recipients of
list ORACLE
I always wondered what DIANA stood for... :)
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
Nope, not yet. It's on my list of things to test and do with the system.
Right now, I'm just doing the design and development -- I know, I know, I
should probably architect the system better first, but this really is just
a family project at the moment.
When I do get to testing and scaling and
Yes, it's open source.
My personal project uses Apache, PHP and Postgres on Linux servers -- pure
open source. Guess how long the servers and the web server and hence the
site have been up? Pretty much since we installed. Love it!!! For those
of you who don't know, PHP is a server-side
Oooh, I *like* Postgres. I'm having super much fun with it on a personal
project right now, and I must say they really trump Oracle on a few things.
Of course, I don't know how it handles large amounts of data or users or
transactions yet...and I know nothing about the tunability. But it
Yeah, Stephane, that's actually one of the reasons I suggested not using a
commit-within cursor loop thing. The suggestion I made wouldn't do that --
or am I missing something?
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F:
What's your version of Oracle? I usually have a stock answer on how to
solve this type of problem, but I just tried out your problem on my little
Personal Oracle here, and to my INCREDIBLE surprise, the trigger worked and
I didn't get an error. Does anyone know if that's just because I'm using
Hey all,
I know that this has been addressed on the list before, so if there's an
archive yet (I've been away for a bit) just point me to it. I made the
terrible, heinous mistake of 1) installing Personal Oracle 8.1.6 on my
laptop, which went well, then 2) installing Oracle Developer 6i on the
Thanks so much to everyone who replied! It seems to be working now. And,
I agree completely with the RedHat idea, but this is my consulting laptop,
and Windoze is very much the name of the game.
Actually, at home I have RedHat, but I don't have Oracle -- it's running
Postgres, which I must
Lisa,
This is unfortunately quite difficult -- and if you have any circular
dependencies it's pretty much impossible. Otherwise, what you need to do
is follow the dependencies in the dba_constraints view.
For the drop order.
1) Drop all of the tables for which their PK constraint is not
Actually, Lee, you should enlighten us. The last time I was in the U.K.
for any length of time (1998) the McD's there had far more non-beef and
even vegetarian options, which are only now catching on here. So what can
we expect in the next few years from the enlightened McD's of Europe?
Diana
But of course -- just use a negative one as the position to the instr
function.
From the SQL manual:
INSTR searches string for substring.
position is an integer indicating the character of string where Oracle
begins the search. If position is negative, Oracle counts and searches
44 matches
Mail list logo