is an art !!
-Original Message-----
From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003
1:54 PM
To: Multiple recipients of list
ORACLE-L
Subject: Forcing 2 Decimal
Positions
I know this must be extremely simple, but the only
thing I can find for this is column forma
Title: Forcing 2 Decimal Positions
I know this must be extremely simple, but the only thing I can find for this is column format and that doesn't work, so could someone tell me how to force an amount field to show 2 decimal positions? I have tried format 999.99 and 990.00 but it will not prin
Title: Select Statement Gone South??
Never mind...I found my problem!! I had one key that had not been indexed.
Laura
-Original Message-
From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 25, 2003
7:24 PM
To: Multiple recipients of list
ORACLE-L
Title: Select Statement Gone South??
I am inserting records into a table based on a select statement and it is taking way too much time. I have created indexes of the foreign keys and tried to rearrange the where clause to omit records earlier, but to no avail. The statement looks like this:
Title: Sort (Collating Sequence)
I have a question concerning a situation with our ORDER BY clauses. We have a vendor table which allows the user to input any case. Therefore we have 'Vendor' and 'VENDOR'. When using the ORDER BY clause it sorts VENDOR first and then Vendor. I need for the
_output.put_line(sqlerrm);
end;
/
You can use the rowids in the look-aside table to zap
the bad values later.
HTH
Jeff Herrick
On Thu, 5 Dec 2002, Burton, Laura L. wrote:
> Since we don't have that many 3rd party software packages I did make the
> mistake of asking 'Why??&
Title: RE: To_Number
Since we don't have that many 3rd party software packages I did make the mistake of asking 'Why??' and received 'Because!' so I too am trying to jump in and 'fix it'. As I responded to another email earlier, the RTrim worked because there were spaces after the amount whic
: Multiple recipients of list
ORACLE-L
Subject: RE: To_Number
My guess is that you have
leading or trailing spaces. try
select to_number(LTRIM(RTRIM(unit_cost)),'$999,999,999.99')
from elas.qdr
-Original Message-----
From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]
Sent
Title: To_Number
I have a table which contains a Unit_Cost varchar2(16) which contains $34,000.05. I can enter select to_number('$34,990.08','$999,999,999.99') from dual; and the results is 34990.08. However when I enter select to_number(unit_cost,'$999,999,999.99') from elas.qdr I get ora-0
Title: RE: PIC 9(9)V99 ??
This represents 11 digits with an implied decimal point.
We still have a mainframe. :)
Laura
-Original Message-
From: Grabowy, Chris [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 12, 2002 7:14 PM
To: Multiple recipients of list ORACLE-L
Subject:
Title: RE: Changing column format
1. Backup Table
2. ALTER TABLE user DROP PRIMARY KEY CASCADE;
This will drop the constraint and delete all foreign key relationships
to userid.
3. ALTER TABLE user ADD CONSTRAINT username_pk PRIMARY KEY (username)
USING INDEX TABLESPACE USER_INDE
ional
-Original Message-
From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 4:00 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Oracle to Excel
Thank you for your
response Tom. I received other responses
as well, and I know that I can comma delimit a
in cells.
hope this helps.
Tom Mercadante
Oracle
Certified Professional
-Original Message-
From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002
1:49 PM
To: Multiple recipients of list
ORACLE-L
Subject: Oracle to Excel
I think I have seen
Title: Oracle to Excel
I think I have seen traffic concerning the extracting of data from Oracle into an Excel spreadsheet. We now have a need for this. Could anyone enlighten me?
Thank you in advance.
Laura
Title: Access with ACCESS
How do I stop users from accessing Oracle tables with Access? They have rights to the tables in Oracle and should have those rights, yet I do not want anyone to be able to pull the data off into an access database. Is it possible to stop this without taking their pr
Title: Driver
Does anyone have the executable of the MDI odbc driver? One of the .dll files is MDMDI32.dll. I have contacted ViaServ and have been told that they no longer have this driver, but instead want me to upgrade to their new driver. I already have this driver and it does not work w
.
Kevin Kennedy
First
Point Energy Corporation
If you take RAC out of Oracle you get OLE! What
can this mean?
-Original Message-
From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 07, 2002
10:23 PM
To: Multiple recipients of list
ORACLE-L
Subject: Internal
: Any clod can have
facts, but having an opinion is an art!
-Original Message-
From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 1:27 PM
To: Multiple recipients of list
ORACLE-L
Subject: UPDATE Results
Is there a way to access 'something' that
would den
Title: UPDATE Results
Is there a way to access 'something' that would denote if any rows were updated?
Feedback lets you set up how many rows will be effected before a count is returned, but WHERE is this number coming from?
I have found a 'Returning' clause of the update statement, but I
Title: Trigger or
Nope.
We have a document number which consists
of a serial number, date, location, etc, etc. The business rule is to have the serial
number start back at one each day.
-Original Message-
From: Khedr, Waleed
[mailto:[EMAIL PROTECTED]]
Sent: Tues
Title: Trigger or
I have a need to reset a sequence number at 00:01 everyday. I thought about creating a trigger to check the time, but thought that there might be a better way than checking the time every time a record is being added. I also thought about checking the max date on the t
Title: Package/Procedure
Is there a naming convention for procedures and/or packages?
Thank you,
Laura
Title: RE: Still Problem with ORA-12514
I have had one instance (out of many) where using a hostname would not work. I was getting the same error and I had to use the IP address in the Listener to get it to work. There were two IP addresses and the listener was accessing the second address w
Title: Dynamic SQL
We have Oracle version 8.0.5 and need to use dynamic sql. Through research I know that there is a dbms_sql package that is suppose to support this, but we cannot find an example of what we are needing to do. We have been told that we can do it easily in '8i' but we are not
Title: Security for Table/Procedure
I know that you can grant access on a table whether it be select, update, delete, etc, and I know that to keep from granting access to a table you can use procedures and grant execute rights to the procedure.
Our situation is that we want to use procedure
r TWO_TASK !!
Regards
Lee
-Original Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]Sent: Thursday, December 13, 2001
6:10 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: SqlLoader
Thank you for your reply. The user does have
DBA right
eff
Tempe, AZ
- Original Message -
From:
Burton,
Laura L.
To: Multiple
recipients of list ORACLE-L
Sent: Wednesday, December 12, 2001 3:35
PM
Subject: SqlLoader
I have never had a problem with sqlloader before,
but now when I run it I get an erro
Title: SqlLoader
I have never had a problem with sqlloader before, but now when I run it I get an error 'invalid name/password' message. I can sign on svrmgr and through sqlplus with no problems.
Any ideas?
Thanks,
Laura
Title: Password Changes
When you alter a user's password, what table does it update?
I need to 'restore' a password for a user back to what it was before I changed it, but do not know what it was.
Any ideas?? Can this be done?
Thanks,
Laura
Title: Privileges
I have granted 'all' to a table owned by owner1 to a role. I granted this role to user1. User1 can access this table via SQL*Plus and Developer. However, when developing a procedure/package in Procedure Builder under program units, and then dragging it down to the bottom a
Title: RE: Online backup script..
My, my...were you afraid he wouldn't understand the 1st reply?
In the vein of 'if you were the last man on earth...' you can delete my mails in the future, because you can be sure I will be deleting yours.
Have a good day anyway!!
Laura
-O
Title: RE: SID on sqlplus prompt?
I use this as well but it only works going through Sqlplus. If you want to change connections while you are in sqlplus by entering sql> Connect username@dbname, then the sid/username will not change on the sql> prompt. To make the connection change show, add
Title: RE: Sqlloader on VSAM file
Raymond,
Please
forgive me, but I am not sure now if you are asking a question or stating that
you're ok. Your control file looks ok except I 'define' my fields
differently. I am sending you an example below. I am assuming your
amount fields has 2 deci
Title: RE: Sqlloader on VSAM file
I do the same thing here at my shop and the record I download from a vsam file is 3574 in length. When I view the download in the .txt format it is wrapped just like what your records look like below. However, a new record does start on a new line, and it lo
Title: Resolved!! Another Downed Database
I wanted to let everyone know that my (un)archived, no cold backup database is now up!! I took Oracle's advice and started with the full physical backup and did not apply the differential backup. I then entered Recover Database and when the messsage
Title: Another Database Down
Just
to put you a little more in the picture I have recovered a couple of DBs now
without archived redo log files etc where all hope had been lost and resumes
were being updated and got them back by fudging a couple of issues. (Oracle
would probably throw thei
Title: RE: BUNYAMIN POSTS HAVE A VIRUS
Didn't he send an email to the list yesterday apologizing for this and stated that he had no idea it was happening?
Laura
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 9:10 PM
To: Multiple recipie
Title: Another Database Down
No, I
did not know about this. Could you explain or tell me where I can find
info on this?
Laura
-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 24, 2001 3:51
AMTo: Multiple recipients of list
Title: Virus Warning
I received an email from Bunyamin K. Karadeniz in response to an earlier 'Database Down' message that I had sent to the list. The email from him had an attachment to it. I opened it (I know this was not wise) and our virus scan had deleted the file and left a message sta
-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]
Amen Sister!! I am afraid you all will have to be my
virtual party people, since I am the only one around here that got
excited when the recovery was done...so have a great
time
Title: Another Database Down
Well, I think the time for jubilation has been short-lived for me. The production database was recovered successfully due to archiving and luck. I also have a small, inhouse, remedy (help desk) database that I haven't done anything with and now recovery is necess
PROTECTED]]Sent: Wednesday, May 23, 2001
3:12 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Database Down
>-Original Message- >From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]
> >My database is up and with
no data loss!!!
Congratulations! I
Title: RE: Database Down
My database is up and with no data loss!!! I was able to do a complete recovery, not incomplete.
After the coca-cola (for caffeine) to calm my nerves I had the sysadmin restore the datafiles and archive logs from the hot backup from Friday. The control files 1 and
Title: Database Down
I have an Oracle 8.0.5 database residing on a Windows NT operating system which uses Raid5. The 'almost never' has happened; two disks have gone bad at the same time. As fate would have it the 'complete' physical backup performed the day before the disks crashed (Friday,
44 matches
Mail list logo