Andrea,
Here is a version of the function you asked for, IT IS NOT WELL
TESTED, should give you something to go on.
Scott Crabtree
FUNCTION calc_avg (student_id IN NUMBER)
RETURN NUMBER
AS
CURSOR student_c
IS
SELECT snum
|| call# class, credit, RTRIM
er sectors. This is simply
because
of the circular shape of a disk drive."
Scott
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Crabtree
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
Title: RE: Database Down
Here some help from Paul Drake on NT
diagnostics tools you can put in place to send yourself event
logs.
Sample code to email event logs
C:\>blat -install mail.mydomain.com
[EMAIL PROTECTED]
Failed to open registry key for Blat profile , using
default.
SMTP server s
7;||chr(34)||'CMD /C DEL /Q @FILE'||chr(34)||';');
HTH, (hazardous terminal halitosis)
Scott Crabtree
-Original Message-
Sent: Wednesday, May 23, 2001 11:45 AM
To: Multiple recipients of list ORACLE-L
DBAs
How do I delete files from NT which are older than a week. I
e view and
join my_all_cons.tname = A.table_name in the outer. Great for watching
recursive sql for those with Unabridged Data Dictionaries
HTH,
Scott Crabtree
-Original Message-
Sent: Monday, May 14, 2001 11:31 AM
To: Multiple recipients of list ORACLE-L
4
INDEX RANGE SCAN AD_24_IDX_1
FILTER
TABLE ACCESS BY INDEX ROWID AD_25
INDEX RANGE SCAN AD_25_IDX_1
Scott Crabtree
Veritas Certified Survivor
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Cra
and
Sorry for the long post
(I didn't include the query because it make this post even
longer, if anyone would like to see it I will email it offline)
Scott Crabtree
Professional Software Systems
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Crabtree
IN
(Oracle8i Supplied PL/SQL Packages Reference)
HTH,
Scott Crabtree
-Original Message-
Sent: Saturday, March 31, 2001 7:00 PM
To: Multiple recipients of list ORACLE-L
Hi!
Is there a function in Oracle that returns a random number, when it's
called?
e.g. rnd (1,1000) should return a r
Helmut,
Try
update tablename set column1 = value1, column2 = value2 where rownum < 1
Scott Crabtree
-Original Message-
Sent: Thursday, March 29, 2001 6:51 PM
To: Multiple recipients of list ORACLE-L
Hi!
Can I update two columns in a single update statement? What is the ex
For dedicated server connection, this is part of process memory (PGA). For
multi-threaded server, the UGA is allocated from either the Shared Pool or the
Large Pool, if the Large Pool is configured (recommended).
Regards,
Scott
Crabtree
-Original Message-From:
Chuck Hamilt
, if you are
just trying to build a logical model you can strip most of the columns out
of the text file and start from there.
HTH,
Scott Crabtree
-Original Message-
Sent: Friday, March 23, 2001 8:21 AM
To: Multiple recipients of list ORACLE-L
Hallo,
I am doing a reverse
n
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Crabtree
INET: [EMAIL PRO
ame of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Crabtree
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Missing a , at m099VARCHAR2(104)
HTH,
Scott Crabtree
-Original Message-
Sent: Thursday, March 08, 2001 11:48 AM
To: Multiple recipients of list ORACLE-L
__
Pat Gorden-Ozgul BNL-ISD Systems
[EMAIL
14 matches
Mail list logo